For certain metrics to function properly, you must configure the following two internal metrics in the Oracle BI Applications metadata repository (that is, the RPD file).
These metrics affect the calculation of other metrics, such as Days Sales Outstanding, Days Payables Outstanding, AP Turnover, AR Turnover, and so on.
- In Oracle BI EE Administration Tool, edit the BI metadata repository (for example,
OracleBIAnalyticsApps.rpd).
The RPD file is located at ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository.
- On Business Model and Mapping layer, find logical table 'Fact - Fins - Period Days Count'.
- Under Sources, select Fact_W_DAY_D_PSFT logical table source.
- Clear the Disabled option in the General tab and click OK.
- Open the other two logical table sources, Fact_W_DAY_D_ORA and Fact_W_DAY_D_JDE, and select the Disabled option.
- Add 'Fact - Fins - Period Days Count' and 'Dim – Legal Entity' logical tables to the Business Model Diagram.
To do so, right-click the objects and select Business Model Diagram, Selected Tables Only.
- In the Business Model Diagram, create a new logical join from 'Dim – Legal Entity' to 'Fact - Fins - Period Days Count.'
The direction of the foreign key should be from 'Dim – Legal Entity' logical table to 'Fact - Fins - Period Days Count' table. For example, on a (0,1):N cardinality join, 'Dim – Legal Entity' will be on the (0/1) side and 'Fact - Fins - Period Days Count' will be on the N side.
- Under 'Fact - Fins - Period Days Count' logical table, open '# of Elapsed Days'.
Go to the Levels tab. For Legal Entity dimension, the Logical Level is set to All. Click the X button to remove this setting.
- Under 'Fact - Fins - Period Days Count' logical table, open '# of Cumulative Elapsed Days'.
Go to the Levels tab. For Legal Entity dimension, the Logical Level is set to All. Click the X button to remove this setting.
- Check Global Consistency to ensure there are no errors, and then save the BI metadata repository (that is, the RPD file).