Design Dimensions and Measures of a Cube
The "Design Dimensions and Measures of a Cube" module provides you with the instruction and Server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: Create an Analysis service project, Add data source to the project, Add data source view to the project, Add dimensions to the project...

Introduction
The Design Dimensions and Measures of a Cube module provides you with the instruction and Server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:
- Create an Analysis service project
- Add data source to the project
- Add data source view to the project
- Add dimensions to the project
- Define cube and measures
- Add attributes to dimensions
- Build Hierarchies
- Define attribute relationships
- Implement hierarchies
- Dimension type
- Develop new custom attributes
Exercise 1 - Design Dimensions and Measures
In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:
- Identify the dimension/measure group relationship that should be selected
- Design patterns for representing business facts and dimensions (many-to-many relationships)
- Design dimensions to support multiple related measure groups (many related fact tables)
- Identify the measures
- Manage dimensions in a cube
- Identify the attributes of dimensions
- Build hierarchies
Exercise 2 - Implement and Configure Dimensions in a Cube
In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:
- Translations
- Define attribute relationships
- Implement hierarchies
- Implement SQL Server Analysis Services (SSAS) dimensions and cube
- Create the Attribute Relationships that should be made for a given set of attributes in a dimension
- Develop new custom attributes on dimensions
- Detect possible design flaws in attribute relationships
- Implement time dimensions in cubes
- Manage SSAS parent-child dimensions
- Dimension type
See the full benefits of our immersive learning experience with interactive courses and guided career paths.