CHILDPOSITION

Returns the position of the child element within a specific parent element within a specified dimension hierarchy.

CHILDPOSITION(dimension, hierarchy, parent, child)

Parameters

• dimension - The name of the dimension.
• hierarchy - The name of the hierarchy.
• parent - The name of the parent element.
• child - The name of the child element.

Examples

CHILDPOSITION("Time", "Default", "2018")

Note: Assuming a calendar year time dimension returns the position of the child element of 2018 - January.