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
Selection of Multiple level data
-
- 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
-
- 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
What sort of alternative do you want when filter by level gives exactly what you need?
Declan Rodger
-
- 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
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
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
-
- 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
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.