Export data using Essbase calc script take long time
We have a essbase calc script 1 that export data for 4000 rows (Tabke 20 seconds), then we have another essbase calc script 2 that export 500 rows (But i take more than 20 minutes).
==========
CALC SCRIPT 1:
==========
//ESS_LOCALE English_UnitedStates.Latin1@Binary
SET UPDATECALC OFF;
SET EMPTYMEMBERSETS ON;
/*SET MSG DETAIL;*/
SET CACHE ALL;
SET CACHE HIGH;
SET CALCPARALLEL 7;
SET CALCTASKDIMS 12;
SET DATAEXPORTOPTIONS
{
DataExportLevel LEVEL0;
DataExportDynamicCalc OFF;
DataExportNonExistingBlocks OFF;
DataExportColFormat OFF;
DataExportDimHeader ON;
DataExportRelationalFile OFF;
DataExportOverwriteFile ON;
DataExportColHeader Moneda;
DataExportDryRun OFF;
} ;
/*ANEXO ESTANDAR LIMA*/
FIX(@Relative("Anexo_Estandar",0))
FIX("Local")
FIX(&Pto_Anio1)
FIX("Modificacion_Interna")
FIX(&Ppto_Mod_Interna)
FIX(&Pto_GC/*,&Pto_CC*/)