Planning Analytics (TM1) REST API Excel Functions

For 64 bit Excel on Windows

IBM Planning Analytics (TM1) Excel dynamic array custom functions to get cube view or mdx query values.

server: the REST API url + port (e.g. https://tm1restapiserver:1234)

You can write your own wrapper functions by using Application.Run("QueryMDX", server, user, password, mdx) in VBA.