CODEWITHSUNDEEP
ssasmdxdrillthrough
Ajwhiteway
Ajwhiteway

Reputation: 1006

MDX Drillthrough subcube not working

I have a query as such 

DRILLTHROUGH
SELECT NON EMPTY { [Measures].[#] } ON COLUMNS,
NON EMPTY
{
  ( [Location].[Name].[Name].&[Test Location] )
}  ON ROWS
FROM (
  SELECT (
  { [v Item].[Item].&[Option 1], [v Item].[Item].&[Option 2], [v Item].[Item].&[Option 3] } ) ON 0
  FROM [TestCube]
)

Without the Drillthrough the query returns the correct results/cell; however, with the drillthrough the subcube 

 SELECT (
      { [v Item].[Item].&[Option 1], [v Item].[Item].&[Option 2], [v Item].[Item].&[Option 3] } ) ON 0
      FROM [TestCube]

is completely ignored. What am I doing wrong here?

Upvotes: 0

Views: 197

Answers (1)

Ajwhiteway
Ajwhiteway

Reputation: 1006

The problem was the ON ROWS.

Way to do this

DRILLTHROUGH
SELECT NON EMPTY { [Measures].[#] } ON COLUMNS
FROM (
  SELECT (
  { [v Item].[Item].&[Option 1], [v Item].[Item].&[Option 2], [v Item].[Item].&[Option 3] } ) ON 0,
  {[Location].[Name].[Name].&[Test Location]} ON 1
  FROM [TestCube]
)

Upvotes: 1

Related Questions