This section describes how to set up and execute a simplified batch required for running ALM BI processes.
To execute a procedure through the Simplified Batch user interface, create a batch through the following steps:
1. From OFSAAI Home, navigate to Financial Service Application, select Administration, and then select Simplified Batch.
2. Click Add + to add a new Batch.
3. Enter the Name and Description of the Batch that you wish to add.
4. Select Folder Name and Access Type.
5. Select Batch Execution Type: Parallel or Sequential.
6. Parallel Execution signifies the list of tasks to be executed in Parallel Sequential Execution signifies the list of tasks to be executed in sequential order.
7. Click Select Task in Task Details pane.
8. Select Task Type and Source. (See Table the following mapping for more information.)
|
Procedure |
Task Type |
Folder or Source |
Task Selector or Rule Name |
|---|---|---|---|
|
Hierarchy Flattening Process |
Transform Data |
Not Applicable |
batch_hierTransformation |
|
ALMBI Transformation |
Transform Data |
Not Applicable |
ALM_BI_TRANSFORMATION |
|
Time Dimension Population |
Transform Data |
Not Applicable |
Dim_Dates_Population |
|
DIM RUN Population |
Transform Data |
Not Applicable |
Populate_Dim_Run_ALM |
|
Account Summary Population |
Load Data |
<select the appropriate source> |
<Choose the T2T name for the instrument you want to process> |
9. Click Search to view the list of Tasks based on Task Type.
10. In the Task Selector pane, select Task. Drag and drop into the right pane. (That is, Rule Name, which is a seeded Data Transformation procedure installed as part of the OFS ALM Analytics application installer. If you don't see this procedure in the list, contact Oracle support.)
NOTE |
You can deselect the task by dragging and dropping it into the left pane. |
11. Click OK.
In the Task Details pane, select the Task by clicking on the checkbox and enter the optional parameters. Here the optional parameters would be the same parameter list as mentioned in the respective batch execution processes.
12. Click Save.
13. Select the Batch you created by clicking on the checkbox in the Simplified Batch Summary window.
14. Click Run to execute the Batch.