Mapping Fact and Dimension on the Cube

Mapping Fact Dimension Cube
Fact table needs to mapped with the Dimension table
Fact table column will have the Foreign key and the Dimension Table will have the Primary key

Double Click on the cube – > Dimension Usage (Appears on the Top menu)
You will get a Matrix format of Dimension and Fact.
Click on the cells for mapping
1. Select the Granularity Attribute
2. Map the key columns and establish the relationship between fact and dimension table on the cube

Mapping Fact and Dimension on the Cube was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

Leave a Reply