Filtering of Cube Descending
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Filtering of Cube Descending
Has anyone tried using filtering by descending? Is there any way to like filter a certain dimension level? Like example, I have I filter my companies in a cube descending in specific column, I was to able to filter it on a certain heirarchy level so when I drill down, the elements underneath that company is still below it and not having those leaf element follow the filtering since its hard to view the things when the lead elements are scattered everywhere.
- Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Filtering of Cube Descending
You mean filter by level? It's one of the buttons in the subset editor. Hover over the icons and you'll find it eventually (provided of course you haven't accidently removed the filter toolbar from the subset editor). It's got a funnel and a little pyramid on the icon. You can highlight more than one level. E.g. in your case you probably want all levels except level zero.
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer