- Create a Dummy Fact column in a Physical Layer called Implicit Fact Column and map that column to any number of your choice
 |
| Creating Implicit Fact Column |
- Join all Dimensions to this Fact column in BMM Layer
- In presentation layer, double click the presentation catalog/ go to properties of presentation catalog.
- In the general tab, find the Implicit Fact Column section.
 |
| Selecting Implicit Fact Column from Presentation Catalog |
- Click on Set button, this will open the browse window
- Select a fact column from the fact tables available in the presentation catalog.
- Click OK.
- Ensure that the selected Implicit Fact Column is displayed in the Implicit Fact Column section in the general properties of Presentation Catalog.
- Click OK.
- Save your changes in the repository.
Hi Thanks for posting this this is helpful.
ReplyDeleteBut i have question on second bullet point.
--Join all Dimensions to this Fact column in BMM Layer
What do you mean by this? How can we join on this particular column. All the joins automatically comes from physical layer right?