Allocation for Multiple entities without Hardcode

4:39PM

Summary:

Hi All,

I am trying to write an FCCS calculation script to perform an allocation for a specific set of entities without hardcoding entity names.

Requirement:

For a selected group of entities (around 160 entities), the calculation should be:

FIX (All Other Dimension)
SET HYBRIDBSOINCALCSCRIPT NONE;
SET IGNORECONSTANTS TRUE;
"No Multi GAAP"
(

IF (@ISMBR (Hardcode 160 Entities))

Data Source 1 -> Multi GAAP 1 = (Data Source 2 -> Multi GAAP 2) / FX Rate of the same entity;

ENDIF

)

ENDFIX

Constraint: I do not want to hardcode all entity names in an IF condition, as the list is large and may change in future.

I tried using @MATCH with wildcards, but it did not work as expected, got run time error, "Wrong String":