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 »

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: 1815
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 »

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.
Declan Rodger
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 »

Thank you.

I'll try.
Luc Batis
São Paulo, BR
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Drill down in only a row

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
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 »

Is test data.

This is my homologation environment.
Luc Batis
São Paulo, BR
Boas
Posts: 12
Joined: Mon Sep 07, 2020 12:54 pm
OLAP Product: Planning Analytics
Version: 2.0.8
Excel Version: MS 365

Re: Drill down in only a row

Post by Boas »

Hi,

maybe my quastion should be a new topic, but it highly related to this one.

How can I achieve the old Architect-behaviour in a PAW cube view? By default, a consolidation is just extended in the row I click. What if I want to extend it in all rows?
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Drill down in only a row

Post by lotsaram »

Boas wrote: Tue Nov 29, 2022 10:28 am How can I achieve the old Architect-behaviour in a PAW cube view? By default, a consolidation is just extended in the row I click. What if I want to extend it in all rows?
You have chosen to wake up quite an old thread. Short answer, you can't. PAW only does asymetric drill-down. In general I think this is actually a good thing. In most cases it is what the end user wants.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Drill down in only a row

Post by Steve Rowe »

the Lord giveth and the Lord taketh away
Job 1:21 in case you want to know, not the Apple guy. (I had to look this up, just in case anyone gets ideas about my detailed knowledge of scripture!)

This kind of thing should be configurable and left in the hands of the user.

It's massive assumption and generalisation to say "most users want it to behave this way", IMO of course...

Cheers,
Technical Director
www.infocat.co.uk
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Drill down in only a row

Post by gtonkin »

Maybe not the most elegant option but works with two clicks:
- Right click in the header area above the first element
- Navigate to Level options then select the highest number i.e. expand to that level for all items.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Drill down in only a row

Post by lotsaram »

Steve Rowe wrote: Tue Nov 29, 2022 2:47 pm This kind of thing should be configurable and left in the hands of the user.
FWIW I agree. Ideally there should be a toggle in the row dimensions area for symetric vs asymetric drill-down. As a user this is what I would want. But if I have to choose between one and the other then I would take asymetric. The way it used to work has always been a pain drilling down everywhere when you only wanted to see where you clicked.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply