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 the 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:
-
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.
-
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.
-
When mapping dimensions, source expression types are not supported.
-
Mapping members is not supported.
- 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 Fusion Cloud Enterprise Performance Management.
-
When you use the Level 0 data extract method, you cannot use a shared member in the source filter.
-
When running multiple column loads using Quick Mode, two header rows are not supported, that is, the column format
2,1
is not supported. -
Period processing in Quick Mode 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
andtoYear
target expressions. -
Dynamic Time Series (DTS) members (for example, Y-T-D, H-T-D, Q-T-D, etc.,) that are surfaced for forms and reports are not supported for source filters when using Quick Mode, or anywhere that the member selector for the period dimension is supported.
-
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.
If using Quick Mode in Merge mode, and there are any errors during the load, the load fails and nothing is loaded. If using Replace mode, valid data will is loaded, and invalid data is not loaded. Replace mode results in a partial load of valid data.
No import modes are available.
-
Multi-year loads using the Replace export mode is not supported at this time.
Note:
The Change Sign option is not supported for Quick Mode loads.
-
A direct drill though to source is required when data is loaded using the Quick Mode method. For more information, see Using Direct Drill.
-
To export text, smart list and dates from your application using Quick Mode, you need to create a target application using the category: "Data Export," the type: "EPM Data File" and the data extract option "Level 0 Data." Use this application as the target when creating your integration.