Chapter 6. Working with a Finance Measure Group
After completing this chapter, you will be able to:
Build an account dimension to support financial analysis.
Use custom rollup operators.
Aggregate an account dimension.
Create nonadditive measures.
In the previous two chapters, you learned how to build dimensions and measure groups from standard warehouse tables. You can use the techniques you learned to meet most analytical requirements, but financial analysis has special requirements. In this chapter, you’ll learn about the special tools that Analysis Services provides to handle these special requirements by building an account dimension and a financial measure group. You’ll also get more experience working with calculations by building a financial ...
Get Microsoft® SQL Server™ 2005 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.
