Selection of Multiple level data

Post Reply
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Selection of Multiple level data

Post by deepakjain2020 »

Hi All,

I was looking for having level 2 and level 3 elements in dimension.

followed the use of "FILTER BY LEVEL" by selecting 2 and 3 together (It provides multiple value selections).
If any other alternates, plesae share.

Regards,
Deepak Jain
declanr
MVP
Posts: 1831
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: Selection of Multiple level data

Post by declanr »

What sort of alternative do you want when filter by level gives exactly what you need?
Declan Rodger
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: Selection of Multiple level data

Post by deepakjain2020 »

Hi Declanr,

My intention was to know if someone might have different approach, so that I can have understanding and learning.
I shared the information, so that it might be helpful for other.

Regards,
Deepak Jain
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: Selection of Multiple level data

Post by tomok »

A different approach would be to create an attribute on the dimension called Level_No and filter based on that. Of course, you would be have to populate that attribute yourself, either via rule or data input.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply