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.
See also
- Function Get() to return the properties of a member.
- Function CurrentHierarchyMember returns the current member from the hierarchy that is currently used.