FAS ID at story level

Questions & Answers
1

Hi,

I should need your support for a Measure.
Suppose I have a report with ONLY STORY ISSUES ON THE ROWS.

I want a Measure that calculates the FAS ID of the Uber Initiative that is father of each story.

Hierarchy is
UBER INITIATIV
EPIC
INITIATIVE
STORY

and FAS ID is a field (‘‘ID’’) only present at Uber Initiative level and not at story Level.

How to obtain a column that adds this FAS ID in the rows beside each story issue row?

Thanks

Tullio

2

Hi, at the end I was able to create the measure:

[Issue].[Issue].GetMemberByKey(
[Issue].CurrentHierarchyMember.Get(‘Advanced Roadmaps Uber-Initiative’)
).get(‘ID’)

It works.

But I also need to create the same measure but for Uber Initiative Status:

I’m trying with:

[Issue].[Issue].GetMemberByKey(
[Issue].CurrentHierarchyMember.Get(‘Advanced Roadmaps Uber-Initiative’)
).get('Status ID)

BUT IT DOESN’T WODK

Do you have any suggestion please?

Tullio

3

Hi @tulliodisimone

To get the Status ID from a higher level member in the hierarchy, you can use the Ancestor function with a formula like this:

Ancestor(
  [Issue.Initiative hierarchy].CurrentMember,
  [Issue.Initiative hierarchy].[Uber Initiative]
).Get('Status ID')

Please replace the [Issue.Initiative hierarchy] with the correct name of your custom hierarchy.
This formula will, for each Epic/Initiative/Story return the Status ID of their parent Uber Initiative.

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris / eazyBI support