Hi All,

I have a question on DRILLTHROUGH in Analysis Services 2005

drillthrough

select

[Measures].[Fact Internet Sales Count] on 0,

[Product].[Product].&[486] on 1

from

[Sales Cube]

Return

[Product].[Color]

I have created a DRILLTHROUGH Action where the Drillthrough Return Columns is
Color of a Product Dimension.

The Drillthrough is working fine in the Cube Browser but when I run this MDX
Query in the Management Studio.
I am getting this error.

Executing the query ...
Errors from the SQL query module: The 'Prouct' table either does not exist in
the 'Sales Cube' schema (or cube.), or the user does not have the necessary
permissions to access it.
Execution complete


Need immediate help on this.

Thanks in Advance

Balaji

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200602/1