1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Planning Formula Expressions
  4. Cross-References
  5. CrossRef(accountName, prefix)

CrossRef(accountName, prefix)

CrossRef(accountName, prefix) generates a cross reference by adding the specified prefix to each dimension name (except Currency, Period and Year), followed by the specified account. The prefix must be in double quotes.

Calculation Manager Syntax:

[[CrossRef(accountName, "prefix")]]

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")
   "110" = [[CrossRef("5800", "No")]];
ENDFIX

returns the following script:

FIX (Aug, Actual, Working, FY15, P_000, "112") 
   "110" = "BegBalance"->"No HSP_View"->"No Scenario"->"No Version"->"No Entity"->"No Product"->"5800";
ENDFIX