Filter all the Issues and its Tests Based on the Sprint

Hello

I am trying to create the filter with the following columns.

Sprint Number - All issues in the sprint - Tests - Test Status - Defect Created - Defect Status

When i use the below definition its giving 0 rows.
Please advice.

{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Lohit”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Issues created]"],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“Sprint”,“selected_set”:["[Sprint].[ISTDaWo].[ISTDaWo Sprint 0]"],“selected_set_expression”:“DescendantsSet({{selected_set}}, [Sprint].[Sprint])”,“members”:[],“bookmarked_members”:[]},{“name”:“Issue”,“selected_set”:["[Issue].[Issue].Members"],“members”:[],“bookmarked_members”:[]},{“name”:“Xray Requirement”,“selected_set”:["[Xray Requirement].[Project].Members"],“members”:[],“bookmarked_members”:[]}],“nonempty_crossjoin”:true},“pages”:{“dimensions”:[{“name”:“Sprint”,“duplicate”:true,“selected_set”:["[Sprint].[All Sprints]"],“members”:[{“depth”:0,“name”:“All Sprints”,“full_name”:"[Sprint].[All Sprints]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“ISTDaWo”,“full_name”:"[Sprint].[ISTDaWo]",“drillable”:true,“expanded”:true,“drilled_into”:false,“parent_full_name”:"[Sprint].[All Sprints]"},{“depth”:2,“name”:“ISTDaWo Sprint 0”,“full_name”:"[Sprint].[ISTDaWo].[ISTDaWo Sprint 0]",“url_id”:82037,“url_sub_id”:21854,“parent_full_name”:"[Sprint].[ISTDaWo]"}],“bookmarked_members”:[],“current_page_members”:["[Sprint].[ISTDaWo].[ISTDaWo Sprint 0]"]},{“name”:“Issue Type”,“selected_set”:["[Issue Type].[All Issue Types]"],“members”:[{“depth”:0,“name”:“All Issue Types”,“full_name”:"[Issue Type].[All Issue Types]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“Story”,“full_name”:"[Issue Type].[Story]",“parent_full_name”:"[Issue Type].[All Issue Types]"}],“bookmarked_members”:[],“current_page_members”:["[Issue Type].[Story]"]}]},“options”:{},“view”:{“current”:“table”,“maximized”:false,“table”:{“row_dimension_headers”:{“Issue”:true}}},“calculated_members”:[]}
} ],
“calculated_members”: []
}

Hi @adithya ,

We still have an ongoing conversation in the support channel regarding further details. I will share the basic information to see Xray Requirements that are added to Sprint as we discussed in the support conversation.

Xray Requirements, Tests, Executions, and Defects are not directly tied to the Sprint dimension. But, you can overcome this by defining several calculated measures. The first and the most important one is retrieving the Xray Requirement members in the currently selected Sprint. One way is to look for Requirements through the Issue dimension that are committed to the Sprint. See the formula for the calculated measure below:

([Issue].[Issue].GetMemberByKey(
  [Xray Requirement].CurrentMember.Key
),[Measures].[Sprint issues committed],
[Xray Requirement].CurrentHierarchy.DefaultMember)

The GetMemberByKey() function retrieves the respective Issue dimension “Issue” level member from the current Xray Requimrent member key and sees if it is committed to the Sprint dimension member currently in pages. See the picture below:


To see only the relevant requirements, filter the report rows by this measure.

See the eazyBI documentation page for more details on the GetMembersByKey() function and filtering report rows.

Best,
Roberts // support@eazybi.com