CHILD

Returns the name of the child element based on the specified dimension, hierarchy, element and position of the child.

CHILD(dimension, hierarchy, element, child_index)

Parameters

• dimension - The name of the dimension.
• hierarchy - The name of the hierarchy.
• element - The name of the parent element.
• child_index - Index of the child. Must be numeric.

Examples

CHILD("Time", "MONTH", "2023", 2)

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