Hello
I’ve created a report on work log hours for the days of the previous week. I would like to see each day for the previous week based. However the report does not update the previous week’s day, from week-to-week. e.g. on 14/05/19 I should see the days 06/05/18-10/05/18
{
“cube_name”: “Love Agency”,
“cube_reports”: [ {
“name”: “Timesheets (previous week)”,
“folder_name”: “Projects Report”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Hours spent]"],“members”:null},{“name”:“Time”,“selected_set”:["[Time.Weekly].[Previous Week ]"],“selected_set_expression”:“DescendantsSet({{selected_set}}, [Time.Weekly].[Week])”,“members”:[{“depth”:2,“name”:“W17, Apr 22 2019”,“full_name”:"[Time.Weekly].[2019].[W17, Apr 22 2019]",“drillable”:true,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:null}]},“rows”:{“dimensions”:[{“name”:“Logged by”,“selected_set”:["[Logged by].[User].Members"],“members”:null,“bookmarked_members”:null}],“nonempty_crossjoin”:true},“pages”:{“dimensions”:[{“name”:“Time”,“duplicate”:true,“selected_set”:["[Time.Weekly].[Previous Week ]"],“members”:[{“depth”:0,“name”:“Previous Week “,“full_name”:”[Time.Weekly].[Previous Week ]”,“dimension_hierarchy”:“Weekly”,“calculated”:true,“drillable”:true,“expanded”:true,“drilled_into”:false,“removed”:false},{“depth”:2,“name”:“W16, Apr 15 2019”,“full_name”:"[Time.Weekly].[2019].[W16, Apr 15 2019]",“drillable”:true,“expanded”:true,“drilled_into”:false,“removed”:true,“parent_full_name”:"[Time.Weekly].[Previous Week ]"}],“bookmarked_members”:null,“current_page_members”:["[Time.Weekly].[Previous Week ]"]}]},“options”:{“nonempty”:true,“total”:true},“view”:{“current”:“table”,“maximized”:false,“table”:{“row_dimension_headers”:{“Logged by”:true},“cell_formatting”:{"[Measures].[Hours spent]":[{“min”:“0”,“text_color”:"#000000"},{“background_color”:"#FEB50A"}]}}}}
} ],
“calculated_members”: [{“name”:“Previous Week “,“dimension”:“Time”,“formula”:“Aggregate({[Time.Weekly].[Week].CurrentDateMember.PrevMember})”,“format_string”:”#,##0.00”,“dimension_hierarchy”:“Weekly”}]
}
