Tm1py: execute_mdx_dataframe_pivot column order is not same as MDX

[yyzz1010]

Describe the bug
even i stated "Sales Qty" first, and "Sales Amount (LCY)" second for M Sales dimension as columns, the column order in pivot table is not same as MDX

To Reproduce

Expected behavior
pivot table column order is shown according to MDX given

Version
TM1py Version: 1.5.0
TM1 Server Version: 11.8.0.33

[MariusWirtz]

Hi @yyzz1010,

thanks for reporting the issue. I will look into this.

Pivot tables in pandas are real beasts. Perhaps for the moment, it's easiest if you just use the execute_mdx_dataframe_shaped function. Then you get a normal data frame but in the shape of the query/view.

[yyzz1010]

Thanks @MariusWirtz, this is exactly what I want!! but this function is not documented here so I didn't know about it.

[MariusWirtz]

Happy to hear that this is helpful for you.
I will regenerate the docs.

To know what functions are available in the different services I would recommend also using the autocompletion features of tools like Juypter or PyCharm. It can be a good way to discover the functionality in TM1py.