Report Portal

SSAS : Select Facts with Reference and Many2Many relationships

In this blogpost i'll explain how to connect two starschemas with each other and how to setup the cube in SSAS in case you want to use the dimensions of the two facts selecting the measures in both facts. In other words, suppose i've two facts that have a 1:N relation (eg. Orders and OrderLines) and there are a couple of dimensions (eg. Customer, Department, Date, Product and Category). And, sometimes because of naming conventions (?) a referenced dimension relationship is automatically created between a 1 fact and a N fact. This will enable selecting the measures of the N fact with the dimensions of the 1 fact. Using a Many-2-Many (M2M) relationship will enhance selecting measures in the 1 fact with the dimensions of the N fact.

Read more...

Tags: design, many-to-many

 

2007-2015 VidasSoft Systems Inc.