Print Page - filter a member of a hierarchy

Title: filter a member of a hierarchy
Post by: philelmousse on 25 Jan 2012 04:47:11 AM

Hello,

I try to exclude a member of my hierarchy in a crosstab. I created a calculated member expression :

[REPORTING LAYER].[CATEGORY].[CATEGORY].[sub_cat]->[all].[vehicule].[cars]-
[REPORTING LAYER].[CATEGORY].[CATEGORY].[sub_cat]->[all].[vehicule].[cars].[bmw].[286592812])

But it doesnt work. What is the correct way to do that ?

Thanks

Title: Re: filter a member of a hierarchy
Post by: Grim on 25 Jan 2012 08:42:17 AM

See the following:
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14641809

Should help you get what your looking for.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 25 Jan 2012 04:47:11 AM