[SOLVED] How to export multiple months into RDBMS from Essbase and not have it stored as separate columns

How to export multiple months into RDBMS from Essbase and not have it stored as separate columns

I'm currently working on a script to export a BSO essbase cube into a RDBMS and running into issues with the export. Whenever I select May and Jun together it comes in as 2 different columns instead of just 1 column called ESS_PERIOD.

Does anyone know how to have the month field (ESS_PERIOD) come in as 1 column? **Script is below

SET LOCKBLOCK HIGH;
SET UPDATECALC OFF;
SET CALCPARALLEL 3;
SET FRMLBOTTOMUP ON;
SET CALCTASKDIMS 2;
SET CACHE HIGH;


SET DATAEXPORTOPTIONS 
{ 
DataExportLevel LEVEL0;
/*DataExportDimHeader ON;*/
DATAEXPORTCOLFORMAT ON;
DATAEXPORTDECIMAL 2;
DataExportOverwriteFile ON;
DataExportDryRun OFF;
DataExportDynamicCalc OFF;
};


FIX (
        /*@Relative("Direct Margin", 0),*/
       /*"Direct Margin",*/
    @Relative("Custom4", 0),
         @Relative("Territory",0),
        @Relative ("Entity",0), 
        @Relative("ProductFamily",0), 
        @Relative ("RETL",0),
         "No_CC",
        @Relative ("customer", 0),
         "FY17",
         "Actual",  
         "USD",
       "May" ,
       "Jun"
)

                    DATAEXPORT "DSN" "DB" "TABLE" "USERID" "PW";

ENDFIX

Solution

dataexport always put one of dense dimension to column

you need to create fake dimension with one member - put it on the dense place and use it column set definition in dataexport set command