Hi Team,
We are trying to build the report based on Baseline Sprint field in our instance. I have attached a report definition below.
As in the below screenshot we as considering ToDo as issues in other status except completed and Completed as status completed.
Now, we want to build a report as in the second screenshot to show the delayed issues.
Delayed issues should be showing the issues still in previous baseline
As we are not using “Time” dimension in the report is it possible to get the “Overdue” issues to be shown as Delayed issues for which Due Date is <Today, if so please provide me the measure for the same.
Report Definition: {
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “L4 Processes R2.0\u0026R2.5 (NEW-WIP)”,
“folder_name”: “LDC - Design - All Releases”,
“result_view”: “bar_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[To Do]”,“[Measures].[Completed.]”],“members”:[{“depth”:0,“full_name”:“[Measures].[Completed.]”,“format_string”:“”,“report_specific”:true,“name”:“Completed.”,“calculated”:true}]}]},“rows”:{“dimensions”:[{“name”:“Baseline Sprint”,“selected_set”:[“[Baseline Sprint].[CD2-Baseline]”],“members”:[{“depth”:0,“name”:“CD2-Baseline”,“full_name”:“[Baseline Sprint].[CD2-Baseline]”,“calculated”:true,“drillable”:true,“expanded”:true,“drilled_into”:false,“removed”:true}],“bookmarked_members”:}]},“pages”:{“dimensions”:[{“name”:“Workstream”,“selected_set”:[“[Workstream].[LDC - Workstreams]”,“[Workstream].[Commercial]”,“[Workstream].[Finance]”,“[Workstream].[Procurement]”,“[Workstream].[Operations]”],“members”:[{“depth”:0,“name”:“LDC - Workstreams”,“full_name”:“[Workstream].[LDC - Workstreams]”,“calculated”:true,“drillable”:true,“dimension”:“Workstream”}],“bookmarked_members”:,“current_page_members”:[“[Workstream].[LDC - Workstreams]”]},{“name”:“Issue Type”,“selected_set”:[“[Issue Type].[Process L4]”],“members”:[{“depth”:0,“name”:“Process L4”,“full_name”:“[Issue Type].[Process L4]”,“calculated”:true}],“bookmarked_members”:,“current_page_members”:[“[Issue Type].[Process L4]”]},{“name”:“Functional Domain”,“selected_set”:[“[Functional Domain].[LDC - Verticals]”,“[Functional Domain].[Commercial ]”,“[Functional Domain].[Finance \u0026 Procurement]”,“[Functional Domain].[Operations ]”,“[Functional Domain].[Solution ]”,“[Functional Domain].[Data]”],“members”:[{“depth”:0,“name”:“LDC - Verticals”,“full_name”:“[Functional Domain].[LDC - Verticals]”,“calculated”:true,“drillable”:true,“dimension”:“Functional Domain”,“expanded”:true,“drilled_into”:false},{“depth”:0,“name”:“Finance \u0026 Procurement”,“full_name”:“[Functional Domain].[Finance \u0026 Procurement]”,“calculated”:true,“drillable”:true,“expanded”:true,“drilled_into”:false,“parent_full_name”:“[Functional Domain].[LDC - Verticals]”},{“depth”:0,“name”:“Operations “,“full_name”:”[Functional Domain].[Operations ]”,“calculated”:true,“drillable”:true,“expanded”:true,“drilled_into”:false,“parent_full_name”:“[Functional Domain].[LDC - Verticals]”}],“bookmarked_members”:,“current_page_members”:[“[Functional Domain].[LDC - Verticals]”]}]},“options”:{},“view”:{“current”:“bar_chart”,“maximized”:false,“bar_chart”:{“stacked”:true,“vertical”:true,“swap_axes”:false,“data_labels”:“values”,“series_options”:{“Issue Baseline Sprint”:{“type”:“line”},“Issue fix versions”:{“separateAxis”:3},“Issues created”:{“color”:“#8993A4”,“type”:“column”},“Actual”:{“color”:“#8993A4”},“Baseline Sprint”:{“color”:“#5A89CE”,“type”:“line”},“Target Sprint “:{“color”:”#FF983D”,“type”:“line”,“dataLabelType”:“top vertical”},“Done “:{“color”:”#34AD70”},“To - Do”:{“color”:“#8993A4”},“CD2-Baseline”:{“type”:“line”},“Finance & Procurement”:{“color”:“#6F2DAA”},“Solution”:{“color”:“#5A89CE”},“To Do”:{“color”:“#5E6C84”},“Completed “:{“color”:”#00875A”},“Completed.”:{“color”:“#00875A”},“Baseline Plan”:{“type”:“line”},“Revised Plan”:{“type”:“line”,“color”:“#F24B13”}}},“table”:{}},“calculated_members”:[{“dimension”:“Measures”,“name”:“Completed.”,“formula”:“[Status].[Completed]”,“format_string”:“”}]}
} ],
“calculated_members”: [{“name”:“To Do”,“dimension”:“Measures”,“formula”:“Aggregate({\n [Status].[Backlog],\n [Status].[Scheduled],\n [Status].[In Design],\n [Status].[In Progress],\n [Status].[In Review],\n [Status].[Ready for PtQ],\n [Status].[Testing],\n [Status].[Ready for PTP],\n [Status].[On Hold]\n})”,“format_string”:“”},{“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].[Operations],\n[Functional Domain].[QA],\n[Functional Domain].[TRD],\n[Functional Domain].[SCM],\n[Functional Domain].[PLM]\n})”,“format_string”:””},{“name”:“LDC - Verticals”,“dimension”:“Functional Domain”,“formula”:“Aggregate({\n[Functional Domain].[Commercial],\n[Functional Domain].[Finance \u0026 Procurement],\n[Functional Domain].[Operations ],\n[Functional Domain].[Solution],\n[Functional Domain].[Data],\n[Functional Domain].[Reporting \u0026 Analytics],\n[Functional Domain].[Data Migration],\n[Functional Domain].[Adopt],\n[Functional Domain].[Unmatch],\n[Functional Domain].[(none)]\n})”,“format_string”:“”},{“name”:“Solution “,“dimension”:“Functional Domain”,“formula”:”[Functional Domain].[Solution]”,“format_string”:“”},{“name”:“Commercial”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Commercial],\n[Workstream].[COM-Customer 360],\n[Workstream].[COM-Evidence-to-Value],\n[Workstream].[COM-Lead-to-Quote],\n[Workstream].[COM-Order-to-Release],\n[Workstream].[COM-Quote-to-Contract],\n[Workstream].[COM-Release-to-Invoice],\n[Workstream].[COM-Strategy-to-Demand],\n[Workstream].[DAT-Commercial]\n})”,“format_string”:“”},{“name”:“Finance”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Finance \u0026 Procurement],\n[Workstream].[DAT-Finance \u0026 Controlling],\n[Workstream].[DAT-Customer],\n[Workstream].[FIN-Asset Accounting and Projects],\n[Workstream].[FIN-FC\u0026C (incl. Analytics)],\n[Workstream].[FIN-General Ledger and Period End],\n[Workstream].[FIN-I2C - Invoice 2 Cash],\n[Workstream].[FIN-Operations Finance],\n[Workstream].[FIN-Intercompany],\n[Workstream].[FIN-Revenue Management],\n[Workstream].[FIN-RDF],\n[Workstream].[FIN-Tax],\n[Workstream].[FIN-Treasury and Cash-Management],\n[Workstream].[FINP-Pillar: Finance]\n})”,“format_string”:“”},{“name”:“Procurement”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[DAT-Supplier \u0026 Procurement],\n[Workstream].[PUR-Accounts Payable and Supplier Experience (SLP)],\n[Workstream].[PUR-CE and Transactional Direct Procurement],\n[Workstream].[PUR-CE and Transactional Indirect Procurement and Front door],\n[Workstream].[PUR-Strategic Procurement and S2C],\n[Workstream].[SEP-Supplier Exp - Supplier Information Mgmt],\n[Workstream].[SEP-Supplier Exp- Supplier Data Quality]\n})”,“format_string”:“”},{“name”:“Operations”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Operations],\n[Workstream].[DAT-Material \u0026 Operations],\n[Workstream].[DAT-Product \u0026 Brand],\n[Workstream].[OPS-Manufacturing - Asset Management],\n[Workstream].[OPS-Manufacturing - Manufacturing],\n[Workstream].[OPS-SCM - Demand Planning],\n[Workstream].[OPS-SCM - External Manufacturing],\n[Workstream].[OPS-SCM - Intercompany Order Management / Customs and Trade Compliance],\n[Workstream].[OPS-SCM - Lifecycle Management and Implementation],\n[Workstream].[OPS-SCM - Logistics/Warehousing],\n[Workstream].[OPS-SCM - Production planning],\n[Workstream].[OPS-SCM - Supply Planning],\n[Workstream].[OPS-TRD - Clinical Supply],\n[Workstream].[OPS-TRD - Embedded],\n[Workstream].[OPS-Quality (incl. OBBR)],\n[Workstream].[OPS-DAT - Triggered Project],\n[Workstream].[OPS-SCM - Ariba SCC],\n[Workstream].[MOM - Masters of Material]\n})”,“format_string”:“”},{“name”:“LDC - Workstreams”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[Commercial],\n[Workstream].[Finance],\n[Workstream].[Procurement],\n[Workstream].[Operations],\n[Workstream].[Solutions],\n[Workstream].[DAT-Migration],\n[Workstream].[N/A],\n[Workstream].[Unmatch],\n[Workstream].[(none)]\n})”,“format_string”:“”},{“name”:“Process L4”,“dimension”:“Issue Type”,“formula”:“[Epic Type].[Process L4]”,“format_string”:“”},{“name”:“CD2-Baseline”,“dimension”:“Baseline Sprint”,“formula”:“Aggregate({\n\n[Baseline Sprint].[CD2 - Sprint 1],\n[Baseline Sprint].[CD2 - Sprint 2],\n[Baseline Sprint].[CD2 - Sprint 3],\n[Baseline Sprint].[CD2 - Sprint 4],\n[Baseline Sprint].[CD2 - Sprint 5],\n[Baseline Sprint].[CD2 - Sprint 6],\n[Baseline Sprint].[CD2 - Sprint 7],\n[Baseline Sprint].[CD2 - Sprint 8],\n[Baseline Sprint].[CD2 - Sprint 9]\n\n})”,“format_string”:“”},{“name”:“Solutions”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Integration],\n[Workstream].[DAT-Integration],\n[Workstream].[SOL-BPM],\n[Workstream].[SOL-Build Management],\n[Workstream].[SOL-Data],\n[Workstream].[SOL-Design Management],\n[Workstream].[SOL-Learning],\n[Workstream].[SOL-Platform Management],\n[Workstream].[SOL-Platform Management Basis],\n[Workstream].[SOL-Platform Management Integration],\n[Workstream].[SOL-R\u0026A],\n[Workstream].[SOL-Security \u0026 Authorization],\n[Workstream].[SOL-Solution Core \u0026 Integration],\n[Workstream].[SOL-Solution Methodology],\n[Workstream].[SOL-Technology \u0026 Architecture]\n})”,“format_string”:“”}]
}