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
active form stacked dimension filter by level
-
- Posts: 16
- Joined: Sun Jan 17, 2016 3:15 am
- OLAP Product: Cognos TM1
- Version: 10.2.2 Fix Pack 5
- Excel Version: 2010 32 bit
Re: active form stacked dimension filter by level
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...
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
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: active form stacked dimension filter by level
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...
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7