You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Entity in FCCS configurable calc

edited Jun 5, 2018 5:55PM in Financial Consolidation and Close 2 comments

Summary

Syntax rules for using Entity in a configurable calc

Content

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'.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!