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.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.