Integrating Analysis Services 2005 and Reporting Services 2005 with DRILLTHROUGH
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.