Hyperion Planning (MOSC)

MOSC Banner

How to improve essbase dataexport performance

edited Sep 13, 2016 5:00AM in Hyperion Planning (MOSC) 5 commentsAnswered

Hi gurus, I have a calc script to export data in Essbase. I tested it into my test enviroment and the calc script works fine and fast with big data. Then I tested the same calc script into my production enviroment with few data and it take long time to export. I have executed the RDA in order to diagnostic the performance. I have attached the RDA files. Please if you can help me I really appreciate that.

My calc script is:

SET DATAEXPORTOPTIONS

{

DataExportLevel LEVEL0;

DataExportDynamicCalc OFF;

DataExportColHeader Moneda;

DataExportRelationalFile ON;

DataExportOverwriteFile ON;

} ;

FIX(&Pto_Anio1,"Aprobado",&Ppto_Institucional,&Pto_CC,"HSP_InputValue","Local","RE_002",

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