I have exported the report definition from one account and imported into new account getting the below error in the calculated member
Note: The report in initial account is working fine. Could you please help me the reason behind the below error
Report Definition;
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "LDC KPI Reporting – Build Deliverables Overview (Program and Function)",
"folder_name": "LDC - Build - IT",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Functional Domain","selected_set":["[Functional Domain].[Total ]","[Functional Domain].[Commercial ]","[Functional Domain].[Finance \u0026 Procurement]","[Functional Domain].[Operations ]"],"members":[],"bookmarked_members":[]},{"name":"Measures","selected_set":["[Measures].[Planned ]","[Measures].[Backlog ]","[Measures].[In Progress ]","[Measures].[Screening ]","[Measures].[In Review ]","[Measures].[On Hold]","[Measures].[Complete]","[Measures].[In Review %]","[Measures].[Complete %]","[Measures].[In Review % without backlog]","[Measures].[Complete % without backlog]"],"members":[]}]},"rows":{"dimensions":[{"name":"Work Item type","selected_set":["[Work Item type].[Functional Specification]","[Work Item type].[Total Developments ]","[Work Item type].[Config Document]","[Work Item type].[OQS (Test Script)]","[Work Item type].[Configuration Activities]"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"2022","full_name":"[Time].[2022]","drillable":true,"parent_full_name":"[Time].[All Times]"},{"depth":1,"name":"2023","full_name":"[Time].[2023]","drillable":true,"parent_full_name":"[Time].[All Times]"}],"bookmarked_members":[],"current_page_members":["[Time].[2022]","[Time].[2023]"]},{"name":"Status","selected_set":["[Status].[Status Work Item]"],"members":[{"depth":0,"name":"Status Work Item","full_name":"[Status].[Status Work Item]","calculated":true,"drillable":true,"dimension":"Status"}],"bookmarked_members":[],"current_page_members":["[Status].[Status Work Item]"]},{"name":"Issue Subtype","selected_set":["[Issue Subtype].[S/4HANA Eco System]","[Issue Subtype].[S/4HANA Report]","[Issue Subtype].[EDW Report]","[Issue Subtype].[Regression]","[Issue Subtype].[Total Work Items]"],"members":[{"depth":0,"name":"Total Work Items","full_name":"[Issue Subtype].[Total Work Items]","calculated":true,"dimension":"Issue Subtype"}],"bookmarked_members":[],"current_page_members":["[Issue Subtype].[Total Work Items]"]},{"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":"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]","[Release_Version].[R1]","[Release_Version].[R2]"],"members":[{"depth":0,"name":"All Release_Versions","full_name":"[Release_Version].[All Release_Versions]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Release_Version].[All Release_Versions]"]}]},"options":{"nonempty":true},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"name":"Status Work Item","dimension":"Status","formula":"Aggregate({\n [Status].[Backlog],\n [Status].[Scheduled],\n [Status].[In Progress],\n [Status].[Screening],\n [Status].[In Screening],\n [Status].[In Review],\n [Status].[Testing],\n [Status].[PQM Check],\n [Status].[Completed],\n [Status].[Done],\n [Status].[On Hold]\n})","format_string":""},{"name":"On Hold","dimension":"Measures","formula":"[Status].[On Hold]","format_string":""},{"name":"Completed ","dimension":"Status","formula":"[Status].[Done]+\n[Status].[Completed]","format_string":""},{"name":"Functional Specification","dimension":"Work Item type","formula":"[Work Item type].[Design]","format_string":""},{"name":"S/4HANA Eco System","dimension":"Issue Subtype","formula":"[Issue Subtype].[(none)]+\n[Issue Subtype].[Integration-Topic]+\n[Issue Subtype].[FCC]","format_string":""},{"name":"EDW Report","dimension":"Issue Subtype","formula":"[Issue Subtype].[R\u0026A_EDW]","format_string":""},{"name":"Regression","dimension":"Issue Subtype","formula":"[Issue Subtype].[R\u0026A_Regression]","format_string":""},{"name":"S/4HANA Report","dimension":"Issue Subtype","formula":"/*[Measures].[S/4HANA Report]*/\n/*[Issue Subtype].[R\u0026A]-[Label].[Exclude EDW \u0026 Regression \u0026 EA]*/\n\n[Issue Subtype].[R\u0026A_ABAP]","format_string":""},{"name":"S/4HANA Report","dimension":"Measures","formula":"[Issue Subtype].[R\u0026A]-\n([Label].[R\u0026A_EDW]-[Label].[R\u0026A_Regression])","format_string":""},{"name":"Total Work Items","dimension":"Issue Subtype","formula":"[Issue Subtype].[S/4HANA Eco System]+\n[Issue Subtype].[EDW Report]+\n[Issue Subtype].[Regression]+\n[Issue Subtype].[S/4HANA Report]+\n[Issue Subtype].[S/4HANA Report - EA]+\n[Issue Subtype].[EDW PaPM]\n","format_string":""},{"name":"S/4HANA Report - EA","dimension":"Issue Subtype","formula":"/*[Label].[EA]*/\n\n[Issue Subtype].[R\u0026A_EA]","format_string":""},{"name":"EDW PaPM","dimension":"Issue Subtype","formula":"[Issue Subtype].[R\u0026A_PaPM]","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":"OQS (Test Script)","dimension":"Work Item type","formula":"[Work Item type].[OQS]","format_string":""},{"name":"Config Document","dimension":"Work Item type","formula":"[Work Item type].[CSD]","format_string":"#,##0"},{"name":"Backlog / Scheduled","dimension":"Status","formula":"[Status].[Backlog] + [Status].[Scheduled]","format_string":""},{"name":"In Progress ","dimension":"Measures","formula":"/*[Status].[In Progress]*/\n\n([Measures].[Issues with due date],[Status].[In Progress])","format_string":""},{"name":"Configuration Activities","dimension":"Work Item type","formula":"[Work Item type].[Config]","format_string":"#,##0"},{"name":"Development Factory","dimension":"Work Item type","formula":"[Work Item type].[Development]","format_string":""},{"name":"Other Core Developments","dimension":"Work Item type","formula":"[Work Item Type].[Dev Other]","format_string":""},{"name":"Development EDW","dimension":"Work Item type","formula":"[Work Item type].[Dev EDW]","format_string":""},{"name":"Development Integration","dimension":"Work Item type","formula":"[Work Item type].[Dev Int]","format_string":""},{"name":"Total Developments ","dimension":"Work Item type","formula":"Aggregate({\n[Work Item type].[Development Factory],\n[Work Item type].[Development EDW],\n[Work Item type].[Development Integration],\n[Work Item type].[Other Core Developments]\n})","format_string":""},{"name":"Config","dimension":"Work Item type","formula":"[Work Item type].[Config]","format_string":""},{"name":"Planned ","dimension":"Measures","formula":"Aggregate(\n[Time].[Day].DateMembersBetween('July 01 2022', 'June 23 2023'),[Measures].[Issues with due date]\n\n)","format_string":""},{"name":"Complete %","dimension":"Measures","formula":"([Measures].[Complete]/[Measures].[Planned ])","format_string":"#0%"},{"name":"Total","dimension":"Measures","formula":"/*[Measures].[Issues with Target end]*/\nAggregate(\n[Time].[Day].DateMembersBetween('Sep 01 2022', 'Dec 31 2025'),[Measures].[Issues with due date]\n\n)","format_string":""},{"name":"Backlog ","dimension":"Measures","formula":"/*Status].[Backlog]+\n[Status].[Scheduled]*/\n\n([Measures].[Issues with due date],[Status].[Backlog / Scheduled])","format_string":""},{"name":"Scheduled ","dimension":"Measures","formula":"[Status].[Scheduled]","format_string":""},{"name":"Screening ","dimension":"Measures","formula":"/*[Status].[In Screening]*/\n\n([Measures].[Issues with due date],[Status].[In Screening])","format_string":""},{"name":"In Review ","dimension":"Measures","formula":"/*[Status].[In Review]*/\n\n([Measures].[Issues with due date],[Status].[In Review])","format_string":""},{"name":"Complete","dimension":"Measures","formula":"/*[Status].[Completed]+\n[Status].[Done]*/\n\n([Measures].[Issues with due date],[Status].[Completed ])","format_string":""},{"name":"In Review Planned","dimension":"Measures","formula":"Aggregate({\n[Measures].[Backlog ],\n[Measures].[Screening ],\n[Measures].[In Review ],\n[Measures].[In Progress ],\n[Measures].[On Hold]\n})","format_string":""},{"name":"In Review %","dimension":"Measures","formula":"/*CASE WHEN [Measures].[In Review Planned] \u003e0\nTHEN\n[Measures].[In Review ]/[Measures].[In Review Planned]\nEND*/\n\nCASE WHEN [Measures].[Total] \u003e0\nTHEN\n[Measures].[In Review ]/[Measures].[Total]\nEND","format_string":"#0%"},{"name":"Planned Items without backlog","dimension":"Measures","formula":"Aggregate({\n\n[Measures].[In Progress ],\n[Measures].[Screening ],\n[Measures].[Scheduled ],\n[Measures].[In Review ]\n})","format_string":""},{"name":"Complete % without backlog","dimension":"Measures","formula":"/*CASE WHEN [Measures].[Planned Items without backlog]\u003e0\nTHEN\n[Measures].[Complete]/[Measures].[Planned Items without backlog]\nEND*/\n\n\nCASE WHEN [Measures].[Total without backlog]\u003e0\nTHEN\n[Measures].[Complete]/[Measures].[Total without backlog]\nEND","format_string":"#0%"},{"name":"In Review Planned without backlog","dimension":"Measures","formula":"Aggregate({\n[Measures].[Screening ],\n[Measures].[Scheduled ],\n[Measures].[In Progress ],\n[Measures].[On Hold]\n})","format_string":""},{"name":"In Review % without backlog","dimension":"Measures","formula":"/*CASE WHEN [Measures].[In Review Planned without backlog]\u003e0\nTHEN\n[Measures].[In Review ]/[Measures].[In Review Planned without backlog]\nEND\n*/\nCASE WHEN [Measures].[Total without backlog]\u003e0\nTHEN\n[Measures].[In Review ]/[Measures].[Total without backlog]\nEND","format_string":"#0%"},{"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].[COM-Quote-to-Contract],\n[Workstream].[COM-Release-to-Invoice],\n[Workstream].[COM-Strategy-to-Demand],\n[Workstream].[COMP-Pillar: Commercial],\n[Workstream].[DAT-Commercial]\n})","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[Workstream].[FINP-Pillar: Finance],\n[Workstream].[DAT-Customer \u0026 Commercial],\n[Workstream].[FIN-RDF and intercompany]\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].[PURP-Pillar: Procurement],\n[Workstream].[SEP-Supplier Exp- Supplier Data Quality]\n})","format_string":""},{"name":"Operations Workstream","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 - 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[Workstream].[OPS-SCM - Ariba SCC],\n[Workstream].[OPSP-Pillar: Manufacturing],\n[Workstream].[OPSP-Pillar: Quality],\n[Workstream].[OPSP-Pillar: Supply Chain],\n[Workstream].[OPSP-Pillar: TRD]\n})","format_string":""},{"name":"Total ","dimension":"Functional Domain","formula":"Aggregate({\n[Functional Domain].[Commercial],\n[Functional Domain].[Operations],\n[Functional Domain].[Manufacturing],\n[Functional Domain].[QA],\n[Functional Domain].[SCM],\n[Functional Domain].[TRD],\n[Functional Domain].[Finance],\n[Functional Domain].[Procurement]\n})","format_string":""},{"name":"Total without backlog","dimension":"Measures","formula":"[Measures].[Planned ]-[Measures].[Backlog ]","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[Workstream].[Solution Workstream],\n[Workstream].[DAT-Migration],\n[Workstream].[MOM - Masters of Material],\n[Workstream].[N/A],\n[Workstream].[Unmatch]\n})","format_string":""},{"name":"Solution Workstream","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":""}]
}
