Getting Cumulative Story Points Resolved

[Cory Foy]

I'm trying to write a report in EazyBI to get the cumulative story points resolved across sprints. So if I had the following sprints:

S1: 13 points
S2: 19 points
S3: 17 points

What I want is for the calculation to return:

S1: 13 points
S2: 32 points
S3: 49 points

Given this is an actual example from the documentation, I was surprised that it didn't work. My Calculated member looks like:

Sum(
  { PreviousPeriods([Time].CurrentHierarchyMember),
   [Time].CurrentHierarchyMember },
  [Measures].[Story Points resolved]
)

I have that set as the selected measure in rows, and the columns being sprints (I tried it the other way, too). What I see is each sprint listed with the total points resolved that sprint, but not cumulatively (so 13,19,17 instead of 13,32,49) . What am I missing here?

[Cory Foy · Accepted solution]

Well, if I want Cumulative Sprints, then I should actually do that!

Sum(
  { PreviousPeriods([Sprint].CurrentHierarchyMember),
   [Sprint].CurrentHierarchyMember },
  [Measures].[Story Points resolved]
)

Note the change from Time.CurrentHierarchyMember to Sprint. That solved the issue for me.

[Mārtiņš Vanags]

Hi Cory,

It seems you already found an answer, but anyway you could also try defining a new user-defined calculated member in "Measures" dimension using this code example:

Sum(
  Head(
    ChildrenSet([Sprint].[Sprints]),
    Rank([Sprint].CurrentMember,
      ChildrenSet([Sprint].[Sprints])
    )
  ),
  [Measures].[Story Points resolved]
)

Please contact support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags / support@eazybi.com

[Sridhar Gandla]

where to write this code?