CHILD

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

js

CHILD(dimension, hierarchy, element, child_index)

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

js

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

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

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