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").



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.


--
Posted via http://dbforums.com

I recommend implementing this logic in view(s), then use the view(s) to
source dims/cubes.

tom @ the domain below
www.tomchester.net


"Ashreya" <member45130 (AT) dbforums (DOT) com> wrote

Thanks tom. I will try using views.


--
Posted via http://dbforums.com