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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or
Sign up with Google
Sign up with Apple
Sign up with Microsoft
View all SSO options

Already have an account? Sign In »

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
Practice Labs

IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.

Courses