Technical Training
Analysis Services TrainingTable of Contents
MSAS: Working with Levels and Hierarchies
MSAS: Working with Levels and Hierarchies - Page 2
MSAS: Working with Levels and Hierarchies - Page 3MSAS: Working with Levels and Hierarchies Page - 3
MSAS: Working with Levels and Hierarchies
Creating Member groups in Dimension Levels
Member groups in a dimension level are system generated parents of collections of consecutive dimension members. End users will not be able to see any difference between ordinary members and member groups. However, member groups provide an intermediate level for drilldown between a level with few members and one with multiple members. They also help restrict the number of members in a group to 64,000 under a parent member.
Member groups can be created automatically in a regular dimension while it is being created. This option is operable only for the member groups immediately above the lowest level of the dimension. To select this option the user needs to specify this in the Specify Storage mode and create member groups step of the dimension wizard by selecting Create member groups automatically.


Member groups are dependent on the Order By property of the level that contains the children. The sort order of the displayed members is specified by this property and it places the children in consecutive order within the level.
- Select the dimension that will contain the member groups:
- If the dimension is shared, in the Analysis Manager tree pane, right-click the dimension, and then click Edit.
- If the dimension is private, in the Analysis Manager tree pane, right-click the cube that contains the dimension, and then click Edit. In the Cube Editor tree pane, expand the dimension to reveal its levels.
- Create a copy of the level that contains the members that will be the children of the member groups. Create it immediately above the original. To do this, follow these steps:
- In the editor tree pane, select the level to be copied.
- If the properties pane is not expanded, expand it by clicking Properties beneath the tree pane.
- In the properties pane, click the Basic tab.
- Record the value of the Member Key Column property.

- On the Insert menu, click Level.

- In the Select Column dialog box, select the column recorded in Step d, and then click OK.

- Select the new level. Ads
- Drag the new level to a position immediately above the original level.

- In the properties pane, ensure that all of the new level's properties except Name have the same values as the original level.
- In the editor tree pane, select the level in which you want to create member groups. (Select the new level from Step 2, not the original level.)
- In the properties pane, click the Advanced tab.
- For the Grouping property, select Automatic.

- If you want to hide from end users the level that contains the member groups, follow these steps: In the editor tree pane, select the level that contains the member groups.
- In the properties pane, click the Advanced tab.
- Change the value of the Visible property to False.

- In the editor, on the File menu, click Save.
Once the group is created the dimension has to be processed.
Levels derived from two columns
The column that supplies the member names of a level is selected by defining the Member name column property of the level and the members are identified by the Member Keys property. While defining the dimension, the column selected for defining the level is recorded both in the Member Name Column property and the member Key Column property. These can be changed later so that they reference different columns using the Dimension Editor or the Cube editor. When the member names of a level are derived from a column different from the keys of the members, the level itself is said to be derived from two columns.
Analysis Services Training
- MSAS - Browsing the Dependency Network
- MSAS - Building a Relational Decision Tree Model
- MSAS - Introduction to Data Mining
- MSAS - Applying security to a Dimension
- Tutorial 65: MSAS - Managing Cube Roles
- MSAS - Understanding Database Roles
- MSAS - Securing User Authentication
- MSAS - Introducing Analysis Services Security
- MSAS - Writebacks
- MSAS - Defining and Creating Drillthrough
- MSAS - Defining and Creating Auctions
- MSAS - Creating and Maintaining Calculated Members in Virtual Cubes
- MSAS - Building a Virtual Cube
- MSAS - Understanding Virtual Cubes
- MSAS - Introducing Solve Order
- MSAS - Implementing Calculations Using MDX Part 2
- MSAS - Implementing Calculations Using MDX Part 1
- MSAS - Merging Partitions
- MSAS - Introduction and Managing Partitions
- MSAS - Troubleshooting Cube Processing
- MSAS - Optimizing Cube Processing
- MSAS - Processing Dimensions and Cubes
- MSAS - Introducing Dimension and Cube Processing
- MSAS: Optimization Tuning Part 2
- MSAS: Optimization Tuning Part 1
- MSAS: Usage-Based Optimization
- MSAS: Analysis Services Aggregations
- MSAS: The Storage Design Wizard
- MSAS: Analysis Server Cube Storage
- MSAS: Defining Cube Properties
- MSAS: Introduction and Working with Measures
- MSAS: Introduction and Working with Cubes
- MSAS: Virtual Dimensions
- MSAS: Introducing Member Properties
- MSAS: Creating Custom Rollups
- MSAS: Creating a Time Dimension
- MSAS: Understanding Hierarchies
- MSAS: Dimension Storage Modes and Levels
- MSAS: Working with Levels and Hierarchies
- MSAS: Working with Parent-Child Dimensions
- MSAS : Basics of Levels
- MSAS : Working with Standard Dimensions
- MSAS : Shared vs Private Dimensions
- Understanding Dimension Basics
- MSAS : Office 2000 OLAP Components
- MSAS : Client Architecture
- MSAS : Cube Storage options
- MSAS : Meta data Repository
- MSAS : Analysis services Tools for Extended Functionality
- MSAS : The Wizards
- MSAS : The Analysis Manager and Analysis Server
- MSAS : The Data warehousing framework of SQL Server 2000 - Part 2
- MSAS : The Data warehousing framework of SQL Server 2000 - Part 1
- MSAS : Microsoft Data Warehousing Overview
- MSAS : Browsing the Cube
- MSAS : Designing Storage and Processing the Cube
- MSAS : Building the Cube Part #3
- MSAS : Building the Cube Part #2
- MSAS : Building the Cube Part #1
- MSAS : Setting up the Database in Analysis Server
- MSAS : Preparing to Create the Cube
- MSAS : Introducing Analysis Manager Wizards
- Microsoft Analysis Services Installation
- MSAS - Applying OLAP Cubes
- Understanding OLAP Models
- Designing the Dimensional Model and Preparing the data for OLAP
- Design of the data warehouse: Kimball Vs Inmon
- Defining OLAP Solutions and Data Warehouse design
- Microsoft Analysis Services Training
- Data Warehouse database and OLTP database
- Introduction to Data Warehousing







