Hyperion Essbase (MOSC)

MOSC Banner

Export data using Essbase calc script take long time

edited Mar 28, 2017 3:11PM in Hyperion Essbase (MOSC) 2 commentsAnswered

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(@children("Anio_Total"))

FIX(&Pto_Anio1)

FIX("Modificacion_Interna")

FIX(&Ppto_Mod_Interna)

FIX(&Pto_GC/*,&Pto_CC*/)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center