Define EPM Data Extracts in the Oracle Fusion Data Intelligence EPM Integrator

When you configure data extract for the first time, start with a small dataset from the EPM application. Apply filters on each dimension and restrict each to a single member. This enables faster iterations for testing and helps quickly confirm prerequisites and overall setup before scaling up to larger extracts. 

1. Sign in to your service.
2. In Oracle Fusion Data Intelligence Console, click Data Configuration under Application Administration.
3. On the Data Configuration page, change the Data Source to Oracle EPM FCCS Integrator for FCCS or Oracle EPM Planning Integrator for PBCS. 
4. Click Custom Data Configuration.
5. At the top right of the page, click Create and then EPM Application to create an EPM application.
6. Click Create Extract to create an extract.
7. Provide the following information:
   • Name: Name of the Extract. This name is used for the database object.
   • Label: Label for the Extract. (This field allows special characters.)
   • EPM Application: Select the application from the list.
   • Cube: Select the necessary cube from the list.
   • Target Application: Select the Target Application. Note: Ensure that you select the correct Target Application against the cube.
   • Job Type: Facts and Dimensions.
   • Number of Periods: Select the required value.
     • No Incremental: Use this option when you need to truncate and reload (Full reload) data from EPM.
     • Value: The number of prior periods to load in addition to the current period. The system uses this value to delete the data for particular months in Oracle Fusion Data Intelligence  and re-extract the data for those months from the EPM.
       • For example, if you choose 0, then the current month's data is deleted and re-extracted.
       • For example, if you choose 2, the current and two prior months' data are deleted and re-extracted in every incremental run.
   • Data extract options:
     • All Data: Extracts stored values and dynamically calculated values for both the Dense and Sparse dimensions. This option uses the MDX Query Export method.  
     • Stored and Dynamic Calculated Data: Extracts for stored members and dynamic calculated members for the Dense dimension only, and not the Sparse dimensions. This option uses the DATAEXPORT command method.
     • Stored Data Only: Extracts stored data only. Dynamically calculated values are excluded in this type of extract. This option uses the DATAEXPORT command method.
     • Level 0 Data: Extracts entire members at the bottom of the dimension (raw data stored in a database) and enables you to apply filters and select columns to include in the output file. This extract option also allows you to export non-numeric data if the target application is an EPM data file. The Level 0 Data option uses the MAXL Export method to extract data. This method can be used only by the Service Administrator. The application is read-only when the extract step is executing.

       Note:

       The All Data option can cause EPM performance issues.
   • Supported data extract options for the EPM Integrator: 
     • ASO Cube: All Data, Level 0 Data 
     • BSO Cube: Stored Data only, Stored and dynamically calculated Data, Level 0 Data 
     • Hybrid Cube :All Data, Stored and Dynamic Calculated Data, Stored Data Only, Level 0 Data 
8. Complete the filter definition for all the dimensions in the extract configurations.
   • You can select a filter for each row (dimension). Choosing filters for all dimensions is recommended.
   • You can search for any Member and use EPM member functions. For more information on EPM member functions, see Member Relationships.
   • You can also search for a member and add it to the filter.
9. Apply filters for all dimensions.
   • You can create multiple smaller jobs to extract data using split dimensions. By default, Year is always selected as a split dimension.
   • You can select one more additional dimension as a split dimension.
   • To improve performance, use multiple jobs to extract large sets of data.
   • Review your EPM design and carefully choose the split dimension value based on your EPM cube design.
10. Click Save.
    You can create multiple extract definitions and include or exclude specific items. Excluded extract configurations are saved and won't be executed. You can exclude and include any extract configurations:

    • You can create multiple extract configurations and keep them as draft items to help you manage your SDLC process for the extract configurations.
    • You can move any failed extract configurations to the excluded state so that you can deploy the application.
11. Click Save and Exit to save the configuration.
    If you click Cancel, unsaved extract definitions and changes are lost.
12. In the data Configuration page, click Publish.

After the application is published, data extracted from EPM is available in the Oracle Fusion Data Intelligence database. Each extract configuration is an individual table.

• You can connect OAX_USER and query all the tables created by the Oracle Fusion Data Intelligence EPM Integrators.
• The naming convention for Oracle EPM PBCS Integrator is DW_EPI_X_EPM_PBCS_INT_<Extract Name>.
• The naming convention for the Oracle FCCS Integrator is DW_EFI_X_EPM_FCCS_INT_<Extract Name>.