Implement a Cube

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