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)
Drill through using Data Management from EPBCS to ERP Cloud
Source System
Go to Setup -> Source System -> Click on Add
Mention Source System Name, Description is optional
Then Select Source System Type as Oracle ERP Cloud
Update Drill Through URL with ERP Cloud URL.
Click on Configure Source Connection and Enter credentials in the popup.
Click on Test Connection and wait for configuration successful message.
Now, Click on Initialize to connect to the Source System. This process will monitor in Process details tab. Check process is successful or not. This process will create below process in Target application.
Create Location, select Import Format. and Save
Go to Workflow, Data Load Mapping first, select Location, Period and Scenario. Then Map all source members with Target dimension members. Mainly we are doing this process for Drill back, So, in Account dimension, map all members correctly.
Create Data Load Rule, Execute the rule.
Once it is successful, you can check workbench to verify the data.
Validation:
Once Data Load Rule is successful, we need to validate Drill through process.
Go to Workbench -> Data Column
Right click on data column and click on Drill Through to Source Option
Once we click on this, it will take to Source System page.
Other than this, we can test the same from DATA FORM also.
