[OBIEE 11g] Implict Fact Column In OBIEE11g

 

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.