Help filtering certain dimension values from dimension table while bui

[Ashreya]

I wanted to filter certain dimension values from the dimension table, while building the cube.

I used the SOURCE TABLE FILTER property on the dimension table and processed the cube, but it seems to include the dimension which I intend to exclude and resulted in incorrect totals.

When I used the SOURCE TABLE FILTER property on the FACT table, by specifying the dimension value I wanted to exclude, it does seem to exclude that value and generated the correct totals.

I have to exclude multiple values from 10 dimension tables, while Building the cube itself, so that the totals are correct.

I used the same SOURCE TABLE FILTER property on the fact table and tried to write the string to exclude values from 10 dimension tables, but the drop down accepts only upto 3 dimensions (some thing like "AAA_DIM"."AAA"=1 and "BBB_DIM"."BBB"="a" and "CCC_DIM"."CCC"="XYZ&quot.

Please let me know if there is a limit on the length of the string or the number of values that can be filtered. Is there a work around to filter certain dimension values from dimension table while building a cube.

Thanks in advance.

 

[pabloj]

Can't you build a view on the relational datasource?

Stick to your guns

 

[MDXer]

Building off a view is the best method to filter the data. create a view that filters out the unwanted data then point your source table in AS to this view.


"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Ashreya]

Thanks for the suggestion.