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, true)

CrossRef(accountName, prefix, true)

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

Calculation Manager Syntax:

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

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")
   "111" = [[CrossRef("5800", "NoX", true)]];
ENDFIX

returns the following script:

FIX (Aug, Actual, Working, FY15, P_000, "112") 
   "111" = "BegBalance"->"NoXHSP_View"->"NoXYear"->"NoXScenario"->"NoXVersion"->"NoXEntity"->"NoXProduct"->"5800";
ENDFIX