Lesson 4: Defining Advanced Attribute and Dimension Properties
In this lesson, you will learn how to use some advanced properties of attributes, attribute hierarchies, and dimension properties.
Note
This lesson is based on an enhanced version of the Analysis Services Tutorial project that you completed in the first three lessons of this tutorial. The first task in this lesson describes where to locate the appropriate sample project to use for the lesson, and the difference between this project and the project that you created in the first three lessons.
This lesson contains the following tasks:
- Using a Modified Version of the Analysis Services Tutorial Project
In this task, you open, review, and deploy a modified version of the Analysis Services Tutorial project which has multiple measure groups and additional dimensions.
- Defining Parent Attribute Properties in a Parent-Child Hierarchy
In this task, you define level names in a parent-child dimension and specify whether data related to parent members will be displayed. For more information, see Defining a Parent-Child Hierarchy, and Working with Attributes in Parent-Child Hierarchies.
- Automatically Grouping Attribute Members
In this task, you automatically create groupings of attribute members based on the distribution of the members within the attribute hierarchy. For more information, see Grouping Attribute Members (Discretization).
- Hiding and Disabling Attribute Hierarchies
In this task, you learn how and when to disable or hide attribute hierarchies.
- Sorting Attribute Members Based on a Secondary Attribute
In this task, you learn how to sort dimension members based on a secondary attribute, to achieve the sort order that you want.
- Specifying Attribute Relationships Between Attributes in a User-Defined Hierarchy
In this task, you learn how to define member properties for attributes, to specify aggregation relationships between them. For more information, see Defining and Configuring an Attribute Relationship, and Configuring User-Defined Hierarchy Properties.
- Defining the Unknown Member and Null Processing Properties
In this task, you configure the UnknownMember and UnknownMemberName properties to handle error conditions caused by null dimension members.
Next Lesson
Lesson 5: Defining Relationships Between Dimensions and Measure Groups
See Also
Concepts
Analysis Services Tutorial Scenario
SQL Server 2005 Analysis Services Tutorial
Other Resources
Defining and Configuring Dimensions, Attributes, and Hierarchies