Skip to main content
InterSystems IRIS Data Platform 2024.3
AskMe (beta)
Loading icon

PARENT (MDX)

Returns the member that is the parent of the given member.

Returned Type

This function returns a member.

Syntax and Details

member_expression.PARENT 

Where:

The function returns the parent of this member.

Apart from measures, every member belongs to a level, and every level belongs to a hierarchy, which defines the parent-child relationships among the members. The system creates an All level (with a single All member), at the highest part of each hierarchy (unless the cube disables the All level for the dimension).

Example

For example:

SELECT MEASURES.[%COUNT] ON 0, homed.city.[Elm Heights].PARENT ON 1 FROM patients
 
                             Patient Count
38928                                2,276

To see a picture of the hierarchy used in this example, see the FIRSTCHILD function.

See Also

FeedbackOpens in a new tab