Data Export Issue from Essbase to csv

Apr 3, 2017 7:00AM

Summary

Hi all

we have a data export calcscript which will export data from Essbase to csv file, but the col format is incorrect

This is in Essbase

------------------- Jan|Feb|Mar|Apr|May|

Dim1|Dim2|....Dim9 100|101|102|103|104

Exported in csv

------------------- Jan|Feb|Mar|Apr|May|

Dim1|Dim2|....Dim9 #Mi|100|101|102|103|104

here one col is pushing forward and this is happening only for one year FY17, where we are trying to export Fy17,Fy18...Fy20

Set commands used for our

SET UPDATECALC OFF;

SET CACHE ALL;

SET CACHE HIGH;

SET CALCPARALLEL 4;

SET DATAEXPORTOPTIONS