Drillthrough Integrating Analysis Services 2005 and Reporting Services 2005 with DRILLTHROUGH
| Integrating Analysis Services 2005 and Reporting Services 2005 with DRILLTHROUGH |
| Written by Dave Rodabaugh |
| Saturday, 28 July 2007 19:24 |
|
In these articles Dave Rodabough describes how to integarte Analysis Services 2005 and Reporting Services. My current client has engaged my employer to implement a financial reporting solution. The first report we chose was a cash report, which displays details not usually carried in a cube. In the past, I never worried about uniqueness of fact rows because it was unnecessary. Having completely identical rows in a fact table was perfectly legitimate, a fact giving indigestion to many traditional data modelers. When Analysis Services 2000 (“MSAS”) loads duplicate rows into the cube, it simply aggregates the measures into the single designated cell identified by the dimensional tuple formed by the surrogate key combination. This is one of the things we love about Analysis Services, that it provides (semi) detailed and aggregated information on a moment’s notice. Read more: Part II of IV: Design Implications of the New Drillthrough Part III of IV: Ways to write effective drillthrough queries |
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
