Urgent:hard to find problem behind drill through

#1

Hi,
I have been using following filter in drillthrough

"dbo"."FACT_IN_STORE_VISIT_V"."ACTIVITY_TYPE_ID"=" dbo"."ACTIVITY_TYPE_V"."ACTIVITY_TYPE_ID"

gives me error as
"Data source provider error. the column prefix 'dbo.ACTIVITY_TYPE_V'
does not match with a table name or alias name used in the query
..;42000"

i have installed service pack 3 for Analysis services

but still gives me this problem

any help is highly appreciated

Regards

#2

Are you sure you have activated this column in drillthrough options in the
cube ?

--Michael V.

"Prasanna" <tawargerip (AT) hotmail (DOT) com> skrev i en meddelelse
news:d4b0bad7.0408300230.ab6ef56 (AT) posting (DOT) google.com...

Quote:

Hi,
I have been using following filter in drillthrough

"dbo"."FACT_IN_STORE_VISIT_V"."ACTIVITY_TYPE_ID"=" dbo"."ACTIVITY_TYPE_V"."AC

TIVITY_TYPE_ID"

Quote:

gives me error as
"Data source provider error. the column prefix 'dbo.ACTIVITY_TYPE_V'
does not match with a table name or alias name used in the query
.;42000"

i have installed service pack 3 for Analysis services

but still gives me this problem

any help is highly appreciated

Regards

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Urgent:hard to find problem behind drill through

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Urgent:hard to find problem behind drill through - 08-30-2004 , 05:30 AM

Re: Urgent:hard to find problem behind drill through - 08-30-2004 , 01:03 PM