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?
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.