EPM - How to load Attributes in to PBCS application

                 How to load Attributes in to PBCS application

To load Attributes, prepare file like this.

Employee Number1, Alias, Permanent, Monthly

Employee Number2, Alias, contract, Hourly

Here 3rd, and 4th columns are attributes, which i am going to load along with Emp numbers and Alias metadata using Data Management/Data Exchange.

While creating application, select Dimensions and If needed use prefix.

As it will create dimensions, if you are going to load Custom dimension, select Custom and add Attribute name (Parent member of the attributes which you created in application) and assign UD1/2/3 depends on the no.of the Attributes columns you are loading.

So, create import format, where select Source and Target Dimensions and Attributes.

Note: Few you are getting blanks for few attributes, then generally we will write SQL in mapping, to ignore blanks, but here is the catch. If you ignore Attribute it will ignore that complete line. That means metadata also will not build. so, if you want to use to load metadata along with attributes, you must need one member in Attribute to assign for blanks in attribute list. Attribute will not duplicates also, so, if you want to use like NoAttribute1, and NoAttribute2 etc.

While loading metadata, you can ignore blanks not metadata members, so above tip will be helpful.

Load and Test once it's completed...!! 

Reference:

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/integrations_erp_async_integration.html#GUID-D9049165-6F30-43DD-B9F8-C52C01DFF2B8

EPM DM - File data load with Period and Year columns to EPM Planning

 EPM DM - File data load with Period and Year columns to EPM Planning.

If you are getting Period and Year in the source file itself, to load data we need to use Explicit option Data Load rule, which will connect to Source Period mapping, where we can update periods to match with source file.

No need of Period dimension in Import format for this method. Year you can map to Years.

 

If you are using multi-period in the file, update all periods in Source Period mapping.

For clear reference, refer below video:

https://www.youtube.com/watch?v=h-pHcRT6rgU

Thanks,

Mady

EPM DM - BIP Report as a Source to EPBCS

 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

OIC - Business Rule

 How to execute Business Rule using OIC

Create and launch business rule without any issues. Then Navigate to Application and select Jobs. Create Job with business rule.

In OIC: Use below with Post method:

/HyperionPlanning/rest/v3/applications/NFPR/jobs

Request:

Json: 

{

  "jobType" : "RULES",

  "jobName" : "aso to bso dr"

}

Response:

{

  "status" : "",

  "jobId" : ""

}

To check Status:

/HyperionPlanning/rest/v3/applications/NFPR/jobs/{jobIdentifier}

Use Get Method, Attach JobId with JobIdentifier in mapping

Response:

{"status":"","details":""}

Thanks,

Mady

OIC - To place file in Amazon S3 Bucket

 To place file in Amazon S3 Bucket - we can use below method:

Use Put Object to place file into S3 Bucket.

Update Bucket Name in the below screen

Check Summary and click Finish.

In Mapping, Update details like this. File name you can mention directly, or if needed you can use along with folder name also like mentioned in below screenshot.

After executing you can check S3 bucket, to verify the file is placed or not.

Thanks,

Mady

OIC - Upload file

 To upload file into EPM inbox/outbox folder or into EPM - DM - inbox folder, we can use below:

/interop/rest/11.1.2.3.600/applicationsnapshots/{applicationSnapshotName}/contents

Needs to use Post Method

Request: Select Binary Method

Use Post with below response:

{

  "status" : "",

  "details" : ""

}

Thanks,

Mady

OIC - To get file from Amazon S3 Bucket

 To get file from AWS bucket:

You can use Get Object to pull file from AWS bucket.

Bucker Name and Object name, then in mapping you update same details.

If you upload file in the step, file will pushed to Target location from AWS bucket.

Thanks,

Mady