Performance Considerations for Strategic Workforce Planning Rules
Consider these best practice tips to potentially improve the execution performance of Workforce rules.
-
Workforce rules assume that the
FIXPARALLEL
statement runs on the Entity dimension, which is ideal if you're loading the bulk of your data into the Entity dimension. However, if you load the bulk of your data into another dimension, for example, a Flex dimension such as Project, you can improve performance by modifying theFIXPARALLEL
statement to apply to the Project dimension instead. Workforce provides a template named OWP_Fix Parallel_T that is used in several rules and templates. See table Table 6-9 for a detailed list of rules and templates dependent on OWP_Fix Parallel_T. If you modify theFIXPARALLEL
statement to reflect your optimal dimension, all dependent rules and templates take advantage of the performance improvement.Tip:
To determine the best dimension to include in the
FIXPARALLEL
statement, Oracle recommends that you do some testing using realistic and representative data.To modify the template OWP_Fix Parallel_T:
- As an example, assuming you want to set
Flex Dim1
instead ofEntity
as the dimension used in theFIXPARALLEL
statement:- Open the OWP_Fix Parallel_T template in Calculation Manager in the OEP_WFP cube.
- In "Template Designer", select "Flex
Dimension 1"->"FlexDim1Fix=,@RELATIVE(…" Design-time Prompts
assignment object.
Remove the leading comma from the right side of the Formula equation leaving only
"@RELATIVE({FlexDim1},0)"
from",@RELATIVE({FlexDim1},0)"
. - In "Template Designer", select
"Member selection of…"
Design-time Prompts assignment object.- Swap the right side of the formula equation for the
FixParDimSel
andFixStmtMbrSel
formulae for"@RELATIVE({Department},0)"
and"[FlexDim1Fix]",
respectively.From
FixParDimSel = @RELATIVE({Department},0) FixStmtMbrSel = {Scenario}, {Version} [FlexDim1Fix] [FlexDim2Fix] [FlexDim3Fix] [CurrencyDTP]
To
FixParDimSel = [FlexDim1Fix] FixStmtMbrSel = {Scenario}, {Version} ,@RELATIVE({Department},0) [FlexDim2Fix] [FlexDim3Fix] [CurrencyDTP]
- Ensure a leading comma is placed before
"@RELATIVE({Department},0)"
which should now be in theFixStmtMbrSel
formula.
- Swap the right side of the formula equation for the
- Save the template.
Note: Fix Parallel can have multiple dimensions. You can have one or more dimensions on the right side of
FixParDimSel
in"Template Designer"->"Member selection of…"
. Choose the right dimensions from Entity, Employee, Job or custom dimensions enabled for best results. - Redeploy the following rules and templates after modifying OWP_Fix Parallel_T.
Table 6-9 OWP_Fix Parallel_T Dependent Rules and Templates
Rule/Template Name Rule
OWP_Process Loaded Data
Rule
OWP_Process Loaded Strategic Workforce Data
Rule
OWP_Synchronize Defaults
Rule
OWP_Synchronize Definition
Template
OWP_Incremental Process Data with Synchronize Defaults_GT
Template
OWP_Incremental Process Data with Synchronize Definition_GT
Template
OWP_Incremental Synchronize Defaults_GT
Template
OWP_Incremental Synchronize Definition_GT
Note:
-
Test your changes in your Test instance before applying the changes in Production.
-
When you modify the template, ensure that the syntax (for example, the placement of commas) is valid and balanced by reviewing the Design-time Prompts (DTP).
-
- As an example, assuming you want to set
-
If your organization’s usual practice is to run Synchronize Defaults immediately after running Process Loaded Data, you can reduce execution time by modifying the Process Loaded Data rule to substitute the Synchronize Defaults templates in place of the Synchronize Definition templates in the same relative positions. By doing this, you eliminate the execution time of the Synchronize Definition templates, which is unnecessary if you include the Synchronize Defaults templates in the Process Loaded Data rule because Synchronize Defaults includes the logic in Synchronize Definition.
-
If you load the additional earning, benefit, and tax assignments directly from a source Human Resources or Payroll system, such as Oracle Fusion Human Capital Management, then you do not need to run Synchronize Defaults nor Calculate Compensation. Running Process Loaded Data is sufficient in this use case to calculate compensation for all the loaded data, because it includes Synchronize Component Definition.
- Oracle strongly recommends using the Incremental Data Load process using Data Integration for bulk-loading all Workforce data. This process is the most efficient and optimized solution to load and calculate your Workforce data. See Loading and Calculating Incremental Workforce Data.