active form stacked dimension filter by level

Post Reply
aph1985
Posts: 5
Joined: Thu Jul 30, 2015 6:34 am
OLAP Product: TM1
Version: PA 2.0.2
Excel Version: 2016

active form stacked dimension filter by level

Post by 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
tm1.jpg (79.85 KiB) Viewed 2107 times
Is there any way MDX can help write this?

Cheers
wheeler6
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

Post by 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...
User avatar
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

Post by 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...
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
Post Reply