Hi,
Please help with add of calculated member field for my hours report, issue is “NONREV-87”.
Report:
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Logged hours by project and user”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time].[2023].[Q3 2023].[Sep 2023]”],“members”:,“bookmarked_members”:},{“name”:“Project”,“selected_set”:[“[Project].[Project Hours]”,“[Project].[Non - Revenue]”,“[Project].[All Projects]”],“members”:,“bookmarked_members”:}]},“rows”:{“dimensions”:[{“name”:“Logged by”,“selected_set”:[“[Logged by].[TEST USER]”,{“name”:“Measures”,“selected_set”:[“[Measures].[Hours spent]”],“members”:}]},“pages”:{“dimensions”:[{“name”:“Time”,“duplicate”:true,“selected_set”:[“[Time].[Previous month]”,“[Time].[Current month]”],“members”:[{“depth”:0,“name”:“Current month”,“full_name”:“[Time].[Current month]”,“annotations”:{“group”:“Default”,“predefined”:“true”},“calculated”:true,“drillable”:true,“dimension”:“Time”,“expanded”:true,“drilled_into”:false},{“depth”:3,“name”:“Sep 2023”,“full_name”:“[Time].[2023].[Q3 2023].[Sep 2023]”,“drillable”:true,“parent_full_name”:“[Time].[Current month]”}],“bookmarked_members”:,“current_page_members”:[“[Time].[2023].[Q3 2023].[Sep 2023]”]}]},“options”:{“nonempty”:true,“total”:“rows”},“view”:{“current”:“table”,“maximized”:true,“table”:{“row_dimension_headers”:{“Logged by”:true},“cell_formatting”:{}}},“calculated_members”:}
} ],
“calculated_members”: [{“dimension”:“Time”,“name”:“Current month”,“format_string”:“”,“formula”:“Aggregate({\n [Time].[Month].CurrentDateMember\n})”},{“dimension”:“Time”,“name”:“Previous month”,“format_string”:“”,“formula”:“Aggregate({\n [Time].[Month].CurrentDateMember.PrevMember\n})”},{“name”:“Project Hours”,“dimension”:“Project”,“formula”:“[Project].[All Projects] - [Project].[Non Revenue Tasks]”,“format_string”:“”},{“name”:“Non - Revenue”,“dimension”:“Project”,“formula”:“[Project].[Non Revenue Tasks]”,“format_string”:“”}]
}
If I drill to Non Reveue Task log, I can see necessary task:
Somehow, not sure how to get NONREV-87 hours only.
