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