Hiding lower levels in Hierarchy

Post Reply
DYNA
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

Hiding lower levels in Hierarchy

Post by DYNA »

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.
tomok
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

Post by tomok »

Create }ElementSecurity cube and set security to the NONE at the lowest level.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
DYNA
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

Post by DYNA »

Hi Tom.

Thanks a lot Sir.

Much appreciated.
Post Reply