I am new to Analysis Services by SQL Server Version (8.00.382).
--
I am working on a simple cube. I am trying to filter my data for a
field.
FactTable : A
SnowFlake Dimention : Table B and Table C
--

I am trying to apply the filter for table C, which I am doing by
setting the property of "SourceTableFilter" by setting

SourceTableFilter : "dbo"."C"."LanguageNo"=1

--

But when I see trace log in Processing, I see no WHERE clause in SQL
Statement.This sounds totally strange to me.

Abdul Nasir Khan
a.nasir (AT) ieee (DOT) org

Check the partition. (It's under the Advanced button on the last page of
the partition wizard.) The source table filter of the cube servers as the
default for the partitions, but if the partition has been modified it will
not inherit the change.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Abdul Nasir Khan" <a.nasir (AT) ieee (DOT) org> wrote