Syntax Issue With Cross Join Formula - Essbase (Doc ID 2190737.1)

Last updated on MARCH 08, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.0.00 and later
Information in this document applies to any platform.

Symptoms

Syntax issues when executing a custom ASO calculation script which attempts to move data from source to target.

Execute calculation on database app.db 
  2> With Local Script_file "d:/Copy_Actuals.txt"
  3> SOURCEREGION "({([Actuals])})"
  4> TARGET "([Oct Fcst Data])"
  5> POV "crossjoin({[Jan]:[Sep]}
  6> ,crossjoin({([&currActualYr],[MTD],[local])},
  7> crossjoin(Descendants([Total Entities],[Entities].levels(0)),
  8> crossjoin(Descendants([BS Accounts],[Accounts].levels(0)),
  9> ({[Cost Center].levels(0).members}),({[Division].levels(0).members})
  10> )))))";

  ERROR - 1260052 - Syntax error in input MDX query on line 5 at token ',' .
  ERROR - 1241190 - Custom Calculation terminated with Essbase error 1260052 in POV.


MAXL> Execute calculation on database app.db 
  2> With Local Script_file "d:/Copy_Forecast.txt"
  3> SOURCEREGION "({([Forecast])})"
  4> TARGET "([Oct Fcst Data])"
  5> POV "crossjoin({[Oct]:[Dec]}
  6> ,crossjoin({([&currActualYr],[MTD],[local])},
  7> crossjoin(Descendants([Total Entities],[Entities].levels(0)),
  8> crossjoin(Descendants([BS Accounts],[Accounts].levels(0)),
  9> ({[Cost Center].levels(0).members}),({[Division].levels(0).members})
  10> )))))";

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms