O'Reilly logo

Foundations of SQL Server 2005 Business Intelligence by 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

Chapter 5. Intermediate OLAP Modeling

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 AdventureWorksDW 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 KPIs (Key Performance Indicators)

  • Reviewing Perspectives

  • Understanding Translations for Currency Localization

  • Covering Actions: Regular, Drillthrough, and Reporting Actions

Adding Key Performance Indicators (KPIs)

A key performance indicator (KPI) is an object that helps cube users to quickly check the status of the ...

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