Report Portal

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.

Read more...

 

Tags: design

 

2007-2015 VidasSoft Systems Inc.