Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Aim: provide a quick overview of coverage per requirement: show requirements, their workflow status, amount of Tests covering each requirement, amount of Runs created and amount of defects cretead and their status. More info here.



Code Block
titleeazyBI report definition
collapsetrue
{
  "cube_name": "Issues",
  "cube_reports": [ {
     "name": "Xray Requirement coverage",
     "result_view": "table",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Xray Requirement status]","[Measures].[Xray Tests created]","[Measures].[Xray Tests with executions]","[Measures].[Xray Test Runs]","[Measures].[Xray Test Run Summary]","[Measures].[Xray Tests defect count]","[Measures].[Xray Defect list]"],"members":[]}]},"rows":{"dimensions":[{"name":"Xray Requirement","selected_set":["[Xray Requirement].[Requirement].Members"],"members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all","expanded":true,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]},{"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":"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].[All Xray Test Plans]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Xray Requirement":true}}}}
  } ],
  "calculated_members": [{"dimension":"Measures","name":"Xray Defect status","format_string":"","formula":"[Status].[Status].getMemberNameByKey(\n  [Xray Defect].CurrentHierarchyMember.get('Status ID')\n)","annotations":{"group":"Xray","drill_through_dimension_levels":"[Xray Test].[Test], [Xray Test Execution].[Execution]"}},{"dimension":"Measures","name":"Xray Tests Run count","format_string":"","formula":"Sum(\n  Filter(Descendants([Xray Test Execution].CurrentMember,\n    [Xray Test Execution].[Execution]),\n    [Measures].[Xray Tests with executions] > 0),\n  [Measures].[Xray Tests with executions]\n)","annotations":{"group":"Xray","drill_through_dimension_levels":"[Xray Test].[Test], [Xray Test Execution].[Execution]"}},{"name":"Xray Test Run Summary","dimension":"Measures","formula":"-- annotations.group=Xray User defined\n\nGenerate(\n  Filter(\n    Descendants([Xray Test Execution Status].CurrentMember,\n      [Xray Test Execution Status].[Status]\n    ),\n    [Measures].[Xray Tests Run count] > 0\n  ),\n  [Xray Test Execution Status].CurrentMember.Name || ' ' ||\n  Format([Measures].[Xray Tests Run count], '#'),\n  ', '\n)","format_string":""},{"name":"Xray Requirement status","dimension":"Measures","formula":"-- annotations.group=Xray User defined\n[Status].[Status].getMemberNameByKey(\n  [Xray Requirement].CurrentHierarchyMember.get('Status ID')\n)","format_string":""},{"name":"Xray Defect list","dimension":"Measures","formula":"-- annotations.group=Xray User defined\n\nGenerate(\n  Filter(\n    Descendants([Xray Defect].CurrentMember, [Xray Defect].[Defect]),\n    [Measures].[Xray Tests defect count] > 0),\n    [Xray Defect].CurrentMember.Name || ' ' || [Measures].[Xray Defect status]\n    \n    ,\n    \", \"\n)","format_string":""}]
}


Report Dashboards

eazyBI supports the creation of dashboards that you can use to combine several Xray-related reports in one display.

...