Many to Many Multidimensional Database (SSAS)

Practice Labs Module
Time
21 minutes
Difficulty
Intermediate

The "Many to Many Multidimensional Database in SSAS" module provides you with the instructions and devices to develop hands on skills in the following topic: Create many to many multidimensional database in SSAS.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or
Facebook
Google
LinkedIn

Already have an account? Sign In »

Overview

Introduction

The Many to Many Multidimensional Database in SSAS module provides you with the instructions and devices to develop hands on skills in the following topic:

  • Create many to many multidimensional database in SSAS

Exercise 1 - Create Many to Many Multidimensional Database in SSAS

In analysis services, many-to-many-relationship between a dimension and a measure group is defined by specifying an intermediate fact table.

In this exercise, you will create a many-to-many relationship between FactInternetSales measure group and DimSalesReason dimension in a cube that is created based on AdventureWorksDW2012 database.

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