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

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.