Rows sorted on Sub-task and displaying Parent Summary assoicated

I am struggling with this and I have a feeling it is so simple…

I am creating a report to show only the sub-task under a Parent Issues.

I need to see only the details of the sub-task with exception of the Parent Summary. I am currently sorting by sub-task under issue in Rows… At the end of my table I need to see the Parent (Story associated with sub-task) name.

Any ideas?

Hi,

The following formula allows to access the summary of the Parent issue for the sub-task:

[Issue].[Issue].GetMemberByKey(
  [Issue].CurrentHierarchyMember.Parent.key).Name

Kindly,
Janis, eazyBI support

Hi Janis,

Is there any work around to display “Initiative” issue type key for Sub tasks ?

Ganesh,

Yes, this key should be available.
You can check the list of all issue properties for the subtask in the default hierarchy of Issue dimension with the following formula:

[Issue].CurrentHierarchyMember.AllProperties

You should see in the property list the key of the parent issues:

Kindly,
Janis, eazyBI support

1 Like

Thanks for your assistance on this.

Hi Janis,

I tried this for getting the parent Summary, i.e name for the Subtasks by creating a measure, but it is returning #null. Any idea why it is returning null?

Thanks in advance!

Hi,

The formula provided expects that the Sub-task hierarchy is used in the report.
The parent of the issue in the default issue hierarchy is the project-level member and will not return the summary.

Kindly,
Janis, eazyBI support