Page History
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
{
"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"}]
}
|
Requirement coverage
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 | ||||
|---|---|---|---|---|
| ||||
{
"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.
...
You can also use eazyBI’s reports and dashboards in Jira dashboards by using proper gadgets.
Learn more
For specific questions concerning eazyBi, please use eazyBI support channel.
...