Hi All,

I have a SERIOUS ISSUE WITH DRILLTHROUGH in Analysis Services 2005 MDX

I have a Cube with two Dimesions User,Time and my Measure is "Online Course
Count" which is in the Fact Table

I have UserName,City,Country,Phone etc in the User Dim

I have created a new "Drillthrough Action" which has the above user table
columns to be returned.

I have defined a role with the permissions, I am not sure what permissions I
need to grant for the drillthrough

When I run this query in the SQL Server Managment Studio it throws me the
following error...

Errors from the SQL query module: The 'User' table either does not exist in
the 'SessionCube' schema (or cube.), or the user does not have the necessary
permissions to access it.

DRILLTHROUGH
SELECT
{[Measures].[Rpt FACT Online Course Count]} ON 0,
{[ETL Dim User].[sUser].&[rsudhakar]} ON 1
FROM [SessionCube]
RETURN
[ETL Dim User].[sName]

Please let me know what I am missing...

This is very critical

Thanks in advance

Balaji

--
Message posted via http://www.sqlmonster.com

Hi All,

it WORKED ...

DRILLTHROUGH
SELECT
{[Measures].[Rpt FACT Online Course Count]} ON 0,
{[ETL Dim User].[sUser].&[rsudhakar]} ON 1
FROM [SessionCube]
RETURN
[$ETL Dim User].[sName]

Please anyone let me know why we need the $ to be added in the Dim table

Thanks in advance
Balaji


BALAJI K wrote:
--
Message posted via http://www.sqlmonster.com

That works great

Was struck at same point and that Helped me too

From http://www.developmentnow.com/g/112_...lease-Help.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/