Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PBCS Export Dynamic Calc - Essbase Error(1200494): Error executing formula for xxx: Recursion limit

MatteoBarlassinaFeb 22 2018 — edited Feb 23 2018

We build this simple script that point to a simple slice (note that the first fix is at lev0 members) :

SET DATAEXPORTOPTIONS

{

DataExportLevel ALL;

DataExportDynamicCalc ON;

DataExportDecimal 4;

DataExportPrecision 4;

DataExportOverwriteFile ON;

DataExportColFormat ON;

DataExportDimHeader ON;

DataExportOverwriteFile ON;

DataExportColHeader "Period";

};

FIX("33701789", BDG,FY18,"Working_1" ,"NO_CUSTOMER","Local","EUR", "55_20" ,jan,"DS_Chain")   

FIX("2128F_LFG", "2128_CFG" )

      DATAEXPORT "File" ";" "/u03/lcm/00_Export_MANAGERIAL_PIVOT.txt";

ENDFIX

ENDFIX

We try to export both 2128_CFG (Dynamic calc parent) and 2128_CFG (never share child)

Rule goes in error with error message: Cannot calculate. Essbase Error(1200494): Error executing formula for [A_Calculated_Price_DC] (line 21): Recursion limit [128] reached

We remove the dynamic calc and the rule works

This let us think that in PBCS is not possible to export Dynamic Calc members

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2018
Added on Feb 22 2018
8 comments
1,025 views