SSAS Articles 
Drillthrough Inconsistencies when using Drillthrough MDX with Perspectives
Drillthrough Inconsistencies when using Drillthrough MDX with Perspectives
| Inconsistencies when using Drillthrough MDX with Perspectives |
| Written by Denny Lee |
| Monday, 18 June 2007 18:01 |
|
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 |
Latest Author Articles
- Analysis Services Distinct Count Optimization
- Analysis Services: Should you use many-to-many dimensions?
- Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005
- Renaming an Analysis Services 2005 cube
- Inconsistencies when using Drillthrough MDX with Perspectives
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
