1. Implementation Guide
  2. Extensibility
  3. Input Data Extensibility
  4. Additional Sources for Measures
  5. Custom Fact Measures

Custom Fact Measures

The following files have been extended with 20 generic numerical fields on the end of the files:

  • SALES.csv

  • MARKDOWN.csv

  • INVENTORY.csv

  • ORDER_DETAIL.csv

  • DEAL_INCOME.csv

  • RECEIPT.csv

These flex fields will be loaded exactly as-is with no conversions or transformations, except to aggregate them from the input data to the base intersection of item/location/fiscal week. All flex fields use SUM as the aggregation method. If a flex field in the output PDS table has a prefix, like PO_FLEX1_NUM_VALUE, it means it is additionally splitting the data by that type, such as PO vs. Transfer receipt measures. If there is no prefix, then the flex measure is summed only to item/location/week level. These fields provide a way to send additional custom measures to Planning applications when the source of the measures is the same as your basic foundation data. Refer to the RAP Data Interfaces Guide in My Oracle Support (Doc ID 2539848.1) for the complete file specifications.