Using an Export Dimension Mapping by Name (EDMCS) Job Type
The Export Dimension Mapping by Name (EDMCS) job type enables you to export mapping rules for a specific Oracle Enterprise Data Management Cloud dimension and location to a file in the staging area or a target environment defined in a connection.
You can export a dimension mapping by name only to a comma delimited text file (CSV). For a list of application types to which you can export a dimension mapping, see Understanding Application Types.
When the mapping is exported to an Oracle Enterprise Performance Management Cloud application, it can be imported as an Explicit mapping within Data Integration because the file is exported to the Data Exchange inbox folder. You can use the Import Mapping job type in the Pipeline to perform the import. See Using an Import Mapping Job Type for more information.
Export Dimension Mapping by Name (EDMCS) job type parameters include:
Table 12-11 Export Dimension Mapping by Name (EDMCS) Job Type Parameters
Export Dimension Mapping by Name (EDMCS) Job Type Parameters | Description |
---|---|
Connection |
Select the Oracle Enterprise Data Management Cloud connection to be used for this job type in the Pipeline. This job type is only supported for a remote operation (a non-local connection). The connection must be defined as an "Other Web Services Provider " connection type. The URL inside the connection must be in the format: To create a new Oracle Enterprise Data Management Cloud connection, see Adding Pre-built Integrations within the EPM Cloud in Administering Financial Consolidation and Close. |
Name |
Select the application for the Oracle Enterprise Data Management Cloud connection. The list of applications populated in the drop-down is based on the available Oracle Enterprise Data Management Cloud applications (for more information, see Creating Application Connections in Administrating and Working with Enterprise Data Management Cloud ). Each application in the drop-down list is concatenated with the application type for easy discovery. |
Dimension Name |
Specify the name of the Oracle Enterprise Data Management Cloud dimension with mapping to export. You can export dimensions to a CSV file for each dimension. |
File Name |
Specify the target file name with a CSV extension to which to export
the dimension mapping, for example:
In this case, you can download the file from the Oracle Enterprise Data Management Cloud staging area to a local inbox folder using the Download File Operation. See Using a File Operations Job Type. |
EDMCS Mapping Location |
Specify the Application dimension bindings mapping location in Oracle Enterprise Data Management Cloud for which mapping rules should be exported. To find the location, navigate to the application, then select Inspect, then select the Dimensions tab, then select the dimension, then select the Bindings tab, then pick the specific dimension, then pick the binding, and then select the Mappings tab where you can see the location name. |
EDMCS Application Connection |
Optional Specify the application connection name defined in the Oracle Enterprise Data Management Cloud application. (This is the connection defined within the Oracle Enterprise Data Management Cloud application, and this is not a Global Connection.) Application connections are not supported or applicable for Universal application types. If specified, the export file is exported to the target environment (for example, the inbox of the EPM Cloud application. If the Oracle Enterprise Data Management Cloud application connection is not supplied, the export file is written to the staging area of the Oracle Enterprise Data Management Cloud application. Files are always exported to the staging area for Universal application types. In this case, files from the staging area can be downloaded using the File Operations job type (see Using a File Operations Job Type for more information.) |
Here are sample Export Dimension Mapping by Name (EDMCS) job type parameters where an Account dimension name is exported to an Account.csv file to a Fusion US-Plan location.