POSTFIXPARALLEL
The POSTFIXPARALLEL calculation command block for Essbase is an optional, post-processing block you can use within FIXPARALLEL...ENDFIXPARALLEL to copy temporary, thread-level THREADVAR values into longer-persisting VAR variables that you can use outside of the FIXPARALLEL block.
Syntax
POSTFIXPARALLEL ( [ varName = ACCUMULATEVAR (threadVarName ); ]* );
Parameters
Notes
To copy temporary THREADVAR values into VAR variables you can use outside FIXPARALLEL, use the following task flow:
-
Declare a VAR variable (outside of FIXPARALLEL block) to store the computed result.
-
Declare a THREADVAR variable that you use within the FIXPARALLEL block.
-
Use a POSTFIXPARALLEL block to copy the THREADVAR to the VAR.
Example
The following example accumulates Sales values from THREADVAR variables to a VAR variable.
/* Store computed result of four tasks */
VAR totalSalesAmnt = 0;
/* Four tasks */
FIXPARALLEL (2, "New York", "California", "Oregon", "Florida")
/* Accumulate results of tasks into threads */
THREADVAR s_entitySalesAmnt;
/* Use for computation in each task */
THREADVAR entitySalesAmnt;
/* Use/change THREADVARs within member formula blocks */
"Sales"
(
/* Initialize variables for this task */
entitySalesAmnt = 2;
/* Use the THREADVARS ... */
/* Accumulate task-data into thread-data */
s_entitySalesAmnt = s_entitySalesAmnt + entitySalesAmnt;
);
/* Copy computed data into longer-persisting VAR */
POSTFIXPARALLEL ( totalSalesAmnt = ACCUMULATEVAR ( s_entitySalesAmnt ););
ENDFIXPARALLEL