{
  "cube_name": "Issues",
  "cube_reports": [ {
     "name": "Compare estimated Test time vs Test Run elapsed time, between Test Executions",
     "result_view": "table",
     "definition": {"columns":{"dimensions":[{"name":"Xray Test Execution","selected_set":["[Xray Test Execution].[All Xray Test Executions]"],"members":[{"depth":0,"name":"All Xray Test Executions","full_name":"[Xray Test Execution].[All Xray Test Executions]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Calculator","full_name":"[Xray Test Execution].[Calculator]","drillable":true,"key":"CALC","expanded":true,"drilled_into":false,"removed":true,"parent_full_name":"[Xray Test Execution].[All Xray Test Executions]"}],"bookmarked_members":[]},{"name":"Measures","selected_set":["[Measures].[Xray Test Original estimated hours]","[Measures].[Xray average Test Run duration]","[Measures].[Xray Total Test run duration]"],"members":[]}]},"rows":{"dimensions":[{"name":"Xray Test","selected_set":["[Xray Test].[Test].Members"],"members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Xray Test Plan","selected_set":["[Xray Test Plan].[All Xray Test Plans]"],"members":[{"depth":0,"name":"All Xray Test Plans","full_name":"[Xray Test Plan].[All Xray Test Plans]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Calculator","full_name":"[Xray Test Plan].[Calculator]","drillable":true,"key":"CALC","expanded":true,"drilled_into":false,"parent_full_name":"[Xray Test Plan].[All Xray Test Plans]"},{"depth":2,"name":"CALC-1906","full_name":"[Xray Test Plan].[Calculator].[CALC-1906]","key":"CALC-1906","parent_full_name":"[Xray Test Plan].[Calculator]"},{"depth":1,"name":"Shuttle Launch to Skylab Testing","full_name":"[Xray Test Plan].[Shuttle Launch to Skylab Testing]","drillable":true,"key":"SKY","expanded":true,"drilled_into":false,"parent_full_name":"[Xray Test Plan].[All Xray Test Plans]"}],"bookmarked_members":[],"current_page_members":["[Xray Test Plan].[Calculator].[CALC-1906]"]}]},"options":{"nonempty":true},"view":{"current":"table","maximized":false,"table":{"show_key":["Xray Test"]}}}
  } ],
  "calculated_members": [{"dimension":"Measures","name":"Xray average Test Run duration","format_string":"MinutesFormatter","formula":"[Measures].[Xray Test Run duration] / 60","annotations":{"group":"Xray","drill_through_dimension_levels":"[Xray Test].[Test], [Xray Test Execution].[Execution]"}},{"name":"Xray Test Original estimated hours","dimension":"Measures","formula":"  Sum(\n    -- set of test which are related report context and has at least one execution\n    Filter(\n      Descendants([Xray Test].CurrenthierarchyMember, [Xray Test].[Test]),\n      [Measures].[Xray Tests with executions] > 0\n    ),\n    -- for each test get Original estimate\n    DefaultContext((\n      [Issue].[Issue].GetmemberByKey([Xray Test].CurrentHierarchyMember.Key),\n      [Measures].[Original estimated hours]\n    ))\n  ) \n  --transform hours to minutes for formatting\n  * 60","format_string":"MinutesFormatter"},{"name":"Xray Total Test run duration","dimension":"Measures","formula":"  Sum(\n    -- set of test which are related to report context and has at least one execution\n    Filter(\n      Descendants([Xray Test].CurrenthierarchyMember, [Xray Test].[Test]),\n      [Measures].[Xray Tests with executions] > 0\n    ),\n    -- for each test calculate total execution time\n    [Measures].[Xray average Test Run duration] * [Measures].[Xray Test Runs]\n  )","format_string":"MinutesFormatter"}]
}