Entity in FCCS configurable calc
Summary
Syntax rules for using Entity in a configurable calcContent
Hello,
We've got alternate hierarchies set up in our entity dimension and I'm getting a syntax error in a configurable calc when I'm trying to reference data from another entity while consolidating a particular entity. The base logic looks like this:
IF(@ISMBR("Entity 1"))
"Movement Member 2" = "Entity 2"->"Movement Member 1";
END IF
Because "Entity 1" and "Entity 2" are in a primary hierarchy and then two other shared ones, I get this error when attempting to validate the rule:
A validation error was received from the Planning server.
'Error:Unable to resolve duplicate member name ["Entity 1"] on line [51] Rule XXXX.Consol.FCCS_110_After Opening Balance Carry Forward_LocalCurrency'.
0