Drillthrough

Hi!
I am a confused newbie, grateful for some help. I need to select 10 rows from total profit of married people. How would I do that?

DRILLTHROUGH MAXROWS 10 SELECT

{[Measures].[Total Profit]} on 0 from [Electronics], [customer].[Name]ON 1 ON columns

FROM WHERE [Demo].[civilstatus-salary].[civilstatus].&[married]}RETURN [Measures].[Total profit](as rows)

This MSDN paper on drillthrough discusses how to select the columns returned by drillthrough:

http://msdn2.microsoft.com/en-us/library/ms345125.aspx

>>

Microsoft SQL Server 9.0 Technical Articles

Enabling Drillthrough in Analysis Services 2005

T.K. Anand
Microsoft Corporation

July 2005

Applies to:
SQL Server 2005 Analysis Services

Summary: Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.

...

RETURN Clause

The RETURN clause specifies the list of columns to be returned in the drillthrough result. The columns can be either measures or dimension attributes, optionally aliased using the AS clause.

...

But the real advantage of drillthrough actions is that it provides the cube designer with the ability to pre-define the return columns of the DRILLTHROUGH statement (Figure 2). This is analogous to the Analysis Services 2000 experience where the database administrator specifies the tables and columns in the Drillthrough Options dialog in Analysis Manager.

>>

|||Thank you! Why does it return this? When I delete the Return statement it does return results of measure.
Getting the errors "The 'Measures' table either does not exist in the 'Elec' schema (or cube.), or the user does not have the necessary permissions to access it.

DRILLTHROUGH MAXROWS 10 SELECT
{[Measures].[Total Profit]} on COLUMNS, {[Customer].[Name]} ON ROWS FROM [ELEC] WHERE [Demo].[civilstatus-salary].[civilstatus].&[married]
RETURN [Measures].[Total Profit]AS Profit, [Kund].[Name] AS Name|||

DRILLTHROUGH MAXROWS 10 SELECT

{[Measures].[Total profit]} on COLUMNS, {[Customer].[Name]} ON ROWS FROM [Elec] WHERE {[Demo].[civilstatus-salary].[civilstatus].&[married]}RETURN [$Customer].[Name], [$Measures].[Total Profit]