Projection Configuration Cube

Return to Projected Balance Sheet Model Overview

This cube contains the relevant configuration to run projections, it contains the mapping of the Profit and Loss (PnL) statements to the Balance Sheet (BS) statements. It consists of the following dimensions:

• Batch Procedure Configuration: See Article Batch Procedure Configuration Dimension
• PnL Account: See Article PnL Account Dimension
• Elements in the Projection Configuration_measure dimension are:

  Element	Definition
  BS Account	Balance sheet account to map the inncome or expenses to. Valid elements are base elements of the BS Account dimension. Used for instant mapping of income or expenses without tax and instant mapping of income or expenses with tax.
  Tax Account	Balance sheet account used to map the tax to. Valid elements are base elements of the BS Account dimension. Used for instant mapping of income or expenses with tax.
  Tax	Tax percentage applied on top of the income or expense. Valid values from 0 to 100. Used for instant mapping of income or expenses with tax.
  Term 1 - Term 4	Time period of projection allocation. Valid values are integers (e.g. ... -2, -1, 0, 1, 2 ...) representing months of prepayment (negative values), immediate (zero) or delayed payment.Used for deferred proceeds and payments.
  Share 1 - Share 4	Share of allocation for each term.Valid values from 0 to 100. Used for deferred proceeds and payments.
  Term Tax	Time period of tax allocation. Valid values are integers (e.g. ... -2, -1, 0, 1, 2 ...) representing months of prepayment (negative values), immediate (zero) or delayed payment. Used for instant mapping of income or expenses with tax and deferred proceeds and payments from tax assets and tax liabilities.
  Cash	Indicates the balance sheet account that the payment is credited from or debited to. Used for deferred proceeds and payments and deferred proceeds and payments from tax assets and tax liabilities.

Updated January 13, 2023