filter a hierarchy

[philelmousse]

Hello,

In my model I have a dimension "Category" with 3 differents hierarchies. I want filter a hierarchy with some categories and the other with other categories. My level "category" is composed by the "category_name" as memberCaption and "category_id" as business key.

How to do that ?

[philelmousse]

I will try to be more explicite...

I have a dimension named "Category".

I want make a hierarchy with (Category1, Category2) and another hierarchy with (Category3, Category4). Is it possible ?

[blom0344]

I think you need to make sure that you filter in the relational model you base the dimensions on.
The filter in the dimension will always work on all hierarchies.

So basically use calculated dataitems in the relational object to split into 2 sets:

CASE << SOME OBJECT >>
WHEN << EXPRESSION1 THEN 'Category1'
WHEN << EXPRESSION2 THEN 'Category2'
ELSE NULL
END


CASE << SOME OBJECT >>
WHEN << EXPRESSION3 THEN 'Category3'
WHEN << EXPRESSION4 THEN 'Category4'
ELSE NULL
END

[bdbits]

You may want to put this in the model. In Report Studio you can also use the set() function.