Hello,
How can it create a new column to get the issues with Due date <Today
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.]”,“[Measures].[Overdue]”],“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”: [{“dimension”:“Measures”,“name”:“Issue due date”,“format_string”:“mmm dd yyyy”,“formula”:“[Issue].CurrentHierarchyMember.get(‘Due date’)”},{“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”:“Overdue”,“dimension”:“Measures”,“formula”:“NonZero(Count(\n Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),\n [Measures].[Issues with due date]\u003e0 and \n IsEmpty([Measures].[Issues resolved]) AND\n DateCompare([Measures].[Issue due date],Now())\u003c0\n )\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”:“”}]
}