How to improve essbase dataexport performance
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",