Using an Extract Dimension Viewpoint (EDMCS) Job Type

Use the Extract Dimension Viewpoint (EDMCS) job type to run a viewpoint extract process in the Oracle Enterprise Data Management Cloud. The extract output file can be written to the Oracle Enterprise Data Management Cloud staging area or transferred to a global connection target.

This job type is only supported for a remote operation (a non-local connection). To create a new Oracle Enterprise Data Management Cloud connection, see: Adding Pre-built Integrations within the Cloud EPM in Administering Financial Consolidation and Close. The connection must be defined as an "Other Web Services Provider" connection type. The URL inside the connection must be in the format: https://hostname.com/epm. A URL ending with any other suffix than "epm" does not function properly.

For more information about extracts, see: Working With Extracts in Administrating and Working with Enterprise Data Management Cloud .

Extract Dimension Viewpoint (EDMCS) job type parameters include:

Table 12-15 Extract Dimension Viewpoint (EDMCS) Job Type Parameters and Descriptions

Extract Dimension Viewpoint (EDMCS) Job Type Parameters	Description
Name	Select the name of the application in Oracle Enterprise Data Management Cloud that the extract belongs to. Required.
Title	Specify the title of the job in the pipeline. This parameters defaults to the name of the application.
Dimension Name	Specify the name of the dimension in Oracle Enterprise Data Management Cloud to extract. Required.
Extract Name	Select the name of the extract. Required.
File Name	The target file name to extract the dimension viewpoint to. If the Zip Extract option is disabled in the extract profile, use a text file name. If the Zip Extract option is enabled, use the Zip file name. For example, you could specify: dimension.csv.
(EDMCS) Global Connection	Specify the name of the Oracle Enterprise Data Management Cloud global connection to extract to when extracting to a connection instead of the Oracle Enterprise Data Management Cloud staging area. .

Here are sample Extract Dimension Viewpoint (EDMCS) job type parameters where "Entity" is the dimension to extract.