my dimesion works fine when browing data and the cube also works fine.

but when using 'Source Table Filter':

"Tbl_Dim_Stae"."state"<>"MA"

but doesn't work. got error:
unable to browse the dimesion 'Dim_dm_state'.
Table 'Tbl_Dim_Stae' is not found in the from cause.

the table is there. any clues? thanks.

Just a quick guess...is it because you mis-spelled "Tbl_Dim_State" as
"Tbl_Dim_Stae?"



"urgent" wrote:

no. i just mis-spelled it here. but i tried to copy my table name from my
database... so any more clues? thanks.

"SQL McOLAP" wrote:

Try running a SQL Profile session when you try to browse the data. It
could be that AS is already adding the table name to the where clause
and it is getting in there twice. SQL Profiler should let you see the
exact statement that is hitting the relational database.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Hi,

I've had a smilar problem. Try prefixing the table name with dbo. like...
dbo.Tbl_Dim_State.state<>"MA"
and also drop the quotes around everything apart from the "MA" bit.
Ta
Paul


"urgent" wrote:

but how to get on SQL Profiler?

"Darren Gosbell" wrote:

adding dbo already, but doesn't work. also "MA" is mis-spelling should be 'MA'.

Still no lucky... any more?

"Paul" wrote: