To get file from AWS bucket:
Documented Issues which I faced in my daily work on Oracle EPM(On-Premise and Cloud), and also on OneStream
Followers
Wednesday, June 4, 2025
OIC - To get file from Amazon S3 Bucket
OIC - Application Admin Mode
To upload file into EPM inbox/outbox folder or DM inbox folder:
Post:
/HyperionPlanning/rest/v3/applications/NiccoFPR/jobs
Request:
{
"jobType" : "Administration Mode",
"jobName" : "AppAdminJob",
"parameters" : {
"loginLevel" : "Administrators"
}
}
In Mapping:
To make application into Admin Mode, Use Parameter as Administrators or to release application for all users, mention as All Users
Thanks,
Mady
OIC - Import Data
To Import Data: we can use below with RESTApi - to execute from OIC
Post:
/HyperionPlanning/rest/v3/applications/NiccoFPR/jobs
Request:
{
"jobType": "IMPORT_METADATA",
"jobName": "ImportMetaDataJob",
"parameters": {
"errorFile":"ImportMetaDataErrorFile.zip",
"importZipFileName": "myMetaDataDailyJob.zip"
}
}
Response:
{
"status" : 0,
"details" : "",
"jobId" : 224,
"jobName" : ""
}
Get Status:
/HyperionPlanning/rest/v3/applications/NiccoFPR/jobs/{jobIdentifier}/details
Import metadata status:
Response:
{
"items" : [ {
"recordsRead" : 0,
"recordsRejected" : 0,
"recordsProcessed" : 0,
"dimensionName" : "Departments",
"loadType" : "Metadata Import"
} ]
}
Thanks,
Mady
Tuesday, May 20, 2025
OIC - Import metadata
To import metadata using OIC - RESTApi, we can use below to automate the process.
To execute Import metadata, POST
/HyperionPlanning/rest/v3/applications/<appName>/jobs
Request:
{
"jobType": "IMPORT_METADATA",
"jobName": "ImportMetaDataJob",
"parameters": {
"errorFile":"ImportMetaDataErrorFile.zip",
"importZipFileName": "myMetaDataDailyJob.zip"
}
}
- Post - import metadata
- Get - Status
- Switch - if recordsRejected is 0, then success, Otherwise failed.
Thursday, March 20, 2025
Oracle EPM - How to add "No Year" in to EPM Planning application
As you all know, we can't add additional member like "No Year" in Year Dimension. We can add number of years but not "No Year", as it is system defined.
But there is trick which Oracle published to add "No Year" in Year Dimension.
Steps are simple:
- Export Year Dimension
- Edit csv file, and add below line in bottom of the page.
- "No Year",Years,,store,false,,<none>,<none>,,,unspecified,false,true,,,"No Year",<none>,
- Save in zip format
- Import back in to Planning application.
Tuesday, February 18, 2025
Oracle EPM - Data Extract from Planning using Data Management - Tips
Hi All, Data Extract from Planning using Data Management already documented with steps. You can check that with below link.
Data Extract from Planning using DM
Here, I am updating few steps, which may confuse for someone.
- Source is our Planning application.
- Target we need to create as Data Export in Applications in Data Exchange page.
- File format which you will update must be with Period dimension.
- Amount or data - no need to mention, as system will automatically will take. If you mention in file it will show up in application details as member or dimension, which may show up double in Import Format.
- Period - select as Period not to be as generic like other dimensions in dimensions list.
- While creating data load rule, you can select filters, if you want to extract particular data.
- To pull alias of particular member, you select as below:
- Account -- map with Account member
- Account -- map with Account Alias member
- If you don't select Period as Period, and if it is generic in dimensions list, you will get amount in Period in Workbench.
- Some Alias may have names with comma, which will mess up exported csv file. Better to use Pipe symbol.
- You can use .txt format also to get data in correct format.
Wednesday, November 6, 2024
OneStream - Data Sources - Formats to load data
We can load data using below methods into OneStream
- Fixed Format
- Delimited format
- Connectors
- Data Management