Quick Mode to Export Data

The Quick Mode method provides significant performance improvement over the standard workflow method. It supports simple transformations using import expressions and does not support member mappings. Data is not loaded to a staging table so you cannot view the data in Workbench. For example, the Level 0 extract method allows you to apply filters and select columns to include in the output file. This method is ideal for extracting large data slices from the system without reaching query processing limits.

Note:

For information on a Quick Mode load using the EPM Integration Agent, see Performing a Quick Mode Load using the EPM Integration Agent.

Considerations:

Consider the following points associated with a Quick Model method:

1. When you create and save a Quick Mode load integration job, you cannot later change it to a standard integration job. However, you can delete the data load integration job.

2. When mapping dimensions, target expression types are supported. Target expressions enable you to transform the source value read from the source to target dimension values to be loaded to the target application.

   Target expressions that can be used for the Period dimension include substring(), split(), map() toPeriod() and toYear().

   With the exception of the SQL target expression type, all remaining target expressions are supported.

3. When mapping dimensions, source expression types are not supported.

4. Mapping members is not supported.

5. If you select the Level 0 data extract method, the system automatically creates the business rule "DM BR Data Export" to perform the data extract from the Oracle Enterprise Performance Management Cloud.

6. When running multiple column loads using Quick Mode, two header rows are not supported, that is, the column format 2,1 is not supported.

7. Period processing in Quick Model does not use periods defined in the Period Mapping option. Instead periods are handled like other dimensions and can be filtered in the Source Filters option. You can also specify a single period during execution in which case all the data is loaded to the single period. The other option is to derive the period dimension based on the source system period name using toPeriod and toYear target expressions.

8. When running the Quick Mode load, valid export modes are:

   • For Planning—Replace, Merge, and Accumulate
   • For Financial Consolidation and Close—Replace, Merge, Accumulate

   Replace is the default mode.

   No import modes are available.

9. Multi-year loads using the Replace export mode is not supported at this time.

10. A direct drill though to source is required when data is loaded using Quick Mode method. For more information, see Using Direct Drill.