Print Page - Filter only 1 node from the level 3 in the hierarchy

Title: Filter only 1 node from the level 3 in the hierarchy
Post by: Jeka on 28 Sep 2009 12:08:09 PM

Hi,

I have a cross tab, using cube.

User can drill up and down in the crosstab.
Crosstab starts at level 2 of the hierarchy. then user can drill down to level 5.

Is it possible to filter only one node from level3 and anything under that node?
tuple(Local, Florida)
I dont need to see any transactions in that node that associates with Florida.
i still need to show this node.
Thank-you

Title: Re: Filter only 1 node from the level 3 in the hierarchy
Post by: rockytopmark on 29 Sep 2009 10:28:30 AM

use the Filter() function.

My guess is you may also need to incorporate the Caption() function for your filter's check

Filter([State Level],caption([State Level]) <> 'FLORIDA')

perhaps EXCEPT() may also be used...

just ideas

Title: Re: Filter only 1 node from the level 3 in the hierarchy
Post by: Jeka on 30 Sep 2009 03:41:45 PM

I cant get filter to work.

Any other ideas would be appriciated!

thank you

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Jeka on 28 Sep 2009 12:08:09 PM