About flow calculations in Chart Logic rules in Planning Business Modeler

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

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×