Drill down in only a row

Post Reply
gernosh
Posts: 5
Joined: Wed Jan 23, 2019 6:37 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Drill down in only a row

Post by gernosh » Wed Mar 13, 2019 5:57 pm

Hello guys,

I have this cube, and the customer would like to drill down into the Dimension Document, however, he wants to drill down into a consolidation, but that this does not occur with the same consolidation in other lines.

For example, in image one we have the data that the user uses in his analyzes.
But in image two, when he clicked on (+) the Drill Down of a consolidation, it all opened.



How do I open just the one that he clicks on?
Last edited by gernosh on Thu Mar 14, 2019 7:38 pm, edited 1 time in total.
Luc Batis
São Paulo, BR

declanr
MVP
Posts: 1605
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Drill down in only a row

Post by declanr » Wed Mar 13, 2019 6:05 pm

In architect/perspectives/tm1 web you can’t drill down on only 1 instance of an element that appears multiple times in a nested dimension.
If they are on PA this is something that can be achieved in the new interfaces such as workspace cube views.

gernosh
Posts: 5
Joined: Wed Jan 23, 2019 6:37 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Drill down in only a row

Post by gernosh » Thu Mar 14, 2019 12:37 am

Thank you.

I'll try.
Luc Batis
São Paulo, BR

User avatar
Steve Rowe
Site Admin
Posts: 1876
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Drill down in only a row

Post by Steve Rowe » Thu Mar 14, 2019 8:51 am

Hopefully this is test data you have posted? Many of our customers would object to having their results posted in public forums, even if its not-obvious what the numbers are.

gernosh
Posts: 5
Joined: Wed Jan 23, 2019 6:37 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Drill down in only a row

Post by gernosh » Thu Mar 14, 2019 1:12 pm

Is test data.

This is my homologation environment.
Luc Batis
São Paulo, BR

Post Reply