Recreate Xray Test Plan Report

Need some help recreating the Xray Test Plan :slight_smile:

Hi @knayak,

Xray Test Plan report contains a different type of information; I would recommend to split it into several reports and places them in one dashboard to get a Test Plan overview. For example, you may split reports by sections as they are showed in the sample, like, general information, tests by status, tests by type, success rate by environment and linked defects.

Most of the building blocks are already available in eazyBI. Please check the documentation about data from Xray where are explained available measures, dimension and properties.

Xray custom fields, like, Test Plan begin, and end dates are not imported into eazyBI by default. To make them available in eazyBI, go to eazyBI Jira import options and select the Begin date and End Date as properties for data import. After data import, both dates will be imported as issue properties. Then for each date define a new calculated measure to represent issue property as test plan property. For more details on how to do it see documentation on data from Xray.

For success rate report, first, you should select field Test Environment for data import in import options. Then define a new calculated measure to calculate the success rate for each environment as this value is calculated in particular Xray report and therefore is not available in eazyBI by default.

Zane /

Thanks this helps :slight_smile:

Since eazyBI version 5.3, there is an option to drill into measure by another dimension that gives more freedom to combine different types of information in one report. For example, using this functionality, you may combine execution results by result statuses and executed test count by test type in one report:

More details on how to use this functionality are described here:

Zane /

Thanks for the response Zane, is this available on any of the demo account to look at?

I just tried building this and it doesnt nearly as good as the one in the one you shared.

Unfortunately, testing reports are not available in the Demo account.

My recommendation, when building reports like this start with Measures only on columns. And then use the option to drill into measure by another dimension.

When the report layout is completed, then add the cell formatting to differentiate columns and improve the readability:

Here is also report definitions:

  "cube_name": "Issues",
  "cube_reports": [ {
     "name": "Test Plan Overview",
     "result_view": "table",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Xray Test Plan Begin Date]","[Measures].[Xray Test Plan End Date]","[Measures].[Xray Tests created]","[Measures].[Xray Test Runs]","[Measures].[Xray Tests with executions]"],"members":[{"depth":0,"name":"Xray Test Runs","full_name":"[Measures].[Xray Test Runs]","format_string":"#,##0","annotations":{"group":"Xray","drill_through_dimension_levels":"[Xray Test].[Test], [Xray Test Execution].[Execution]","drill_through_by":"xray_test_execution","predefined":"true"},"drilled_into_dimension":"Xray Test Execution Status"},{"depth":0,"name":"Xray Tests with executions","full_name":"[Measures].[Xray Tests with executions]","format_string":"#,##0","annotations":{"group":"Xray","drill_through_dimension_levels":"[Xray Test].[Test], [Xray Test Execution].[Execution]","drill_through_by":"xray_test_execution","predefined":"true"},"drilled_into_dimension":"Xray Test Type"}]},{"name":"Xray Test Execution Status","selected_set":["[Xray Test Execution Status].[Status].Members"],"members":[],"bookmarked_members":[]},{"name":"Xray Test Type","selected_set":["[Xray Test Type].[Type].Members"],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Xray Test Plan","selected_set":["[Xray Test Plan].[All Xray Test Plans]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Xray Test Plan].[Plan])","members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Xray Test Plan","duplicate":true,"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":false,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Xray Test Plan].[All Xray Test Plans]"]}]},"options":{"nonempty":"columns"},"view":{"current":"table","maximized":false,"table":{"show_key":["Xray Test Plan"],"row_dimension_headers":{"Xray Test Plan":true},"cell_formatting":{"[Measures].[Xray Tests created]":[{"bold":true}],"[Xray Test Execution Status].[PASS]":[{"background_color":"#CFF9DD"}],"[Xray Test Execution Status].[TODO]":[{"background_color":"#EBECF0"}],"[Xray Test Execution Status].[EXECUTING]":[{"background_color":"#FFF9D9"}],"[Xray Test Execution Status].[FAIL]":[{"background_color":"#FFE4EE"}],"[Xray Test Execution Status].[ABORTED]":[{"background_color":"#B3BAC5"}]}}},"calculated_members":[]}
  } ],
  "calculated_members": [{"dimension":"Measures","annotations":{"group":"Xray","predefined":true},"format_string":"mmm dd yyyy","name":"Xray Test Plan Begin Date","formula":"[Xray Test Plan].CurrentHierarchyMember.get('Begin Date')"},{"dimension":"Measures","annotations":{"group":"Xray","predefined":true},"format_string":"mmm dd yyyy","name":"Xray Test Plan End Date","formula":"[Xray Test Plan].CurrentHierarchyMember.get('End Date')"}]
1 Like

thanks zane… this helps as a good starting point :slight_smile: