O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  4

Image

Intermediate OLAP Modeling with SSAS

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required