Essbase: When using @ANCEST Function in calculation script, getting Error(1200370) -Error executing formula for [TestMember] (line 0): attempt to cross a null member in function [@X] (Doc ID 2375469.1)

Last updated on OCTOBER 19, 2023

Applies to:

Symptoms

Using Sample/Basic, create a new member, TestMember, in Measures Dimension.  Running the below calculation returns the error:

Test.csc:

//ESS_LOCALE English_UnitedStates.Latin1@Binary
TestMember=@ANCEST("100-10",1)->Sales;

The application log, Sample.log, shows the following error:

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1098967360/Info(1013163)
Received Command [Calculate] from user [admin@Native Directory] using [Test.csc]

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1098967360/Info(1200481)
Formula for member [TestMember] will be executed in [CELL] mode

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Info(1012675)
Commit Blocks Interval for the calculation is [3000]

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Info(1012717)
Remote bitmap cache is [Disabled]

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Info(1012669)
Calculating [ Measures(TestMember)]

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Info(1012677)
Calculating in serial

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Error(1200370)
Error executing formula for [TestMember] (line 2): attempt to cross a null member in function [@X]

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Warning(1080014)
Transaction [ 0x10006( 0x5aafd848.0xc177d ) ] aborted due to status [1200370].

[Mon Mar 19 15:33:28 2018]Local/Sample/Basic/admin@Native Directory/1083042112/Info(1012579)
Total Calc Elapsed Time for [Test.csc] : [0.016] seconds

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.