Batch Control Samples

The following sections show samples of the batch control processes.

batch_exec_list.txt

# Load a custom hierarchy, measure before weekly 
batch hook_batch_weekly_pre |hierload |suph~0~N 
hook_batch_weekly_pre |measload |c_load_vndr

# Run Batch calc and new custom exports after end of weekly batch 
hook_batch_weekly_post |calc |c_calc_vndr
hook_batch_weekly_post |exportmeasure |c_exp_vndr

batch_calc_list.txt

# Run newly added custom calc rule group in 
batch c_calc_vndr | G | GROUP | c_batch_agg_vndr

batch_loadmeas.txt

# Load custom measure 
c_load_vndr | M |c_drtyvndrfndr

batch_exportmeas.txt

# Export custom measure 
c_exp_vndr|O|vendo_plan.csv.dat 
c_exp_vndr|X|storsclsweek 
c_exp_vndr|F|c_exportmask 
c_exp_vndr|M|c_mpcpvndrplan

Below sections describes Batch Control details that are specific to AP:

The following table describes the Custom Hooks available in the batch process.

Table 9-8 Custom Hooks in the Batch Process

Hook Description

hook_postbuild_pre

This hook is added at the beginning of the postbuild batch which runs after the initial domain build.

hook_postbuild_post

This hook is added at the end of the postbuild batch which runs after the initial domain build.

hook_postpatch

This hook is added at the end of the service patch process which runs after the service patch.

hook_batch_daily_pre

This hook is added before the daily batch process.

hook_batch_daily_post

This hook is added at the end of daily batch process before the dashboard build.

hook_batch_weekly_pre

This hook is added before the weekly batch process.

hook_batch_weekly_post

This hook is added at the end of the weekly batch process before the workbook refresh and segment build.

If the customer is using the JOS/POM flow schedule to schedule jobs in AP, then the following hooks can be used. The AP JOS/POM job flow is connected to use the same set names similar to the hooks shown in the following table without hook_* in it and in turn calls each of the corresponding hooks. So the customer can easily customize their AP batch flow based on their needs by simply changing the hooks or adding additional steps to the existing pre-configured hooks.

The naming convention followed is:

  • _RDX that is used for any integration step using RDX.

  • _OBS is used for any steps using Object Storage.

  • _D is for jobs that runs daily.

  • _W is for jobs that runs weekly.

Table 9-9 Custom Hooks in the Batch Process

Hook Description

hook_AP_PRE_EXP_RDX_D

This hook is for the calling steps using the Daily Export Interfaces to RDX as soon as the batch starts.

hook_AP_PRE_EXP_OBS_D

This hook is for the calling steps using the Daily Export Interfaces to Object Storage as soon as the batch starts.

hook_AP_PRE_EXP_RDX_W

This hook is for calling steps using the Weekly Export Interfaces to RDX as soon as the batch starts.

hook_AP_PRE_EXP_OBS_W

This hook is for the calling steps using the Weekly Export Interfaces to Object Storage as soon as the batch starts.

hook_AP_COM_HIER_IMP_RDX_D

This hook is for the calling steps using any Daily Import of common hierarchies from RDX.

hook_AP_COM_HIER_IMP_OBS_D

This hook is for the calling steps using any Daily Import of common hierarchies from Object Storage.

hook_AP_COM_HIER_IMP_RDX_W

This hook is for the calling steps using any Weekly Import of common hierarchies from RDX.

hook_AP_COM_HIER_IMP_OBS_W

This hook is for the calling steps using any Weekly Import of common hierarchies from Object Storage.

hook_AP_COM_DATA_IMP_RDX_D

This hook is for the calling steps using any Daily Import of common data interfaces from RDX.

hook_AP_COM_DATA_IMP_OBS_D

This hook is for the calling steps using any Daily Import of common data interfaces from Object Storage.

hook_AP_COM_DATA_IMP_RDX_W

This hook is for the calling steps using any Weekly Import of common data interfaces from RDX.

hook_AP_COM_DATA_IMP_OBS_W

This hook is for the calling steps using any Weekly Import of common data interfaces from Object Storage.

hook_AP_HIER_IMP_RDX_D

This hook is for the calling steps using any Daily Import of application-specific hierarchies from RDX.

hook_AP_HIER_IMP_OBS_D

This hook is for the calling steps using any Daily Import of application-specific hierarchies from Object Storage.

hook_AP_HIER_IMP_RDX_W

This hook is for the calling steps using any Weekly Import of application-specific hierarchies from RDX.

hook_AP_HIER_IMP_OBS_W

This hook is for the calling steps using any Weekly Import of application-specific hierarchies from Object Storage.

hook_AP_PRE_DATA_IMP_RDX_D

This hook is for the calling steps using any Daily Import of application-specific data interfaces from RDX.

hook_AP_PRE_DATA_IMP_OBS_D

This hook is for the calling steps using any Daily Import of application-specific data interfaces from Object Storage.

hook_AP_PRE_DATA_IMP_RDX_W

This hook is for the calling steps using any Weekly Import of application-specific data interfaces from RDX.

hook_AP_PRE_DATA_IMP_OBS_W

This hook is for the calling steps using any Weekly Import of application-specific data interfaces from Object Storage.

hook_AP_BATCH_AGG_D

This hook is for the calling steps doing any regular daily batch aggregation after hierarchy and data loads.

hook_AP_BATCH_AGG_W

This hook is for the calling steps doing any regular weekly batch aggregation after hierarchy and data loads.

hook_AP_POST_DATA_IMP_RDX_D

This hook is for the calling steps using any Daily Import of application-specific data interfaces from RDX after the calc steps.

hook_AP_POST_DATA_IMP_OBS_D

This hook is for the calling steps using any Daily Import of application-specific data interfaces from Object Storage after the calc steps.

hook_AP_POST_DATA_IMP_RDX_W

This hook is for the calling steps using any Weekly Import of application-specific data interfaces from RDX after the calc steps.

hook_AP_POST_DATA_IMP_OBS_W

This hook is for the calling steps using any Weekly Import of application-specific data interfaces from Object Storage after the calc steps.

hook_AP_POST_EXP_RDX_D

This hook is for the calling steps using any Daily Exports to RDX after the batch aggs.

hook_AP_POST_EXP_OBS_D

This hook is for the calling steps using any Daily Exports to Object Storage after the batch aggs.

hook_AP_POST_EXP_RDX_W

This hook is for the calling steps using any Weekly Exports to RDX after the batch aggs.

hook_AP_POST_EXP_OBS_W

This hook is for the calling steps using any Weekly Exports to Object Storage after the batch aggs.

hook_AP_WB_BUILD_D

This hook is for the calling steps specific to workbook refresh or build in the daily cycle.

hook_AP_WB_BUILD_W

This hook is for the calling steps specific to workbook refresh or build in the weekly cycle.