hierarchy.offset

This function returns an element from hierarchy based on the offset provided.

hierarchy.offset(dimension, hierarchy, element, shift)

Parameters

• dimension - The dimension in which to create a relationship.
• hierarchy - The identifier of the hierarchy in which to create a relationship.
• element - The identifier of an element which may/maynot exist.
• shift - The offset value.

Example

let element = hierarchy.offset("Account", "Profit and Loss", "EBITDA", 2);

TIP

Please note that this function always returns a string value.