Hello Team,
I wanted to drill across the Subtasks in the below report, when I try to do this I am getting this below
Please let me know how can we able to drill across the Sub-Task in the below report.
I can see that there are subtaks created under those issues in the report for example
Report Definition:
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "LDC Triggered Projects RAG Status by Workstream",
"folder_name": "LDC - Build - IT",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Issues created]"],"members":[]},{"name":"RAG Status","selected_set":["[RAG Status].[(none)]","[RAG Status].[At Risk]","[RAG Status].[Not Started]","[RAG Status].[Off Track]","[RAG Status].[On Track]"],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Workstream","selected_set":["[Workstream].[LDC - Workstreams]"],"members":[{"depth":0,"name":"LDC - Workstreams","full_name":"[Workstream].[LDC - Workstreams]","calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"removed":true}],"bookmarked_members":[]}]},"pages":{"dimensions":[{"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":"Action","full_name":"[Issue Type].[Action]","parent_full_name":"[Issue Type].[All Issue Types]"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Action]"]},{"name":"Status","selected_set":["[Status].[All but Closed]"],"members":[{"depth":0,"dimension":"Status","name":"All but Closed","formula":"Aggregate(\n Except(\n [Status].[Status].Members,\n { \n [Status].[Closed]\n }\n )\n)","format_string":"","full_name":"[Status].[All but Closed]","drillable":true,"annotations":null,"dependent_calculated_members_count":0,"dependent_report_ids":[],"calculated":true}],"bookmarked_members":[],"current_page_members":["[Status].[All but Closed]"]},{"name":"Action Type","selected_set":["[Action Type].[All Action Types]"],"members":[{"depth":0,"name":"All Action Types","full_name":"[Action Type].[All Action Types]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Integrated Application","full_name":"[Action Type].[Integrated Application]","parent_full_name":"[Action Type].[All Action Types]"}],"bookmarked_members":[],"current_page_members":["[Action Type].[Integrated Application]"]},{"name":"Functional Domain","selected_set":["[Functional Domain].[LDC - Verticals]"],"members":[{"depth":0,"name":"LDC - Verticals","full_name":"[Functional Domain].[LDC - Verticals]","calculated":true,"drillable":true,"expanded":true,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Functional Domain].[LDC - Verticals]"]},{"name":"Workstream","duplicate":true,"selected_set":["[Workstream].[LDC - Workstreams]"],"members":[{"depth":0,"name":"LDC - Workstreams","full_name":"[Workstream].[LDC - Workstreams]","calculated":true,"drillable":true}],"bookmarked_members":[],"current_page_members":["[Workstream].[LDC - Workstreams]"]},{"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":{"row_dimension_headers":{"Workstream":true},"cell_formatting":{"[RAG Status].[Off Track]":{"type":"range","rules":[{"background_color":"#B31238"}]},"[RAG Status].[On Track]":{"type":"range","rules":[{"background_color":"#00875A"}]},"[RAG Status].[Not Started]":{"type":"range","rules":[{"background_color":"#7CA7E5"}]}}}},"calculated_members":[{"dimension":"Measures","name":"Total ","formula":"([Measures].[Issues created],[Status].[Not Cancelled])","format_string":""},{"dimension":"Measures","name":"Overdue ","formula":"CASE WHEN\n [Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember\nTHEN\n SUM(\n PreviousPeriods(\n [Time].CurrentHierarchy.Levels(\"Day\").CurrentDateMember),\n [Measures].[Issues with due date]\n )\nWHEN\n DateAfterPeriodEnd(\"Today\", [Time].CurrentHierarchyMember)\n OR\n DateInPeriod(\"Today\", [Time].CurrentHierarchyMember)\nTHEN \n SUM(\n PreviousPeriods(\n [Time].CurrentHierarchyMember),\n [Measures].[Issues with due date]\n )\nEND","format_string":""},{"dimension":"Measures","name":"Closed ","formula":"[Status].[Closed]+\n[Status].[Done]","format_string":""},{"dimension":"Measures","name":"In Review ","formula":"[Status].[In Review]","format_string":""},{"dimension":"Measures","name":"In Progress ","formula":"Aggregate({\n[Status].[In Progress],\n[Status].[Re-opened]\n})","format_string":""},{"dimension":"Measures","name":"On Hold ","formula":"[Status].[On Hold]","format_string":""},{"dimension":"Measures","name":"Open ","formula":"[Status].[Open]","format_string":""},{"dimension":"Measures","name":"Blank Due Date","formula":"[Measures].[Issues created]-[Measures].[Issues with due date]","format_string":"#,##0"},{"dimension":"Measures","name":"REF Blank Due Date","formula":"NonZero(\n Sum(\n Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),\n IsEmpty([Measures].[Issue due date])\n )\n )\n)","format_string":""}]}
} ],
"calculated_members": [{"dimension":"Measures","name":"Issue due date","format_string":"mmm dd yyyy","formula":"[Issue].CurrentHierarchyMember.get('Due date')"},{"name":"Not Cancelled","dimension":"Status","formula":"Aggregate(\n Except(\n [Status].[Status].Members,\n { \n [Status].[Cancelled]\n }\n )\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":"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-BPA],\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-SCM - Long Term, Demand and Supply Planning],\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":"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[Workstream].[SOL-BITC-NFCM]\n})","format_string":""},{"name":"All but Closed","dimension":"Status","formula":"Aggregate(\n Except(\n [Status].[Status].Members,\n { \n [Status].[Closed]\n }\n )\n)","format_string":""}]
}