Filtering of Cube Descending

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

Post by appleglaze28 »

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.
User avatar
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

Post by Martin Ryan »

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