filter a member of a hierarchy

[philelmousse]

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

[Grim]

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

Should help you get what your looking for.