Got Infinite loop error when add a member of customfield onto [Measures]

We have a customfield call [Incident Category]. This customfield has some members like [Incident Category].[Data Platform], [Incident Category].[Prod-eng], [Incident Category].[ITX] and etc. All the options are ok except the [ITX]. I got the error message below when I added [Incident Category].[ITX] to [Measures].[test].

mondrian.olap.fun.MondrianEvaluationException: Infinite loop while evaluating calculated member ‘[Incident Category].[ITX]’; context stack is {([Incident Category].[ITX]), (), ([Incident Category].[ITX]), (), ([Incident Category].[ITX]), (), ([Incident Category].[ITX]), (), …

You can get infinite loop with calculated member if the calculated member address itself. For example, it could address to itlsef directly, or it could be included in some subset, for example, when you use AllMembers function of the dimension.

For example,
You can create a calculated member BB to address any other member of the dimension except member AA:
Aggregate(
Except(
[Incident Category].AllMembers,
[Incident Category].[AA]
)

The usage of AllMembers in the formula above will lead to infinite loop. The new calculated member BB is a member of function AllMembers.

You would like to address members of a particular level or all default members with function Members. This should work as expected:
Aggregate(
Except(
[Incident Category].[Incident Category].Members,
[Incident Category].[AA]
)

There could be some other cases as well. You would like to share a report definition for more details.

Daina / support@eazybi.com

Thanks Daina,
It probably is not the case regarding AllMembers.
Here is the report definition.

{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Test for infinite loop error”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Issues created]","[Measures].[Alex Cheng test 4]"],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“Issue”,“selected_set”:["[Issue].[All Issues]"],“members”:[],“bookmarked_members”:[]}],“nonempty_crossjoin”:true},“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”:“Incident”,“full_name”:"[Issue Type].[Incident]",“parent_full_name”:"[Issue Type].[All Issue Types]"}],“bookmarked_members”:[],“current_page_members”:["[Issue Type].[Incident]"]}]},“options”:{},“view”:{“current”:“table”,“maximized”:false,“table”:{}}}
} ],
“calculated_members”: [{“name”:“ITX”,“dimension”:“Incident Category”,“formula”:"([Incident Category].[ITX])",“format_string”:""},{“name”:“Alex Cheng test 4”,“dimension”:“Measures”,“formula”:"[Incident Category].[ITX]",“format_string”:""}]
}

Actually, I doubt it could be some issue from Jira but just don’t know how to confirm.

When using [Incident Category].[ITX] in page, got the same error.

You have a calculated member with the name ITX and using as a formula the member with the same name.

  1. delete this calculated member if you have a default member with the member name ITX. Remove this selection from pages selections before doing so.
  2. update the formula of this calculated member to address any other default calculated member if you do not have a default member with the name ITX

Daina / support@eazybi.com

Oh, Daina,
Thank you so much. It works.

Seconding that, thank you @daina.tupule! I raised a support case with your team about this earlier today, feel free to close that up on your end :slight_smile: