SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

In a recent article on SQL Server Analysis Services 2008 (http://www.simple-talk.com/sql/ssis/five-basic-steps-for-implementing-an-analysis-services-database/), I explained how to implement a multidimensional database. The Analysis Services database I used as an example included a data source, data source view, multiple database dimensions, and a cube based on those dimensions. I then showed you how to deploy the database and browse the cube data in SQL Server Business Intelligence Development Studio (BIDS). However, the cube was missing important functionality—the ability to drill down into the data in order to view aggregated values at more granular levels. That’s because no hierarchies had been created in the database dimensions.

Read more...