Configuring Number of Days Based Metrics for JD Edwards EnterpriseOne

For certain metrics to function properly, you must configure two internal metrics in the Oracle BI Applications metadata repository (RPD) file.

The following internal metrics affect the calculation of other metrics, such as Days Sales Outstanding, Days Payables Outstanding, AP Turnover, and AR Turnover:
  • # of Elapsed Days

  • # of Cumulative Elapsed Days

To configure number of days based metrics:
  1. In Oracle BI Administration Tool, edit the BI metadata repository (for example, OracleBIAnalyticsApps.rpd).
    The repository file is located at ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository.
  2. On Business Model and Mapping layer, find logical table Fact - Fins - Period Days Count.
  3. Under Sources, select Fact_W_DAY_D_JDE logical table source.
  4. Clear the Disabled option in the General tab and click OK.
  5. Open the other two logical table sources, Fact_W_DAY_D_ORA and Fact_W_DAY_D_PSFT, and select the Disabled option.
  6. Check Global Consistency to ensure that there are no errors, and then save the BI metadata repository file.