| Author |
problem to use 'Source Table Filter'?
|
|
| urgent 2005-09-29, 1:23 pm |
| 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.
| |
| SQL McOLAP 2005-09-29, 1:23 pm |
| Just a quick guess...is it because you mis-spelled "Tbl_Dim_State" as
"Tbl_Dim_Stae?"
"urgent" wrote:
> 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.
| |
| urgent 2005-09-29, 1:23 pm |
| 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:
[color=darkred]
> Just a quick guess...is it because you mis-spelled "Tbl_Dim_State" as
> "Tbl_Dim_Stae?"
>
>
>
> "urgent" wrote:
>
| |
| Darren Gosbell 2005-09-29, 8:24 pm |
| 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_do
t_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:
> 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.
| |
| urgent 2005-09-30, 1:23 pm |
| but how to get on SQL Profiler?
"Darren Gosbell" 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_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
| |
| urgent 2005-09-30, 1:23 pm |
| adding dbo already, but doesn't work. also "MA" is mis-spelling should be 'MA'.
Still no lucky... any more?
"Paul" wrote:
[color=darkred]
> 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:
>
|
|
|
|