How to Load Multi-Column Data Load in Data Management

 If we get data in multi columns, for example as below:

We can use Multi-Column Numeric Method to load this for all months in one shot.

Mainly, Set below option as Multi Column - Numeric Data in Import Format.

In Import Format, Mappings, we need to specify Period Columns and mention as Driver name as Period

Now, Create Data Rule with above created Import Format.

To Mention Period - We will get an option like below as Column Headers

Here, we can select period as per columns in the Source File. In Target Options also Numeric Data only is fine. 

Note: If we change this option, can't get back Numeric Data Only option. Think twice before changing this option.

Now, We are set to load data, Update Data Load Mappings and Execute the Data Load Rule.

Thanks,

Mady

Clear cube in PBCS

 To do Defragmentation in On-Prem, we will do clear data and load data to remove fragmentation of the cube.

Like same, we can clear cube in EPM Cloud also using Clear cube option.

First, If we are planning to clear data we can clear data with below option: Navigate > Rules > Database Properties > Expand App name > Right click on the Cube name and can select Clear option you can select as shown below.

If we want clear cube completely, we can use below option. Navigate > Application Overview > Cubes > Actions > Clear Cube

Click on Create and select the combinations how you want to clear data in that cube. Once done, go to actions as shown below, click on Submit

you can check the status of the same in Jobs. Navigate > Application Overview > Jobs

Thanks,

Mady

How to Reset Service in PBCS

 If we are facing issue with slowness or any abnormal and want to restart service of PBCS environment, we can do this process using EPM Automate.

– Login to EPM Automate

Usage: epmautomate login username password url identitydomain

Example: epmautomate login Mady_Admin P@ssWord12 https://myservice-mydomain.epm.us1.oraclecloud.com mydomain

– Run reset Service Command

Example: epmautomate resetservice “Users experience unacceptably slow connections”

Note: If you want to upgrade EPM Automate, you can use upgrade option.

Thanks,

Mady