Design Dimensions and Measures of a Cube

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