Oracle Data Management - Target Options

 We can create different types of target in the Data Exchange. 

EPM Local: To make current application as Target, we can use this method.

EPM Cloud: To connect to any other cloud application, use this method. Where we can update URL, username, password, domain etc. 

Data Source: Have lot of in built adaptors, to create as a Target.

Data Export: To export data from application, use this option.

Dimensions: To build dimensions, use this method, where system will give 6 different types of dimensions along with Custom option.

EPM Local:

EPM Cloud:

Data Export:

Data Source:

Dimensions:

Thanks,

Mady

Oracle Cloud EPM Planning - Load metadata using Data Management

 Loading metadata also one of the major task to automate the process.

Create Source application as File and Target application as Dimensions.

once Dimensions selected, we have to select application name and Prefix. Once you click on OK, system will create 6 types of EPM Dimension Target will get create automatically.

ACCOUNT, ENTITY, SMARTLIST, VERSION, SCENARIO, and CUSTOM

We have to use Custom as our Target to build dimensions other than mentioned above.

Import Format, used to build the dimension is:

We have selected only Member Name, Parent, Alias and Data Storage.

As we know, create location and period mappings as per the requirement. Create Data Rule, and update mappings accordingly. In case of any rows getting blanks in any column of the file, we can use below logic in mapping. 

#SQL

CASE

WHEN ICP IS NULL THEN ' '

ELSE ICP

END

Finally, loading metadata will be done with 3 golden fishes. :)

Thanks,

Mady