O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

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

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