SSAS Articles 
Drillthrough Drillthrough to Relational in SSAS 2005
Drillthrough Drillthrough to Relational in SSAS 2005
| Drillthrough to Relational in SSAS 2005 |
| Written by C. S. John Lam |
| Tuesday, 16 October 2007 05:36 |
|
I was asked twice recently about the new drillthrough architecture in MOLAP in SSAS 2005. For some business reasons, they wanted to implement the old drillthrough style. Unlike 2000, if MOLAP partition is used, the drillthrough in 2005is no longer getting the data directly the relational model. Instead, the new style, the drilllthrough detail information must include in the cube. There is no more SQL statements sending over to the datasource to retrieve the detail data. if ROLAP, the drillthrough will query the datasource directly. |
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
