Parent

Returns the parent member of the member in the current hierarchy.

Syntax

Member_Expression.Parent

Arguments

Member_Expression	MDX expression that returns a member.

Examples

Return the parent member name of an issue

The following example will return the name of the parent member for an issue within the current hierarchy. When used in the default hierarchy (Project>Issue), it will return Project names for individual issues in Rows. When used with another hierarchy, for example, Epic (Project>Epic>Parent>Sub-task), then, for Parent level issues, will return the name of the Epic that this issue belongs to.

[Issue].CurrentHierarchyMember.Parent.Name

Return the fraction of hours spent within the Project for each Epic

For this example, you'll need to select the Issues dimension in Rows and select the Epic level from the Epic hierarchy. The formula will take the hours spent for each Epic and divide it by the total hours spent on the project to which the Epic belongs (since the Parent member of Epic is the Project member).

[Measures].[Hours spent]
/
(
  [Measures].[Hours spent],
  [Issue].CurrentHierarchyMember.Parent
)

Return the due date of a parent issue

In this example, if you have Parent level (Epic hierarchy) issues selected in the Rows, however you wish to display the Due Date of the parent Epic of the issue, you can use a formula like this to return the date property of the parent member.

[Issue].CurrentHierarchyMember.Parent.GetDate('Due date')

Be sure to set the Formatting to Date for this measure.