14.4.1 Resave Hierarchies

Re-save the following Hierarchies and then proceed with the Run Pipeline execution.

  • Currency Dimension - Currency for Balance Computation
  • Data Source Dimension - Data Source for Balance Computation
  • Legal Entity Dimension - Legal Entity for Balance Computation

Note:

It is recommended to use the following allowed characters in the Hierarchy browser during PMF execution.

Table 14-1 Allowed Special characters in Member/Code Identifier

Field Name Description or Instruction
@ At sign
# Pound sign/Hash
~ Tilde
% Percent
& Ampersand
* Asterisk
( Open parenthesis
) Close parenthesis
+ Plus sign
| Pipe character
{ Open brace
} Close brace
[ Open square bracket
] Close square bracket
: Colon
. Period
; Semicolon
< Less than sign
> Greater than sign
_ Underscore
- Hyphen
! Exclamation point
/ Forward slash
= Equal sign
? Question mark

Table 14-2 Allowed Special characters in Member Description

Field Name Description or Instruction
# Pound sign/Hash
~ Tilde
@ At sign
% Percent
' Apostrophe or Single quote
& Ampersand
* Asterisk
( Open parenthesis
) Close parenthesis
+ Plus sign
[ Open square bracket
] Close square bracket
| Pipe character
{ Open brace
} Close brace
: Colon
. Period
; Semicolon
? Question mark
! Exclamation point
/ Forward slash
, Comma
< Less than sign
> Greater than sign
_ Underscore
- Hyphen
= Equal sign

To re-save the BCE Hierarchies in the Process Orchestration, do the following:

  1. On the Home Page, select Process Orchestration from the LHS menu. The Process Modeller page is displayed.
  2. Create a pipeline BCE Hierarchy Resave and enter information in the Process Details window such as Process Name, Process Description, App Package ID as Balance Computation Engine, Type as Run Pipeline, Spark DB as No and the Service ID Workspace as Oracle Financial Services Data Service for Analytics WS001 and click the OK Button to save the details in the Process Orchestration page before re-saving them.
  3. On the Process Modeller Page, search for the created pipeline. The Process Flow Page is displayed. This Process Flow is designed on the Drawing Canvas using the Transition, Activity, and Widgets Components available in the floating toolbar. A HIERARCHYRESAVE Widget is added to the START for the purpose of resaving the Hierarchy.
  4. Once the HIERARCHYRESAVE Widget is added in the Drawing Canvas, double-click the HIERACHYRESAVE Node, the HIERARCHYRESAVE window is displayed. Enter information in the Activity Desc field. Under Dynamic Parameters for HIERARCHYRESAVE fields, select the Entities, and then the corresponding Hierarchy names, and select Load Type as Resave. Click Tick mark icon to save the details.
  5. To execute the Run, you can select the Run Parameter Values using the Execution Button on the Process Flow Page or on the Process Modeller Page.
  6. Go to the Process Modeller Page to execute the Run. Click the Menu Button corresponding to the pipeline. Click Execute Run. The Execution Page is displayed.
  7. On the Execution Page, select the Execution Type as Without Parameters. Enter a unique value for the Object ID.
  8. To save the details and execute the Run, click the Apply Button. The resaving process begins.

    Note:

    See the Managing Processes section for more details about the Processes.
  9. To verify the Run Execution (BCE Hierarchy Resave), do the following:
    1. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Modeller Menu.
    2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the BCE Hierarchy Resave Processes. On the Process Monitor Page, search by the Process ID, or by the Process Name BCE Hierarchy Resave, and select the Process Instance for the required Run Pipeline (BCE Hierarchy Resave) that was executed.

    The Process Flow Page is displayed with the Run Execution Status on each Node of the BCE Hierarchy Resave Process.

  10. To verify the Run Execution Logs, do the following:
    1. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs. The Process Flow Page is displayed with the Run Execution Status on each Node.
    2. To see the Execution Status details of a Node, double-click on that Node. The Execution Status details Page is displayed. Click Execution Logs. The Log Viewer Page is displayed, which lists all the Logs related to the Process Instance. To see the details of a log entry, click the Show More Button. Click outside the Log Viewer Page to close it.