Data Extract from TM1 with indentation enabled basis on hierarchy

[Ishmeet-star]

Hi @MariusWirtz ,
Can you please suggest if indentation can be achieved for parent child hierarchies in the cube view extract in execute_dataframe_shaped somehow?

Thanks in advance.

[MariusWirtz]

I recommend post-processing

• First retrieve the data from the cube view as a dataframe (tm1.cells.execute_mdx_dataframe(mdx, ..., shaped=True)).
• Then retrieve the elements from the row dimension with the level attribute as a dataframe. Execute MDX against the }ElementAttributes_ cube and include the level member property as a calculated member in the MDX query.
• Then apply the indentation

Please let us know how it goes and feel free to share your script here if it works

[Ishmeet-star]

Thank you so much it worked for me