active form stacked dimension filter by level

[aph1985]

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

tm1.jpg (79.85 KiB) Viewed 2737 times

Is there any way MDX can help write this?

Cheers

[wheeler6]

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...

[jim wood]

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...