Implement a Cube
Practice Labs Module
Time
30 minutes
Difficulty
Intermediate
The "Implement 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 tasks: Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube.

Overview
Introduction
The Implement 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 tasks:
- Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube
Exercise 1 - Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube
In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:
- Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube; use SSDT-BI to do non-additive or semi-additive measures in a cube
- Define measures
- Specify perspectives
- Define translations
- Define dimension usage
- Define cube-specific dimension properties
- Define measure groups
- Implement reference dimensions
- Implement many-to-many relationships
- Implement fact relationships
- Implement role-playing relationships
- Create and manage linked measure groups and linked dimensions
- Create actions
Learning Partner
Comprehensive Learning
See the full benefits of our immersive learning experience with interactive courses and guided career paths.