Implementing User-Defined Hierarchies in SQL Server Analysis Services
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.