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

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"

    }

}

Response:

{

  "status" : 0,

  "details" : "",

  "jobId" : 224,

  "jobName" : ""

}

To check status: GET

                /HyperionPlanning/rest/v3/applications/<appName>/jobs/{jobIdentifier}/details

Response:

{

  "items" : [ {

    "recordsRead" : 0,

    "recordsRejected" : 0,

    "recordsProcessed" : 0,

    "dimensionName" : "Dep",

    "loadType" : "Metadata Import"

  } ]

}

1. Post - import metadata
2. Get - Status
3. Switch - if recordsRejected is 0, then success, Otherwise failed.

Thanks,

Mady

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:

1. Export Year Dimension
2. 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>,
3. Save in zip format
4. Import back in to Planning application.

Some times we may face issue with Data Management while loading SmartList data for BegBalance, like "No Year" member not found.

Thanks,

Mady

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. 

1. Source is our Planning application.
2. Target we need to create as Data Export in Applications in Data Exchange page.
3. File format which you will update must be with Period dimension.
4. 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.
5. Period - select as Period not to be as generic like other dimensions in dimensions list.
6. While creating data load rule, you can select filters, if you want to extract particular data.
7. To pull alias of particular member, you select as below:
1. Account -- map with Account member
2. Account -- map with Account Alias member
8. If you don't select Period as Period, and if it is generic in dimensions list, you will get amount in Period in Workbench.
9. Some Alias may have names with comma, which will mess up exported csv file. Better to use Pipe symbol.
10. You can use .txt format also to get data in correct format.

Thanks,

Mady

OneStream - Data Sources - Formats to load data

 We can load data using below methods into OneStream

1. Fixed Format
2. Delimited format
3. Connectors
4. Data Management

Fixed format, where you can find fixed spaces in the file which we will prepare or get from Sources.

Delimited Format, where you can find delimiters in the file, which we can the settings

Connectors, where you can write business rule to connect to the source system, using connection string details.

Data Management, where you can import, validate, load, etc to load data into OneStream.

Thanks

Mady

Oracle EPM Planning (PBCS): Unable to download the file: details: Invalid file : FCC_2385.log

When trying load data from FCC to PBCS, I found below error in the logs, states that Unable to download the file along with Invalid log file.

Generally, This error occurred whenever we trying to pull data with no filters in Data load rule, so that lot of members/data will be involved to data load process from Source to Target.

 Planning log:

2024-07-31 09:34:05,019 ERROR [AIF]: Unable to download the file: {"details":"Invalid file : SFCC_2385.log.","status":1,"links":[{"href":"https://epm-test-axxxxx.epm.us.oraclecloud.com:443/interop/rest/11.1.2.3.600/applicationsnapshots/SFCC_2385.log/contents","action":"GET","rel":"self","data":null}]}

2024-07-31 09:34:05,023 INFO  [AIF]: EssbaseService.extractData - END (false)

2024-07-31 09:34:05,029 FATAL [AIF]: Error in CommData.extractDataFromSource

Traceback (most recent call last):

  File "<string>", line 2862, in extractDataFromSource

RuntimeError: false

URL in the above log showing invalid file, so when I verified in the FCC log, it is sating as below

FCC log:

2024-08-01 03:00:16,759 ERROR [AIF]: Cannot perform cube view operation. Essbase Error(1024015): Request [MdxReport] from user [epm_default_xxx_admin] was terminated by an admin user

2024-08-01 03:00:16,801 INFO  [AIF]: EssbaseService.extractData - END (false)

2024-08-01 03:00:16,801 ERROR [AIF]: false

2024-08-01 03:00:16,814 INFO  [AIF]: FDMEE Process End, Process ID: 2,385

Solution that Oracle suggested:

1. In the Data load rule, create filters for each dimensions to export less number of records.
2. Create multiple Data Load rules to export the data to the target application by applying different set of filters as needed.

Thanks,

Mady