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.
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:
Login OIC, Go to Connections, create REST API connection to connect to Oracle EPM Planning URL.
Go to Integrations and Click on Create to select Scheduled Orchestration.
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
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
You can add Wait Time, Notifications to send emails, While loops to send an repeat the tasks until completed also.
Once you are done with setup, you can activate and submit now to run the Integration.
You can check the status of integration in Monitoring -- Tracking tab
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
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)
