I would like to have a report where I can see all hours spent by users in some time interval. I am a beginner at this. I succeeded to get the right info on the issue level (created calc member for original estimate without time dimension) but not on a project or other levels. I use dimension Logged by, Issue, Time - in pages and have created two calculated members.
I need help
Original estimate - no time dimension
IIf ([Issue].CurrentHierarchy.CurrentMember.Level.Name="Project", 0, ([Measures].[Original estimated hours], [Time].CurrentHierarchy.DefaultMember ) )
test calculated member
CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = 'Issue' THEN CASE WHEN [Measures].[Hours spent] <= 0 THEN 0 END ELSE --(Filter( --[Logged by].CurrentMember,[Logged by].[User], --[Logged by].CurrentMember.Members > 0), Sum( Filter( -- iterate through Issue dimension "Issue" level Descendants([Issue].CurrentMember,[Issue].[Issue]), -- return a set of issues matching condition [Measures].[Original estimate - no time] > 0 ), -- evaluate the set of issues over the measure below [Measures].[Original estimate - no time] ) --) END