Cube advanced properties, "Source table filter" -
10-25-2005
, 02:02 AM
Hello,
I am using into a cube, when I modify thisone, the option "source table
filter" that is in advanced properties of the cube. So I use the follow sintax
"dbo"."facttablename"."columnname" = 'xxx'
I use thisone because in this cube I am going to use a huge fact table but I
only want to show only an element of my entity dimension. I have use the same
sintax in my new entity dimension and it works well.
When I process the cube and it tells me that an element of the fact table
isn´t in my new entity dimension. So I look the trace of the sql query and
it´s not into where the filter that I have used.
Has anyone had the same problem as me¿?
Thanks |