Followers

Thursday, June 15, 2023

EDMCS - Create Subscription

How to create subscriptions? Subscription is used for??

Go to Views à Select the view à Click on 3 dots and select Inspect as shown in the below screenshot à Select Subscriptions and then click on Create à Select the dimension from the list.




Thanks,

Mady

EDMCS - Create Converters

How to create converters? Converter is used to move members from source to target.

Go to à Node Types à Click on 3 dots and select Inspect  à It will open the below page.

Select Converters à Click on Edit then Add à Select Target dimension.


To move, I mean drag and drop metadata with New Request from one view to another view, we have created Convertor in both Source and Target. 

For example, if the source is Main application and Target is FCCS or Plan, then we must create Convertor in both Node Types.

Thanks,

Mady

Tuesday, June 13, 2023

EDMCS - Create NodeSet

 To Create Node Set, just follow below steps:

Node Set:

Login to EDMCS à Select Node Set à Click on Create à Select dimension of the application.


Thanks,

Mady

EDMCS - Create Hierarchy Set

 To create hierarchy, just follow the below steps:

Hierarchy Set:

Login to EDMCS à Select Hierarchy Set à Click on Create à Select dimension of the application.




Thanks,

Mady


 


Thursday, June 1, 2023

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



Wednesday, May 3, 2023

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