docs.intersystems.com
Home  /  Application Development: Analytics Options  /  InterSystems MDX Reference  /  MDX Functions  /  PARENT


InterSystems MDX Reference
PARENT
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


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