Cash Flow Mapping Cube
Return to Cash Flow Model Overview.
The Cash Flow Mapping
cube stores the mapping from the Profit and Loss
and Balance Sheet
cubes to the Cash Flow Cube. It is maintained through the Cash Flow Mapping report. This cube consists of the following dimensions:
PnL and BS Account
: Combination of all elements of thePnL Account
andBS Account
dimensions. The profit and loss accounts are prefixed withPnL.
, while the balance sheet accounts are prefixed withBS.
. This dimension is maintained by theUpdate Dimension PnL and BS Account
procedure, which can be invoked from the Cash Flow Mapping report.Cash Flow Mapping No
: Flat list of ordinals 1, 2, 3, etc. By default, up to ten source accounts can be mapped on aCF Account
destination. This dimension can be extended if additional mappings are required.Cash Flow Mapping_measure
contains the following elements:Element
Definition
Mapping Type
Defines how signs of values from the source cubes
Profit and Loss
andBalance Sheet
should be handled. Valid values are1
,-1
,Auto
, and-Auto
. See theSign
measure for more details. (string)Transaction Type
Only valid if the
PnL and BS Account
element is balance sheet account. Must be an element of the Transaction Type Dimension. (string)CF Account
Destination account for the
CF Account
dimension. (string)Sign
Effective sign of the mapping from the source account to the destination account as specified by
Mapping Type
. This measure is the result of theUpdate Cash Flow Calculation
procedure. Valid values are1
or-1
. IfMapping Type
was set to1
or-1
, thenSign
is set to1
or-1
. IfMapping Type
was set toAuto
or-Auto
, thenSign
is calculated by the following criteria:- If
Type
of the account isAssets
orExpenses
, reverse the sign. - If the sign standard for the source account type is
–
, reverse the sign. - If the
Type
of the destinationCF Account
isPayments
, reverse the sign. - If the
Mapping Type
is set to-Auto
, reverse the sign.
Please note that an even number of reversals would result in a value of
1
and an uneven number would result in-1
. (string)Message
Comprehensive error message if the
Update Cash Flow Calculation
procedure cannot calculateSign
. Otherwise empty. (string)- If
Updated November 5, 2024