Hi Team,
I am unable to drill through the issues in this below report, getting the below error as in the attached screenshot. Can you please help me on the report so that I can drill through the issues in the report.
Below is the report Definition.
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "LDC_F2C_DE_Actions",
"folder_name": "LDC - F2C",
"result_view": "line_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Closed]","[Measures].[In Review ]","[Measures].[In Progress ]","[Measures].[Open]","[Measures].[Baseline]","[Measures].[Revised Target]","[Measures].[Cumulative Issues created]"],"members":[{"depth":0,"name":"Cumulative Issues created","full_name":"[Measures].[Cumulative Issues created]","drillable":false,"calculation_of":"[Measures].[Issues created]","calculation":"cumulative_sum_including_empty","format_string":"#,##0"}]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time.Weekly].[Week].Members"],"members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Country Relevance","selected_set":["[Country Relevance].[DE]"],"members":[{"depth":1,"name":"DE","full_name":"[Country Relevance].[DE]"}],"bookmarked_members":[{"depth":1,"name":"DE","full_name":"[Country Relevance].[DE]"}],"current_page_members":["[Country Relevance].[DE]"]},{"name":"Status","selected_set":["[Status].[All but cancelled / rejected]"],"members":[{"depth":0,"name":"All but cancelled / rejected","full_name":"[Status].[All but cancelled / rejected]","calculated":true,"drillable":true}],"bookmarked_members":[],"current_page_members":["[Status].[All but cancelled / rejected]"]},{"name":"Action Category","selected_set":["[Action Category].[F2C]"],"members":[{"depth":0,"name":"F2C","full_name":"[Action Category].[F2C]","calculated":true}],"bookmarked_members":[],"current_page_members":["[Action Category].[F2C]"]},{"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}],"bookmarked_members":[],"current_page_members":["[Functional Domain].[LDC - Verticals]"]},{"name":"Workstream","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":"Assignee","selected_set":["[Assignee].[All Assignees]"],"members":[{"depth":0,"name":"All Assignees","full_name":"[Assignee].[All Assignees]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Assignee].[All Assignees]"]},{"name":"Priority","selected_set":["[Priority].[All Priorities]"],"members":[{"depth":0,"name":"All Priorities","full_name":"[Priority].[All Priorities]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Priority].[All Priorities]"]}],"nonempty_crossjoin":true},"options":{"nonempty":true},"view":{"current":"line_chart","maximized":false,"line_chart":{"area":true,"stacked":true,"swap_axes":false,"data_labels":false,"series_options":{"Open":{"type":"column","dataLabelType":"top horizontal","color":"#FA80A7"},"In Progress ":{"type":"column","dataLabelType":"top horizontal"},"Issues created":{"type":"spline","symbol":"triangle"},"In Review ":{"type":"column","color":"#86DBA6"},"Closed":{"type":"column","dataLabelType":"top horizontal","color":"#006644"},"Baseline":{"type":"line"},"Revised Target":{"type":"line","color":"#091E42","dataLabelType":"top rotated"},"Cumulative Issues created":{"type":"line-Dash","dataLabelType":"top vertical","color":"#CFF9DD"}}},"table":{"freeze_header":true}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Measures","name":"Issues history","format_string":"#,##0","formula":"Cache(\n NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),\n [Measures].[Transitions to]\n - [Measures].[Transitions from]\n ))\n + [Measures].[Transitions to]\n - [Measures].[Transitions from]\n)"},{"name":"All but cancelled / rejected","dimension":"Status","formula":"Aggregate(\n Except(\n [Status].[Status].Members,\n { \n [Status].[Cancelled],\n [Status].[Rejected]\n }\n )\n)","format_string":""},{"name":"Baseline","dimension":"Measures","formula":"/*cumulativeSum([Measures].[Issues with Target end])*/\n\nSum(\n { PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember },\n [Measures].[Issues with Target end]\n)","format_string":""},{"name":"Revised Target","dimension":"Measures","formula":"/*CumulativeSum([Measures].[Issues with due date])*/\n\nSum(\n { PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember },\n [Measures].[Issues with due date]\n)","format_string":""},{"name":"In Review ","dimension":"Measures","formula":"IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[In Review]),NULL)\n","format_string":""},{"name":"In Progress ","dimension":"Measures","formula":"IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[In Progress]),NULL)","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].[PLM],\n[Functional Domain].[Solution],\n[Functional Domain].[Data],\n[Functional Domain].[Manufacturing],\n[Functional Domain].[QA],\n[Functional Domain].[SCM],\n[Functional Domain].[TRD],\n[Functional Domain].[Reporting \u0026 Analytics],\n[Functional Domain].[Unmatch]\n\n})","format_string":""},{"name":"Commercial Workstream","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].[COMP-Pillar: Commercial],\n[Workstream].[COM-Quote-to-Contract],\n[Workstream].[COM-Release-to-Invoice],\n[Workstream].[COM-Strategy-to-Demand],\n[Workstream].[DAT-Commercial]})","format_string":""},{"name":"Finance Workstream","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})","format_string":""},{"name":"Procurement Workstream","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].[PUR-S2P],\n[Workstream].[SEP-Supplier Exp - Supplier Information Mgmt],\n[Workstream].[SEP-Supplier Exp- Supplier Data Quality]\n})","format_string":""},{"name":"Operations Workstream","dimension":"Workstream","formula":"Aggregate({\n[Workstream].[OPSP-Pillar: Manufacturing],\n[Workstream].[OPSP-Pillar: Quality],\n[Workstream].[OPSP-Pillar: Supply Chain],\n[Workstream].[OPSP-Pillar: TRD],\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 - Long Term, Demand and Supply Planning],\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].[SCM Supply Chain Management],\n[Workstream].[OPS-Quality (incl. OBBR)]\n})","format_string":""},{"name":"Closed","dimension":"Measures","formula":"IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Closed]),NULL)","format_string":""},{"name":"F2C","dimension":"Action Category","formula":"[Action Category].[F2C (FIT-TO-CORE)]","format_string":""},{"name":"Open","dimension":"Measures","formula":"IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Open]),NULL)","format_string":""},{"name":"LDC - Workstreams","dimension":"Workstream","formula":"Aggregate({\n[Workstream].[Commercial Workstream],\n[Workstream].[Finance Workstream],\n[Workstream].[Procurement Workstream],\n[Workstream].[Operations Workstream]\n})","format_string":""}]
}
Thanks in advance.
