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 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.