Flow calculations are performed by the Chart_Batch_GAP_Movement, the Chart_CarryForward, and the Chart_GAP_Movement rules for a financial model that includes the Flow dimension.
For information about Flow properties and Flow dimension members, see About the Flow dimension.
The Chart_GAP_Movement and Chart_Batch_GAP_Movement rules do not calculate closing value (CLO) flow. Instead, these rules validate the closing amount entered by the user against the sum of openings, additions, and disposals in the Flow dimension.
Note: Closing is always input by a user. PerformancePoint Planning Business Modeler stores the amount entered by the user in the Business Process dimension Input member. When the value entered by the user does not match the calculated closing amount, the difference is stored in the movement flow (MVT) member of the Flow dimension.
Calculations for OPE
The Chart_CarryForward rule computes opening balance flow (OPE) for Balance Sheet accounts in financial models that include the Flow dimension. The rule calculates OPE for a selected period, entity, scenario, and business process.
The following tables provide examples of how OPE is computed in two different views of the TimeDataView dimension: Periodic and YTD. Values are expressed in the currency of the specified entity.

Periodic view: For each period, OPE is computed as CLO for the previous period.
Flow 
Previous Q4 
Q1 
Q2 
Q3 
Q4 
Year 
OPE 
 
100 
110 
115 
125 
100 
ADD 
 
10 
5 
10 
15 
40 
CLO 
100 
110 
115 
125 
140 
140 

YTD view: For each period, OPE is computed as CLO for the previous year.
Flow 
Previous Q4 
Q1 
Q2 
Q3 
Q4 
Year 
OPE 
 
100 
100 
100 
100 
100 
ADD 
 
10 
15 
25 
40 
40 
CLO 
100 
110 
115 
125 
140 
140 
Calculations for MVT
The MVT is the difference between CLO and the sum of all other flows for all business processes and currencies. The Chart_GAP_Movement stored procedure initiates MVT calculation for all members of the Business Process dimension as part of Consolidation, Currency Translation, and Intercompany (IC) Reconciliation jobs. In addition, the Chart Logic process calculates MVT when it saves fact data.
Note: For more information about the Flow dimension members mentioned in the following topics, see About the Flow dimension.
MVT over a single time period
The following tables show how the rules calculate MVT during a single period by using values from the increase flow member (ADD), the decrease flow member (DISP), and CLO.
Table 1 shows values in selected dimension members when the data is loaded.
Table 1: Values with Flow dimension at data load
Account 
Flow 
TimePeriod 
Entity 
Currency 
Value 
XXXXX 
ADD 
20043 
MyEntity 
USD 
200 
XXXXX 
DISP 
20043 
MyEntity 
USD 
150 
XXXXX 
CLO 
20043 
MyEntity 
USD 
350 
Table 2 shows values in the same dimension members after you run the Chart Logic rules. To calculate MVT, the procedure computes the difference between CLO and all other flows. However, when the rules calculate MVT, Planning Business Modeler uses the ReverseSign property of the Flow dimension to determine the sign of each particular value. All data has a positive sign when it is loaded. If the ReverseSign property for a Flow member is TRUE, the procedure reverses the sign of the associated value that is used in calculation.
The ReverseSign property of the DISP flow is TRUE. Therefore, the sign of its associated value is reversed for calculation. In the example, the procedure uses a value of 150 for DISP. The following equation shows how MVT is calculated for this example.
MVT = CLO – ADD – (DISP) = 350 – 200 – (150) = 300
Table 2: Values with flow dimension after Chart Logic completion
Account 
Flow 
TimePeriod 
Entity 
Currency 
Value 
XXXXX 
ADD 
20043 
MyEntity 
USD 
200 
XXXXX 
DISP 
20043 
MyEntity 
USD 
150 
XXXXX 
CLO 
20043 
MyEntity 
USD 
350 
XXXXX 
MVT 
20043 
MyEntity 
USD 
300 
For more information about the ReverseSign property of Flow dimension members, see Flow types.
MVT over several time periods
The Chart Logic rules support calculating Flow values over multiple periods. Table 3 shows how this calculation might appear in a report.
Table 3: MVT values over several time periods
FLOW 
Q1 2004 
Q1 2005 
Q1 2006 
CLO 
$6,000.00 
$3,000.00 
$0.00 
OPE 
$0.00 
$6,000.00 
$3,000.00 
DISP 
$500.00 
$200.00 
$300.00 
ADD 
$300.00 
$600.00 
$100.00 
MVT 
$6,200.00 
$3,400.00 
$2,800.00 
Notice that the MVT value in each column reflects the following two guidelines:

The ReverseSign property of DISP is TRUE. Therefore, the sign of that value is reversed for computation.

In general, MVT = CLO  ( sum of all other flows)
The following examples show how to calculate MVT in the first column.
MVT = CLO – (OPE + ( DISP) + ADD)
MVT = CLO – OPE  ( DISP)  ADD
MVT = 6000  0.0  (500)  300 = 6200