source table filter

[yaniv]

hi to all ,

i am trying to write source table filter sytax
for a dimension so i can see only part of the table data as
the dimension,

like that:
col=value
"CODE_MAARECHET"='HK'
and i get this message :
the column expration must be qualified with the table name
near "CODE_MAARECHET"

when i add table
like that:
table.col=value
"dwwts_gil_to_0273"."CODE_MAARECHET"='HK'
i get this message :
table "dwwts_gil_to_0273" is not found in the from clause .

* i'm working with ORACLE DB.

HOPE SOME1 SEE ME.

[ashishtiwarivds]

Hi Yaniv,
I know this is a very late reply, but it may be helpful for forum members.
I was facing the same problem, though I am using SQL Server 2000, but I added dbo before table name and it started working.
You can also try
dbo.<tablename>.<column name>=value

Hope this will help.