Measure : Iterate over Stories sub-tasks

[cdemez]

Hi,

I created a new measure, and for each Story, I try to Sum some information from all the sub-tasks.

I’ve tried the following, but no way:

Sum(
DescendantsSet([Issue].CurrentHierarchyMember, [Issue].CurrentHierarchy.Levels(‘Sub-task’)),
([Measures].[Workdays in transition status], [Transition Status].[In Progress])
)

And here the error message.

#ERR: mondrian.olap.fun.MondrianEvaluationException: Level ‘Sub-task’ not found in hierarchy ‘[Issue]’

any idea ?

[martins.vanags]

@cdemez
Your calculation will work only for Issue.Sub-task hierarchy from the “Issue” dimension.
Try selecting the right hierarchy from the “Issue” dimension.

Martins / eazyBI