Below the definition of the report.
As attached in the below screen shot in OQS in overdue issues, issues with status completed are also coming up, whereas in others there are not. I do not want to show completed issues in OQS as well as others.
Report Definition is below
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “LDC Build KPI Overview - (TEST 3) Eazybi Demo”,
“folder_name”: “LDC - Deployment - All Releases”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Work Item type”,“selected_set”:[“[Work Item type].[Design]”,“[Work Item type].[Development]”,“[Work Item type].[OQS]”,“[Work Item type].[Config]”,“[Work Item type].[CSD]”,“[Work Item type].[Total]”],“members”:,“bookmarked_members”:[{“depth”:1,“name”:“Design”,“full_name”:“[Work Item type].[Design]”},{“depth”:1,“name”:“Development”,“full_name”:“[Work Item type].[Development]”},{“depth”:1,“name”:“OQS”,“full_name”:“[Work Item type].[OQS]”},{“depth”:1,“name”:“Config”,“full_name”:“[Work Item type].[Config]”},{“depth”:1,“name”:“CSD”,“full_name”:“[Work Item type].[CSD]”}]},{“name”:“Measures”,“selected_set”:[“[Measures].[Actual(In Review+Completed) (Test)]”,“[Measures].[Total Planned]”,“[Measures].[Planned Until Today]”,“[Measures].[Overdue Issues]”],“members”:[{“depth”:0,“full_name”:“[Measures].[Actual(In Review+Completed) (Test)]”,“format_string”:“#,##0”,“report_specific”:true,“name”:“Actual(In Review+Completed) (Test)”,“calculated”:true},{“depth”:0,“full_name”:“[Measures].[Planned Until Today]”,“format_string”:“#,##0”,“report_specific”:true,“name”:“Planned Until Today”,“calculated”:true},{“depth”:0,“full_name”:“[Measures].[Overdue Issues]”,“format_string”:“#,##0”,“report_specific”:true,“name”:“Overdue Issues”,“calculated”:true}]}]},“rows”:{“dimensions”:[{“name”:“Functional Domain”,“selected_set”:[“[Functional Domain].[Commercial ]”,“[Functional Domain].[Finance \u0026 Procurement]”,“[Functional Domain].[Operations ]”],“members”:,“bookmarked_members”:}],“nonempty_crossjoin”:false},“pages”:{“dimensions”:[{“name”:“Status”,“selected_set”:[“[Status].[Not Cancelled]”],“members”:[{“depth”:0,“name”:“Not Cancelled”,“full_name”:“[Status].[Not Cancelled]”,“calculated”:true,“drillable”:true,“dimension”:“Status”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:,“current_page_members”:[“[Status].[Not Cancelled]”]},{“name”:“Issue Subtype”,“selected_set”:[“[Issue Subtype].[Except Data Migration]”],“members”:[{“depth”:0,“name”:“Except Data Migration”,“full_name”:“[Issue Subtype].[Except Data Migration]”,“calculated”:true,“drillable”:true,“dimension”:“Issue Subtype”}],“bookmarked_members”:,“current_page_members”:[“[Issue Subtype].[Except Data Migration]”]},{“name”:“Workstream”,“selected_set”:[“[Workstream].[All Workstreams]”],“members”:[{“depth”:0,“name”:“All Workstreams”,“full_name”:“[Workstream].[All Workstreams]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:,“current_page_members”:[“[Workstream].[All Workstreams]”]},{“name”:“Complexity”,“selected_set”:[“[Complexity].[All Complexities]”],“members”:[{“depth”:0,“name”:“All Complexities”,“full_name”:“[Complexity].[All Complexities]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:,“current_page_members”:[“[Complexity].[All Complexities]”]},{“name”:“Release_Version”,“selected_set”:[“[Release_Version].[All Release_Versions]”],“members”:[{“depth”:0,“name”:“All Release_Versions”,“full_name”:“[Release_Version].[All Release_Versions]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:,“current_page_members”:[“[Release_Version].[All Release_Versions]”]}]},“options”:{“nonempty”:true,“total”:“rows”},“view”:{“current”:“table”,“maximized”:false,“table”:{}},“calculated_members”:[{“dimension”:“Measures”,“name”:“Resolved in time %”,“formula”:“CASE WHEN [Measures].[Issues resolved] \u003e 0\nTHEN\n [Measures].[Issues resolved in time] / \n [Measures].[Issues resolved]\nEND”,“format_string”:“#0.00%”},{“dimension”:“Measures”,“name”:“Issues resolved in time”,“formula”:“-- issue is resovled in time, if it does not have due date\n– isuse resolution date is before or within due date\n\nCASE WHEN\nDateAfterPeriodEnd("Today", [Time].CurrentHierarchyMember)\nOR\nDateInPeriod("Today", [Time].CurrentHierarchyMember)\nTHEN\nNonZero(SUM(\nFilter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n – filters all issues with resolution date in period\n DateInPeriod(\n [Issue].CurrentMember.get(‘Resolved at’),\n [Time].CurrentHierarchyMember) \n AND\n – if issue does not have due date it is resolved in time\n (IsEmpty([Issue].CurrentMember.get(‘Due date’))\n or\n – filter to see if due date is before resolution date \n DateCompare(\n [Issue].CurrentMember.get(‘Due date’),\n DateWithouttime([Issue].CurrentMember.get(‘Resolved at’))\n ) \u003e -1\n )),\n – count issues that match criteria\n – measure will work as afilter to count only relevant issues for report selection\n ( [Measures].[Issues resolved],\n [Time].CurrentHierarchy.DefaultMember )\n))\nEND”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Overdue resolved issues”,“formula”:“CASE WHEN\nDateAfterPeriodEnd(‘today’,\n[Time].CurrentHierarchyMember.PrevMember\n)\nTHEN\nNonZero(Sum(\nFilter(\n DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),\n \n --resolved starting from period \n DateBeforePeriodEnd(\n [Issue].CurrentMember.get(‘Resolved at’),\n [Time].CurrentHierarchyMember) \n \n --if resolved after due date \n AND\n DateCompare(\n [Measures].[Issue due date],\n [Measures].[Issue resolution date]\n )\u003c0\n --if not closed before the end of period\n AND\n NOT DateBeforePeriodEnd(\n [Issue].CurrentMember.get(‘Closed at’),\n [Time].CurrentHierarchyMember)\n),\n (\n [Time].CurrentHierarchy.DefaultMember,\n [Measures].[Issues with due date]\n )\n ))\nEND”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Actual(In Review+Completed) (Test)”,“formula”:“Sum(\n–list of members for sum\n {[Status].[In Review],\n [Status].[Completed],\n [Status].[Done]},\n–numeric value\n[Measures].[Issues created]\n)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Planned Until Today”,“formula”:“Sum(\n { PreviousPeriods([Time].[Day].CurrentDateMember)},\n [Measures].[Issues with due date]\n)\n”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Overdue Issues”,“formula”:“CASE WHEN\n [Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember\nTHEN\n– when no time dimension is used in the report get today\n SUM(\n PreviousPeriods(\n [Time].CurrentHierarchy.Levels("Day").CurrentDateMember),\n [Measures].[Issues due]\n --example reusable for any date custom field use instead of measure Issued due\n – ([Measures].[Issues with due date],\n – [Resolution].[(unresolved)])\n )\nWHEN\n– with time dimension in the report apply the calcualtion for past dates and today only\n DateAfterPeriodEnd("Today", [Time].CurrentHierarchyMember)\n OR\n DateInPeriod("Today", [Time].CurrentHierarchyMember)\nTHEN \n SUM(\n PreviousPeriods(\n [Time].CurrentHierarchyMember),\n [Measures].[Issues due]\n --example reusable for any date custom field use instead of measure Issued due\n – ([Measures].[Issues with due date],\n – [Resolution].[(unresolved)])\n )\nEND”,“format_string”:“#,##0”}],“description”:“Overdue issue - currently open overdue issues\nIssues due in time - issues by due date - resolved in time or unresolved not overdue yet\nIssues due not in time - issues by due date - resolved later or unresolved overdue\nOverdue issues in period - counts issues for any period since due date till resolution date if an issue was overdue in the period.”}
} ],
“calculated_members”: [{“dimension”:“Measures”,“name”:“Issue resolution date”,“format_string”:“mmm dd yyyy”,“formula”:“[Issue].CurrentHierarchyMember.get(‘Resolved at’)”},{“dimension”:“Measures”,“name”:“Issue due date”,“format_string”:“mmm dd yyyy”,“formula”:“[Issue].CurrentHierarchyMember.get(‘Due date’)”},{“name”:“Commercial “,“dimension”:“Functional Domain”,“formula”:”[Functional Domain].[Commercial]”,“format_string”:“”},{“name”:“Finance \u0026 Procurement”,“dimension”:“Functional Domain”,“formula”:“Aggregate({\n[Functional Domain].[Finance],\n[Functional Domain].[Procurement]\n})”,“format_string”:“”},{“name”:“Operations “,“dimension”:“Functional Domain”,“formula”:“Aggregate({\n[Functional Domain].[Manufacturing],\n[Functional Domain].[QA],\n[Functional Domain].[TRD],\n[Functional Domain].[SCM],\n[Functional Domain].[PLM]\n})”,“format_string”:””},{“name”:“Not Cancelled”,“dimension”:“Status”,“formula”:“Aggregate(\n Except(\n [Status].[Status].Members,\n { \n [Status].[Cancelled]\n }\n )\n)”,“format_string”:“”},{“name”:“Total”,“dimension”:“Work Item type”,“formula”:“Aggregate({\n[Work Item type].[Design],\n[Work Item type].[Development],\n[Work Item type].[Config],\n[Work Item type].[OQS],\n[Work Item type].[CSD]\n})”,“format_string”:“”},{“name”:“Except Data Migration”,“dimension”:“Issue Subtype”,“formula”:“Aggregate(\n Except(\n [Issue Subtype].[Issue Subtype].Members,\n { \n \n [Issue Subtype].[Data]\n }\n )\n)”,“format_string”:“”},{“name”:“Total Planned”,“dimension”:“Measures”,“formula”:“[Status].[Not Cancelled]”,“format_string”:“”}]
}
Please help me in this report, where I do not want to show completed issues in OQS column and other columns as well. I am not getting completed issues in other columns, but getting completed issues in OQS,