Chapter 4. Designing Dimensions
After completing this chapter, you will be able to:
Define a data source for an Analysis Services project.
Create a data source view (DSV).
Use the Dimension Wizard to build standard, time, and parent-child dimensions.
Deploy Analysis Services database objects.
Change dimension properties.
Work with special properties of parent-child dimensions.
In Chapter 3, you created dimensions from a template and then used the Schema Generation Wizard to build tables in a Structured Query Language (SQL) Server database to correspond to the dimension design. In this chapter, you’ll use the Dimension Wizard to create dimensions from existing tables and work with the Dimension Designer to review a dimension’s structure, modify its properties, ...
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.
