EDMCS - Sample Metadata

 In EDMCS, We can update metadata into PBCS, FCCS, FCGL, Universal etc. you can find the list in the below screen shot.

Once login, Go to Application, Click on Register, select application type, enter name of the application, then you can add connection, dimension members etc.

Once application created, click on the three dots right side. In the list you can import, export options.

Select import option and choose the file of that particular dimension and click on import.

File format as follows:

Once import is done, you can verify the account dimension in the hierarchy.

Thanks

Mady

EDMCS - Application creation

 Loading metadata will be the first step of EDMCS after creating applications. So, We can create applications using below options

Once you login, Click on Applications

 

Click on Register on the left side. 

Select application type in the screen

For example, Select Planning, then update Planning application name and description and click on Next

Once you click on Next, you can create a connection to connect to Planning application or you can create later also. If you want to create connection, click Add. Otherwise click on Next and Click on Create.

You can see application in Applications tab now. If you want to modify Registration, you can click on 3 dots on the left of the side line, and select Modify Registration.

There you can see options like Inspect, Import, export, extract, load etc.

Will explain about each option in coming sessions.

Thanks

Mady

OIC - EPM - Data Load process in Data Management

 We can automate data management process, to run data load rule which is running successfully in data management. We can get doubt as we can schedule it in data management itself why we need OIC ??

Yes, you are correct we can schedule the data load rule to run on particular time using scheduling options in data management. But we can do more than that in OIC - Oracle Integration Cloud.

For example, If you want to run data load using just by changing Substitutional variables(start_Period, end_Period, import_mode, export_Mode), you can do that using OIC. If you are good at Groovy script, you can write a business rule also, to run Data Load rule by using EPM Automate commands.

OIC - to run data load rule by using substitutional variables:

1. Login OIC, Go to Connections, create REST API connection to connect to Oracle EPM Planning URL.
2. Go to Integrations and Click on Create to select Scheduled Orchestration. 
3. Select RestAPI, to pull Substitutional Variables into OIC using Get option.
   https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/planning_get_a_subst_variable_for_app_2.html
4. Select RestAPI, once again to run Data Load Rule.
   https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cepma/epm_auto_run_data_rule.html
   Or
   https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/fdmee_integration_jobtype_106x0fea7396.html
5. You can add Wait Time, Notifications to send emails, While loops to send an repeat the tasks until completed also.
6. Once you are done with setup, you can activate and submit now to run the Integration.
7. You can check the status of integration in Monitoring -- Tracking tab

Thanks,

Mady

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

EPM Cloud - Drill Through from SmartView

Drill Through we can do using 3 ways:

1. Workbench data
2. Data Form
3. SmartView

Once you open SmartView, Right Click on Data Cell and Click on Drill through

Before this step we can select below to open Drill through in web browser or in new sheet

In SmartView >> Options >> Advanced >> Drill Through Launch

Once you click on Drill Through, you will get open in New Web Browser or In New Sheet.

If you face any issue regarding the above drill through option with Excel, you have to add extension to the browser. Please refer below document for the same.

Unable To Drill Through On SmartView Reports The information you’re about to submit is not secure (Doc ID 2825480.1)

Thanks,

Mady