Intermediate OLAP Modeling with SSAS

  • Guy Fouché
  • Lynn Langit


After you’ve mastered basic OLAP modeling and the use of SSAS, the next area to investigate is using some of the intermediate and advanced capabilities of SSAS. This chapter’s examples continue to build on the AdventureWorks 2008 R2 sample. The assumption is that you’ve built a basic cube using the sample database and now want to further enhance your cube. This chapter will cover the following topics:
  • Adding key performance indicators (KPIs)

  • Reviewing perspectives

  • Understanding translations for currency localization

  • Covering Actions: regular, drillthrough, and reporting actions


Profit Margin Business Intelligence Client Application Measure Group Cube Modeling 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Guy Fouché and Lynn Langit 2011

Authors and Affiliations

  • Guy Fouché
  • Lynn Langit

There are no affiliations available

Personalised recommendations