Hoping this is correct!
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “SP by launch date weekly open only”,
“result_view”: “timeline_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[SPbyLaunchDateSub-taskFirst]","[Measures].[106 SP reasonable maximum per week]"],“members”:[]},{“name”:“Hard Dated”,“selected_set”:["[Hard Dated].[All Hard Dateds]","[Hard Dated].[Yes]"],“members”:[],“bookmarked_members”:[{“depth”:1,“name”:“Yes”,“full_name”:"[Hard Dated].[Yes]"}]}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:["[Time.Weekly].[Week].Members"],“members”:[],“bookmarked_members”:[{“depth”:3,“name”:“Apr 2020”,“full_name”:"[Time].[2020].[Q2 2020].[Apr 2020]",“drillable”:true},{“depth”:3,“name”:“May 2020”,“full_name”:"[Time].[2020].[Q2 2020].[May 2020]",“drillable”:true},{“depth”:3,“name”:“Jun 2020”,“full_name”:"[Time].[2020].[Q2 2020].[Jun 2020]",“drillable”:true}]}],“filter_by”:{“conditions”:[{“expression”:"[Time.Weekly].CurrentHierarchyMember",“operator”:“between”,“value”:“one month ago and two months from now”,“value_type”:“date”}],“others”:false},“nonempty_crossjoin”:false},“pages”:{“dimensions”:[{“name”:“Status”,“selected_set”:["[Status].[OpenNoHoldTraNoIntake]"],“members”:[{“depth”:0,“name”:“OpenNoTranslationNoHoldNotSubmitted”,“full_name”:"[Status].[OpenNoHoldTraNoIntake]",“calculated”:true,“drillable”:true,“dimension”:“Status”}],“bookmarked_members”:[{“depth”:1,“name”:“Closed”,“full_name”:"[Status].[Closed]"},{“depth”:1,“name”:“Cancelled”,“full_name”:"[Status].[Cancelled]"}],“current_page_members”:["[Status].[OpenNoHoldTraNoIntake]"]}]},“options”:{“nonempty”:true},“view”:{“current”:“timeline_chart”,“maximized”:false,“timeline_chart”:{“series_type”:“spline”,“series_options”:{},“y_axis”:{“0”:{“title”:“Total story point velocity versus team capacity”}}},“table”:{}},“calculated_members”:[]}
} ],
“calculated_members”: [{“name”:“CapacityUsed”,“dimension”:“Measures”,“formula”:"[Measures].[Story Points with target launch date] / 7",“format_string”:"#0%"},{“name”:“OpenNoHoldTraNoIntake”,“dimension”:“Status”,“formula”:“Aggregate(\n Except(\n [Status].[Status].Members,\n { [Status].[Closed],\n [Status].[Cancelled],[Status].[Translation],\n [Status].[On Hold], [Status].[Submitted], [Status].[Intake]\n\n }\n )\n)”,“format_string”:""},{“name”:“106 SP reasonable maximum per week”,“dimension”:“Measures”,“formula”:“106”,“format_string”:""},{“name”:“SPbyLaunchDateSub-taskFirst”,“dimension”:“Measures”,“formula”:“CASE WHEN [Measures].[Sub-tasks created] \u003e 0\nTHEN\nNonZero(([Measures].[Story Points with target launch date],[Issue Type].[Sub-task]))\nELSE\nNonZero([Measures].[Story Points with target launch date])\nEND”,“format_string”:"#,##0.00"}]
}
