Page 1 of 1

Drill down in only a row

Posted: Wed Mar 13, 2019 5:57 pm
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?

Re: Drill down in only a row

Posted: Wed Mar 13, 2019 6:05 pm
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.

Re: Drill down in only a row

Posted: Thu Mar 14, 2019 12:37 am
by gernosh
Thank you.

I'll try.

Re: Drill down in only a row

Posted: Thu Mar 14, 2019 8:51 am
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.

Re: Drill down in only a row

Posted: Thu Mar 14, 2019 1:12 pm
by gernosh
Is test data.

This is my homologation environment.

Re: Drill down in only a row

Posted: Tue Nov 29, 2022 10:28 am
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?

Re: Drill down in only a row

Posted: Tue Nov 29, 2022 2:27 pm
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.

Re: Drill down in only a row

Posted: Tue Nov 29, 2022 2:47 pm
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,

Re: Drill down in only a row

Posted: Tue Nov 29, 2022 5:42 pm
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.

Re: Drill down in only a row

Posted: Tue Nov 29, 2022 6:23 pm
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.