Utilising EPM Platform Jobs in Pipelines

Keeping up with Hyperion · 3 years ago · 89 views

Pipelines allow administrators to schedule jobs in the required order, including pre-processing rules, data load rules and post-processing rules in an easy and accessible interface via Data Integration. This is replacing the existing Batch functionality which is currently available in Data Management, but will soon be decommissioned. Each pipeline is made up of a series of Stages, where a Stage is a group of jobs. There are many job types available, including business rules, integrations, EPM Platform jobs and many more! Each job has various settings depending on the job type. These settings can reference Pipeline level variables or use a specific setting for that particular job. In this blog we will focus on the EPM Platform Job types, which are slightly different to the standard pipeline jobs and require custom parameters, based on the REST API commands.   Example 1 – Administration Mode The Administration Mode platform job can be used to set the application login level to admins only or to all users. To do this, add a new job and select: Type = EPM Platform Job Connection = Local Title = Enter title for the job, e.g. Admin Mode On / Off Sequence = the order in the stage Job Type = Administration Mode Then the parameters must match the REST API parameters, as detailed here: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/pbcs_admin_job.html#reference-1481-0d15b0c8 There is one parameter for this job type. Enter a new parameter as below:  Label = loginLevel Value = Administrators – to enable admin mode  All Users – to disable admin mode Note: these parameters labels and value are case sensitive so be careful when entering them (recommend copying from the documentation)   Example 2 – Restructure Cube The Restructure Cube job is used to perform a full BSO cube restructure. To do this, add a new job and select:  Type = EPM Platform Job  Connection = Local Title = Enter title for the job, e.g. Restructure Finance Cube Sequence = the order in the stage Job Type = Restructure Cube Then the parameters must match the REST API parameters, as detailed here: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/pbcs_restructure_job.html#GUID-84A931ED-3D16-453E-AA68-DF44F5C22F1D There is one parameter for this job type. Enter a new parameter as below: Label = cubeName Value = name of the BSO cube e.g. FinCube Note: these parameters labels and value are case sensitive so be careful when entering them (recommend copying from the documentation)   Example 3 – Merge Data Slices The Merge Data Slices job is used to merge ASO data slices, which should improve performance of the ASO cube. To do this, add a new job and select: Type = EPM Platform Job Connection = Local Title = Enter title for the job, e.g. Merge ASO Data Sequence = the order in the stage Job Type = Restructure Cube Then the parameters must match the REST API parameters, as detailed here: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/pbcs_merge_data_job.html#GUID-59975792-7709-4E19-909D-6114C34F95B2 There are three parameters for this job type. Enter the 1st parameter as below: Label = cubeName Value = name of the ASO cube e.g. PRJ_RPT Enter the 2nd parameter as below: Label = keepZeroCells Value = possible values are true or false Enter the 3rd parameter as below: Label = mergeSliceType Value = Possible values are: allIncrementalSlicesInMain (Merge all into the main slice) allIncrementalSlicesInOneIncremental (Merge all incremental into a single incremental slice) Note: these parameters labels and value are case sensitive so be careful when entering them (recommend copying from the documentation) Details of the REST API parameters for other EPM platform job types can be found here: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/execute_a_job.html#planning_rest_apis_3 For the full range of EPM Platform Jobs available to schedule in a Pipeline, see the Oracle documentation here: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/integrations_pipeline_epm_platform_job.html#GUID-36AD5A62-ADDB-4012-AFBF-4BE7AAB720DA Happy scheduling!