Search This Blog

Saturday, 24 November 2012

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.

No comments:

Post a Comment