TM1 Forum

Hi all,
We have a unique reporting requirement where we are asked to do an active form with stacked dimensions.
Dimension 1: Account dimension
Dimension 2: Lines

In normal active form, all the n level elements under the c level elements will be expanded for all dimension.
However, I would like to see C level in Dim 1 is only showing C level in Dim 2. N level in Dim1 showing C and N level in Dim2.
See illustration below
Is there any way MDX can help write this?

Cheers

Unfortunately, I do not believe this is possible. I have tried exploring this as I have received a similar request.

You could build a reporting cube with a new dimension though display the data as requested... however, depends how complicated your dimensions are...

Have you tried using MDX for the second column? You would need something to link off so there would need to be a relationship between the 2 for the MDX to work off, rather than saying just display this...