Implict Fact Column In OBIEE11g

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