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