OIC - Pull data using BIP Report into Data Management with Substitution variables

      How to pull data using BIP Report into Data Management with Substitution variables

• Go to Data Exchange > Applications, Select Data Source and Select EPM(Custom)
• In File, select BIP Report file which you are going to pull data. This column structure we need to pull data in to the system correctly.
• Update Report details as shown below: Select ERP connection Name.
• Select Execution Method as BIP Report and Report name along with Path
• Parameter List, if not mentioned any, select unique in the columns like Period=Jan or dummy column with Y like shown below.

If we are planning to execute report data load like Jan-26, which we are going to load that using Data Management, we can mention below as an argument to pick up Period from POV of the Data load Rule.

argument1=$START_PERIODKEY[MMM-YY]$;

If we are planning to use Substitution variables to pass through arguments like above method, it will not work. Because this report is going to connect to ERP, but our variable needs to pick from EPM.

In case of using substitution variable in OIC to execute dataload rule, OIC will pick substitution variable from EPM to execute Data load rule, which will pass same to BIP Report also. In this case substitution variable will work. 

Generally, to bring substitution variables from EPM Planning application to OIC to run the Data load Rule with that period we can use as below:

'{&CurrentMonth#&CurrentYear}'

Thanks,

Mady

                                         EPM DM - BIP Report as a Source to EPBCS

As part of data loading we can pull data from different source systems. Using Data Source option, we can pull directly BIP report from Fusion application.

• Create Source application with Oracle Cloud ERP(Custom), here we are creating source for workforce data. We need to upload and browse for the Report template, to get source columns as members of Source application.

• Go to option, where we need to update Fusion application, fill other parameters as per report requirement.

• Create an import format with Source and Target(EPBCS), map dimensions of source and target. 
• Try to import data and check are we getting data or not. In case of any issue in pulling data, check Report permissions in ERP.

Thanks,

Mady