Chapter 8. Working with Account Intelligence

In this chapter, you will learn how to:

  • Build an Account dimension to support Financial Analysis.

  • Define and manage custom rollup (unary) operators.

  • Apply Financial Business Intelligence properties.

  • Create non-additive measures.

  • Create a custom member rollup formula.

  • Work with a Scenario dimension.

In previous chapters, you learned how to build dimensions and measure groups from standard data warehouse tables. You can use the techniques you learned to meet most analytical requirements. When you need to perform financial analysis, there are several special requirements that need additional cube design and aggregation rules. In this chapter, you’ll learn about the special tools that Analysis Services provides ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.