Setting or Creating an Implicit Fact Column in OBIEE

Setting or Creating an Implicit Fact Column in OBIEE

To set an implicit fact column follow the steps and screenshot

• 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.