CrossRef(accountName)
CrossRef(accountName)
generates a cross reference by adding the default prefix of No to each dimension name (except Currency, Period and Year), followed by the specified account.
Calculation Manager Syntax:
[[CrossRef(accountName)]]
Example:
Assume the application has the following dimensions: Account, Period, HSP_View, Year, Scenario, Version, Entity, and Product. In this example, the following syntax:
FIX (Aug, Actual, Working, FY15, P_000, "112")
"120" = [[CrossRef("5800")]];
ENDFIX
returns the following script:
FIX (Aug, Actual, Working, FY15, P_000, "112")
"120" = "BegBalance"->"No HSP_View"->"No Scenario"->"No Version"->"No Entity"->"No Product"->"5800";
ENDFIX