TM1 Forum

Hi,

We have a dimension such as
ProductA
ProductA.0112
ProductA.0212
...ProductA.1212
ProductB
ProductB.0112
ProductB.0212
...ProductB.1212

we want process in which we can sort out above hirearchy in the decreasing order dynamically, we can use MDX expression for the same but level is not fixed, so we can't use MDX expression filter by level.
so, we can see finally in dimension
ProductA
ProductA.1212
ProductA.1112
...ProductA.0112
ProductB
ProductB.1212
ProductB.1112
...ProductB.0112

Kindly suggest the process to solve this.

Post moved by Administrator.

Please keep all questions relating to TM1 in the main TM1 forum. The useful code, hints and tips sub forum is for people publishing help in advance. It is not for questions.

Hi All,
I am still waiting for a reply.

bsjain wrote:I am still waiting for a reply.

I'm going to assume that's a "different native language" thing and wasn't intended to be an expression of impatience given that people here aren't compensated for their time and knowledge.

(I mention this only because there are some who may take a strident exception to a follow-up post expressed in those terms, so I thought it best to pre-emptively extinguish that particular spot fire before it actually flares.)

In relation to your question, have you looked at the TurboIntegrator function DimensionSortOrder? It can be found in the Reference Guide. Assuming that you update the dimension through TI you can add the sort order to the end of the updates to get the elements into the sequence that you want.