Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

For FIN OCoA the following attribute values are calculated by process }APQ.C3.Dim.CoAMap.OperativeDimension.SetFlags.

TB_Mult

Only leaf level accounts in the CoA template dimension will receive a value of either 1 or -1. Value of 1 is assigned if the leaf account descends from C3_TOTASSETS or from C3_STATISTICS. Otherwise value of -1 is assigned to the account. Consolidated accounts will receive empty string.
Note: Leaf level accounts are all accounts that have ElType/String value set to N.

BS_Indicator

An account in the CoA template dimension can receive value of TRUE or empty string. TRUE is assigned if the account descends from C3_MGMTTB and doesn't descend C3_NPAT or is not C3_NPAT itself at the same time. Empty string value is assigned otherwise.

Statistical Account Flag

An account in the CoA template dimension can receive value of TRUE or empty string. TRUE is assigned if the account descends from C3_STATISTICS, empty string value otherwise.

Mapping Level

  • If the element is descending from Reporting Rollups or the element is C3_MGMTTB then it is assigned its value of Mapping Level Override

    • If the element is C3_MGMTTB and its current value of Mapping Level Override is empty, then it is assigned 0 (this is default 1:1 mapping between operative and plan template dimensions if user did not enter any mapping).

  • If the element is descending from C3_MGMTTB and

    • its value of Mapping Level Override is not empty, then it is assigned the value of Mapping Level Override.

    • Its value of Mapping Level Override is empty: lookup first value of Mapping Level of any parent of the element that is descending from C3_MGMTTB or is C3_MGMTTB itself.

  • Otherwise:

    • If Mapping Level Override value is not empty, then it is assigned the value of Mapping Level Override.

    • Otherwise: Lookup first non-empty Mapping Level of any of the element's parents.

Plan Map ID

  • If the element is C3_DEFAULTMEMBER (FIN OCoA Rollups) then it is assigned C3_DEFAULTMEMBER of the plan dimension (FIN PCoA Rollups).

  • If the element is C3_REPORTINGROLLUPS (Reporting Rollups) then it is assigned C3_REPORTINGROLLUPS (Reporting Rollups).

  • If the element is NA FIN OCOA element, then it is assigned empty value (no mapping - the element will not be created in the plan dimension).

  • Otherwise:

    • If element level of the element (calculated as TM1 function) – 1 >= its calculated Mapping Level, then use the element name itself.

      • In cases when the element is consolidated and its level would become negative, use 1 as its level value.

    • Otherwise: use value of Plan Map ID of the parent of the element.

  • No labels