hierarchy.structure

Adds a hierarchy member as a child of another hierarchy member. Note this function is used when linking two hierarchy members which are both parents of their respective children.

hierarchy.structure(dimension, hierarchy, parent, child, sign)

Parameters

• dimension - The dimension in which to create a relationship.
• hierarchy - The identifier of the hierarchy in which to create a relationship.
• parent - The identifier of a member which may/maynot exist.
• child - The identifier of a member which may/may not exist.
• sign - (Optional) Determines whether the child's values will be added or subtracted from the parents values. Accepts -1 or 1 as an integer.

Example

hierarchy.structure("Account", "Profit and Loss", "EBITDA", "Total Revenue");