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.

Comprehensive Learning

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