Hi guys.
I have an Hierarchy consisting of 4 levels. Cluster -> Department -> Branch -> Business Unit. Cluster is my highest level and Business Unit is my lowest level.
In IBM PAW or Performance Modeler, is there any way to hide my lowest level, so that it doesn't allow me to drill down to this level in IBM PAW.
I've tried doing this through Subsets, but unfortunately, in my case, when I get to the branch level, it allows me to drill down to my lowest level.
Any suggestions?
I will highly appreciate it.
Thank you.
Hiding lower levels in Hierarchy
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Hiding lower levels in Hierarchy
Create }ElementSecurity cube and set security to the NONE at the lowest level.
-
- Posts: 22
- Joined: Mon Jul 29, 2019 10:09 am
- OLAP Product: PLANNING ANALYTICS (TM1)
- Version: 2.0.6
- Excel Version: Excel for office 365
- Location: SOUTH AFRICA
Re: Hiding lower levels in Hierarchy
Hi Tom.
Thanks a lot Sir.
Much appreciated.
Thanks a lot Sir.
Much appreciated.