I am trying to create a report where the pages allow the selection of the [Logged By].[User] and the [Time Weekly].[Week] . The Report has [Issue].[Issue] for rows and uses [Measure].[Hours Spent]. This is working and reporting the hours logged for that user for the week selected. I am trying to add 2 additional custom measures.
Total Hours for Issue:
CASE WHEN [Issue].CurrentMember.Level.Name = “Issue”
THEN val(([Time].DefaultMember,[Measures].[Hours spent]))
– if the current Issue dimension level is not Issue, then sum the values
[Measures].[Hours spent] > 0
[Measures].[Issues closed] > 0),
([Time].DefaultMember, [Measures].[Hours spent])
This is giving the same result as Hours Spent (Sum of time for the week requested) I am trying to get all time spent on the issue. I thought the [Time].DefaultMember, [Measures].[Hours spent] would give me all time., but it is not.
The second measure I want is all the time spent on the issue for the selected logger. I have not attempted that yet as I am wrapped around the axle on the total time.