Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

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

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

See Also

Feedback