Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

PARENT

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. DeepSee 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
Copy code to clipboard

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

See Also

FeedbackOpens in a new window