TM1 Forum

Hi all, I'm using the PAX API to execute an MDX view and am receiving a "504 gateway timeout error". I can run exactly the same command using the REST API (running via a PowerShell script) and it works just fine. Does anyone have any ideas why the PAX API would return this error? Any ideas...

Thanks, unfortunately I think that is based on an old version of the API.

Thank you all for your contributions. I can see how that will work for creating views, but unfortunately I can't get it to return the aliases when using the API. The cellset axes always seem to just contain the member caption. Any ideas?

Thanks, yes that's the method I'm using to get the original MDX. It does show some additional lines that refer to the selected alias, but when run via execute MDX it seems to ignore these instructions.

I'm sure there must be a way some how!!

Hi, thanks for the idea. I haven't tried that. To be honest, I'm not sure how / where that would fit into my MDX. Please could you explain how that would fit together?
Thanks

Hi all, I'm attempting to formulate some MDX in such a way as to return aliases rather than member captions. I've found two issues around this subject on the tm1py github repo, but not much else! https://github.com/cubewise-code/TM1py-samples/issues/28 https://github.com/cubewise-code/tm1py-samples/...