Chapter 5. Designing Measure Groups and Measures
After completing this chapter, you will be able to:
Build a cube based upon an underlying data source using the New Cube Wizard.
Create, modify, and browse measures and measure groups.
Define the relationship between dimensions and measure groups.
Work with aggregations of semiadditive measures.
Add distinct count measures.
Create calculations to provide additional functionality.
In Chapter 4, you focused on the use of the Dimension Wizard to create different types of dimensions, and the Dimension Designer to enhance those dimensions by changing certain properties, and to review the results of those enhancements. In this chapter, you’ll shift your focus to the Cube Wizard to build a cube from measure groups, ...
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.