Subtable Dimension Properties

Subtable dimensions break down account activity or flow. For example, some accounts, like Fixed Assets, have a subtable dimension containing Opening, Additions, Deletions, Transfers, and Ending Balances.

The subtable type dimension is important for writing business rules that require currency translation amounts to be calculated by account. Since the subtable information can be used for multiple accounts, it requires its own dimension.

A subtable dimension has the following required properties:

Property Name

Description

FLOW_TYPE

Defines the type of flow of the dimension, as follows:

  • OPENING - Opening

  • TRANSLOPE - Change difference on opening

  • ALLOCINC - Allocation

  • MERGER - Merger

  • INCOME - Net income from the period

  • CHANGE - Variation

  • TRANSFER - Transfer

  • TRANSFLOW - Translation change on flow

  • VARSCP - Variation in scope (generic)

  • VARSCPMETH - Variation in scope method

  • VARSCPPERC - Variation in scope percentage

  • VARSCPNEW - Variation in scope new company

  • VARSCPLEAV - Variation in scope sold company

  • CLOSING - Closing

  • NONE - No flow

  • Blank - All other flows

SCALING

Scaling options are Y or N. Used by EPMScaleData and Library view. The value is optional, but if a value is not defined, scaling is unavailable for the associated member ID.

More Information