Hello - not really getting much traction with the help documentation but found this query but, when running it myself, I get the following error:
( [Measures].[Transitions to],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future => Active],
[Time].CurrentHierarchy.Levels(‘Day’).DateMember(
[Sprint].CurrentMember.get(‘Start date’)
)
)
==> Formula is not valid:
“MDX object ‘[Sprint Status].[Active]’ not found in cube ‘Issues’”
Can someone please provide some guidance please.