Inconsistencies when using Drillthrough MDX with Perspectives

Describes issues when using Drillthrough MDX with Perspectives and workarounds to fix this problem.

DRILLTHROUGH MDX is a very powerful way to drillthrough to your original data source of detail data that make up the aggregations that you are looking at. For more information on enabling drillthrough, please refer to T.K. Anand’s great article on Enabling Drillthrough in Analysis Services 2005 (http://technet.microsoft.com/en-us/library/ms345125(SQL.90).aspx). Using a real example, if you were to query the Adventure Works OLAP database for the [Internet Sales Amount] measure:

SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS
FROM [Adventure Works] 

 Read more...