TM1 Forum

Funnily enough I did google this I wouldn't call it funny, because you hide useful information for the helpers here. With the risk of being not very helpful, again , I would ask: why didn't you put your final, modified, formula here ? It would show us what you did before reaching out here. Anyway, ...

It would be good if you learn how to search online for help. Meaning, start Google, enter tm1rptrow, hit enter, and read the first hit you get. It's a page by IBM. Thank you for your incredibly useful response, how silly of me to ask for help on a forum designed to assist collaboration and provide ...

In which case do you know how I would access the code behind the report I made in Perspectives in order to add the MDX rule? Assuming this is an active form report, which it would have to be in order to filter like you want, the MDX statement would go in the TM1RPTROW formula for the Brand dimensio...

tomok wrote: ↑Tue Sep 24, 2019 11:19 am MDX cannot be used in a rule. You would use this in your report.

Ah right thank you!

In which case do you know how I would access the code behind the report I made in Perspectives in order to add the MDX rule?

Use MDX http://www.bihints.com/tm1sort_tm1sortbyindex_and_order . Thank you for the quick reply! I usually use performance modeller to build cubes / write rules etc and I have not encountered this sort of syntax before. If I were to replicate a sort rule similar to the link you provided, where woul...

Hi Really hoping you could help me out here I have made a perspectives application which is published onto planning analytics workspace On the sheet is a list of brands and then various measures (sales, markdown etc) It is great apart from the inability to sort by fields in the calculation dimension...