Using Parent-Child Relationships Using Parent-Child Relationships The system provides the following MDX functions that directly use parent-child relationships: CHILDREN returns the children, if any, of a given member. The returned value is a set of members, in the default order specified for the level. For example: SELECT MEASURES.[%COUNT] ON 0, homed.zip.[34577].CHILDREN ON 1 FROM demomdx %COUNT 1 Cypress 112 2 Magnolia 114 3 Pine 121 For another example: SELECT MEASURES.[%COUNT] ON 0, homed.pine.CHILDREN ON 1 FROM demomdx %COUNT No Result PARENT returns the parent, if any, of a given member. For example: SELECT MEASURES.[%COUNT] ON 0, homed.city.[Elm Heights].PARENT ON 1 FROM demomdx %COUNT 38928 228 FIRSTCHILD returns the first child, if any, of a given member. For example: SELECT MEASURES.[%COUNT] ON 0, homed.zip.[34577].FIRSTCHILD ON 1 FROM demomdx %COUNT Cypress 112 LASTCHILD returns the last child, if any.