Page Comparison

...

• For each account in template FIN OCoA:

  • 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

Plan Map ID attribute is a calculated element name for each of the operative dimension element and determines if the element will be included in the plan dimension by checking Mapping Level attribute value with element level. Logic described in Mapping Level applies when establishing the Plan Map ID.

• For each account in template FIN OCoA:

  • 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 matching the condition element level >= its calculated Mapping Level.

Mapping Level and Plan Map ID attribute values are used when updating structure of template FIN PCoA dimension.