Error message in the report

I have exported the report definition from one account and imported into new account getting the below error in the calculated member
image

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":""}]
}

Hi, @Amzad

Thank you for sending the report definition.

If the report definition is exported and imported using “Import Definition”, there should not be a problem with it!

Does the problem persist? Or was it a one-time thing?

If the problem persists, please write us to support@eazybi.com

Kindy,
Ilze support@eazybi.com

The problem is still there.

Hi, @Amzad

Sorry for not catching the reason at first.

The root cause seems to be related to the “Config” member in the dimension. Upon closer examination of the report definition, it appears that “Config” is defined as a loop to itself:

		{
			"name": "Config",
			"dimension": "Work Item type",
			"formula": "[Work Item type].[Config]",
			"format_string": ""
		},

To gain insights into the attributes of the “Work Item type,” I recommend generating a report. Set the dimension as “Work Item Type” in the rows and select the hierarchy “Work Item type” under “All hierarchy level members”.

If you are expecting work items with the “Config” but don’t find them, please check the JQL settings of your account. Ensure that they don’t unintentionally restrict the data import. In my case, I avoid importing “Cancelled Issues,” as illustrated in the screenshot below:

Kindly,
Ilze support@eazyBI.com

Hi,
Hope this message finds you well.

Still I am facing the same issue, in every report wherever using the [Work Item type].[Config] causing the issue. I have selected from the hierarchy level members, but that did not help.

In the new account where I am getting error we are using a JQL query to import specific issues as per the JQL.
As per the JQL we are not having any issues with Work Item Type = Config for now, is this causing the issue ? We will have them in future.

Also in calculated member “Config Doc” Work Item Type = CSD also we do not have any issues for now, when we select that as filter it shows no data to show in the report, I am expecting same for the “Config” .

image

Can you please help me on this, once the data with “Config” added in Jira will this error go away?

Hi,

Can this be please checked.

For your further help I am providing the report Definitions of two reports from difference accounts.
Report is one account is working fine for Configuration Activities, but not in other account.
The only different is there is no data in the other account as we restricted particular issues to import as per the JQL as mentioned in the previous comments.

Report Definition#1:

{
“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”:“2023”,“full_name”:“[Time].[2023]”,“drillable”:true,“parent_full_name”:“[Time].[All Times]”},{“depth”:1,“name”:“2024”,“full_name”:“[Time].[2024]”,“drillable”:true,“parent_full_name”:“[Time].[All Times]”}],“bookmarked_members”:,“current_page_members”:[“[Time].[2023]”,“[Time].[2024]”]},{“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”,“drillable”:true}],“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]”],“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”:{},“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”:“Aggregate(\n\t{\n\t\t[Issue Subtype].[(none)],\n\t\t[Issue Subtype].[Integration-Topic],\n\t\t[Issue Subtype].[FCC],\n\t\t[Issue Subtype].[Business],\n\t\t[Issue Subtype].[Change-Impact],\n\t\t[Issue Subtype].[Data],\n [Issue Subtype].[Data Quality],\n [Issue Subtype].[Dependent Initiative],\n [Issue Subtype].[ERC],\n [Issue Subtype].[GAT],\n [Issue Subtype].[ISRM],\n [Issue Subtype].[LAT Query],\n [Issue Subtype].[Master Data],\n [Issue Subtype].[OQT],\n [Issue Subtype].[Others],\n [Issue Subtype].[PQT],\n [Issue Subtype].[S\u0026A],\n [Issue Subtype].[Transactional Data]\n})\n”,“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”:“Aggregate(\n\t{\n\t\t[Issue Subtype].[S/4HANA Eco System],\n\t\t[Issue Subtype].[EDW Report],\n\t\t[Issue Subtype].[Regression],\n\t\t[Issue Subtype].[S/4HANA Report],\n\t\t[Issue Subtype].[S/4HANA Report - EA],\n\t\t[Issue Subtype].[EDW PaPM],\n [Issue Subtype].[R\u0026A]\n})\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”:“Sum(\n {\n–previous periods \n PreviousPeriods([Time].[Day].DateMember("June 23 2023")),\n–actual date\n [Time].[Day].DateMember("June 23 2023")},\n [Measures].[Issues with due date]\n )\n -\n Sum(\n PreviousPeriods(\n–only previous periods\n [Time].[Day].DateMember("July 01 2022")),\n [Measures].[Issues with due date])\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].[MOM - Masters of Material],\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].[N/A],\n[Workstream].[Unmatch],\n[Workstream].[(none)]\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”:“”}]
}

In this above report Configuration Activities calculated member getting error.

Report Definition #2;
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “LDC KPI Reporting – Build Deliverables Completion”,
“folder_name”: “LDC - Build - IT”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Fix Version”,“selected_set”:[“[Fix Version].[Fix Version In order]”],“members”:[{“depth”:0,“name”:“Fix Version In order”,“full_name”:“[Fix Version].[Fix Version In order]”,“calculated”:true,“drillable”:true,“expanded”:true,“drilled_into”:false,“removed”:true}],“bookmarked_members”:},{“name”:“Measures”,“selected_set”:[“[Measures].[Planned]”,“[Measures].[Complete]”,“[Measures].[Complete %]”,“[Measures].[In Review ]”,“[Measures].[In Review/ Completed ]”],“members”:[{“depth”:0,“full_name”:“[Measures].[Planned]”,“format_string”:“#,##0”,“report_specific”:true,“name”:“Planned”,“calculated”:true},{“depth”:0,“full_name”:“[Measures].[In Review/ Completed ]”,“format_string”:“#,##0”,“report_specific”:true,“name”:“In Review/ Completed “,“calculated”:true}]}]},“rows”:{“dimensions”:[{“name”:“Work Item type”,“selected_set”:[”[Work Item type].[Total Developments]”,“[Work Item type].[Functional Specification]”,“[Work Item type].[Configuration Activities]”,“[Work Item type].[Config Document]”,“[Work Item type].[OQS (Test Script)]”],“members”:,“bookmarked_members”:[{“depth”:1,“name”:“Development”,“full_name”:“[Work Item type].[Development]”},{“depth”:1,“name”:“Config”,“full_name”:“[Work Item type].[Config]”},{“depth”:1,“name”:“CSD”,“full_name”:“[Work Item type].[CSD]”},{“depth”:1,“name”:“Design”,“full_name”:“[Work Item type].[Design]”},{“depth”:1,“name”:“OQS”,“full_name”:“[Work Item type].[OQS]”},{“depth”:1,“name”:“S\u0026A”,“full_name”:“[Work Item type].[S\u0026A]”}]}]},“pages”:{“dimensions”:[{“name”:“Issue Subtype”,“selected_set”:[“[Issue Subtype].[Except Data Migration]”],“members”:[{“depth”:0,“name”:“Except Data Migration”,“full_name”:“[Issue Subtype].[Except Data Migration]”,“calculated”:true,“drillable”:true,“dimension”:“Issue Subtype”}],“bookmarked_members”:,“current_page_members”:[“[Issue Subtype].[Except Data Migration]”]},{“name”:“Time”,“selected_set”:[“[Time].[BUILD]”],“members”:[{“depth”:0,“name”:“BUILD”,“full_name”:“[Time].[BUILD]”,“calculated”:true,“drillable”:true,“dimension”:“Time”}],“bookmarked_members”:,“current_page_members”:[“[Time].[BUILD]”]},{“name”:“Functional Domain”,“selected_set”:[“[Functional Domain].[All Functional Domains]”,“[Functional Domain].[Commercial ]”,“[Functional Domain].[Finance \u0026 Procurement]”,“[Functional Domain].[Operations ]”],“members”:[{“depth”:0,“name”:“All Functional Domains”,“full_name”:“[Functional Domain].[All Functional Domains]”,“drillable”:true,“type”:“all”}],“bookmarked_members”:,“current_page_members”:[“[Functional Domain].[All Functional Domains]”]},{“name”:“Workstream”,“selected_set”:[“[Workstream].[All Workstreams]”],“members”:[{“depth”:0,“name”:“All Workstreams”,“full_name”:“[Workstream].[All Workstreams]”,“drillable”:true,“type”:“all”}],“bookmarked_members”:,“current_page_members”:[“[Workstream].[All Workstreams]”]},{“name”:“Complexity”,“selected_set”:[“[Complexity].[All Complexities]”],“members”:[{“depth”:0,“name”:“All Complexities”,“full_name”:“[Complexity].[All Complexities]”,“drillable”:true,“type”:“all”}],“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”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:,“current_page_members”:[“[Release_Version].[All Release_Versions]”]}]},“options”:{“total”:true},“view”:{“current”:“table”,“maximized”:false,“table”:{}},“calculated_members”:[{“dimension”:“Measures”,“name”:“To Be Mapped”,“formula”:“([Measures].[Issues created],[Gap Type].[(none)])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Enhancement”,“formula”:“([Measures].[Issues created],[Gap Type].[Enhancement])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Form”,“formula”:“([Measures].[Issues created],[Gap Type].[Form])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Interface”,“formula”:“([Measures].[Issues created],[Gap Type].[Interface])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Report”,“formula”:“([Measures].[Issues created],[Gap Type].[Report])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Workflow”,“formula”:“([Measures].[Issues created],[Gap Type].[Workflow])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“.”,“formula”:“[Measures].[Issues created]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“FIT”,“formula”:“([Measures].[Issues created],[Fit/Gap Classification].[Fit])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“GAP”,“formula”:“([Measures].[Issues created],[Fit/Gap Classification].[Gap])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Standard Addition”,“formula”:“([Measures].[Issues created],[Fit/Gap Classification].[Standard Addition])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“TBD”,“formula”:“([Measures].[Issues created],[Fit/Gap Classification].[TBD])”,“format_string”:“”},{“dimension”:“Measures”,“name”:“High”,“formula”:“[Complexity].[High]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Very High”,“formula”:“[Complexity].[Very High]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Medium”,“formula”:“[Complexity].[Medium]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Low”,“formula”:“[Complexity].[Low]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“TBD “,“formula”:”[Complexity].[TBD]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Empty”,“formula”:“[Complexity].[(none)]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“In Review/ Completed “,“formula”:”/[Status].[In Review]+[Status].[Completed]+[Status].[Done]/\n\n\n[Measures].[In Review ]+\n[Measures].[Complete]”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Planned OLD”,“formula”:“Aggregate(\n[Time].[Day].DateMembersBetween(‘July 01 2022’, ‘June 23 2023’),[Measures].[Issues with due date]\n\n)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Planned”,“formula”:“Sum(\n {\n–previous periods \n PreviousPeriods([Time].[Day].DateMember("June 23 2023")),\n–actual date\n [Time].[Day].DateMember("June 23 2023")},\n [Measures].[Issues with due date]\n )\n -\n Sum(\n PreviousPeriods(\n–only previous periods\n [Time].[Day].DateMember("July 01 2022")),\n [Measures].[Issues with due date])\n”,“format_string”:“”}]}
} ],
“calculated_members”: [{“name”:“Except Data Migration”,“dimension”:“Issue Subtype”,“formula”:“Aggregate(\n Except(\n [Issue Subtype].[Issue Subtype].Members,\n { \n \n [Issue Subtype].[Data]\n }\n )\n)”,“format_string”:“”},{“name”:“Completed “,“dimension”:“Status”,“formula”:”[Status].[Done]+\n[Status].[Completed]”,“format_string”:“”},{“name”:“Planned “,“dimension”:“Measures”,“formula”:“Sum(\n {\n–previous periods \n PreviousPeriods([Time].[Day].DateMember("June 23 2023")),\n–actual date\n [Time].[Day].DateMember("June 23 2023")},\n [Measures].[Issues with due date]\n )\n -\n Sum(\n PreviousPeriods(\n–only previous periods\n [Time].[Day].DateMember("July 01 2022")),\n [Measures].[Issues with due date])\n”,“format_string”:””},{“name”:“Complete %”,“dimension”:“Measures”,“formula”:“([Measures].[Complete]/[Measures].[Planned ])”,“format_string”:“#0%”},{“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”:“Functional Specification”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Design]”,“format_string”:“”},{“name”:“OQS (Test Script)”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[OQS]”,“format_string”:“”},{“name”:“Fix Version In order”,“dimension”:“Fix Version”,“formula”:“Aggregate({\n[Fix Version].[Version].[Build Sprint 1],\n[Fix Version].[Version].[Build Sprint 2],\n[Fix Version].[Version].[Build Sprint 3],\n[Fix Version].[Version].[Build Sprint 4],\n[Fix Version].[Version].[Build Sprint 5],\n[Fix Version].[Version].[Build Sprint 6],\n[Fix Version].[Version].[Build Sprint 7],\n[Fix Version].[Version].[Build Sprint 8],\n[Fix Version].[Version].[Build Sprint 9],\n[Fix Version].[Version].[Build Sprint 10]\n})”,“format_string”:“”},{“name”:“Config Document”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[CSD]”,“format_string”:“”},{“name”:“Configuration Activities”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Config]”,“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”:“BUILD”,“dimension”:“Time”,“formula”:“Aggregate(\n[Time].[Month].DateMembersBetween(‘Sep 01 2022’, ‘June 30 2023’)\n)\n”,“format_string”:“”},{“name”:“Total Developments”,“dimension”:“Work Item type”,“formula”:“/[Work Item type].[Development]+\n[Work Item type].[Dev EDW]+\n[Work Item type].[Dev Other]\n/\n\nAggregate({\n[Work Item type].[Development Factory-Total],\n[Work Item type].[EDW Development],\n[Work Item type].[Integration Development],\n[Work Item type].[Other Core Developments],\n[Work Item type].[Data Development]\n})”,“format_string”:“”},{“name”:“Other Core Developments”,“dimension”:“Work Item type”,“formula”:“[Work Item Type].[Dev Other]”,“format_string”:“”},{“name”:“Development Factory-Total”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Development]”,“format_string”:“”},{“name”:“EDW Development”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Dev EDW]”,“format_string”:“”},{“name”:“Integration Development”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Dev Int]”,“format_string”:“”},{“name”:“Data Development”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Dev Data]”,“format_string”:“”}]
}

In this above report “Configuration Activities” calculated member not getting any error and report showing data in it.
image

Please let me know in case you need any additional information.

Thanks.

Hi @Amzad

The error is caused by the infinite loop caused by the “Config” member in your Work Item type dimension.

For one account this report works fine, because the “Config” member is imported from your Jira instance.
In the other account, you are using JQL query filters in your import options, that don’t allow the Issues with the “Config” member to be imported, so this member is missing from the Work Item type dimension, so you created it yourself by referencing itself and causing an infinite loop :slight_smile:

To fix this in the account with the error:

  1. Delete the “Config” member from the Work Item type dimension
  2. Adjust the JQL query filter to allow a bigger scope of issues that also would include issues with the work type “Config”.
  3. Run the import.

​Best regards,
​Nauris

1 Like