1 Reply Latest reply: Nov 12, 2012 1:34 PM by JohnGoodwin RSS

    Essbase 9.3.3 - data export files

    973820
      Hi

      I know when creating exports in Essbase when a file reaches 2gb Essbase will automatically generate a new file of the same and append the extension _1 to the name. I'm trying to find out if there is a way to control where the split happens. At the moment when I open the second file it starts halfway through a data line and then the header row appears about 80 rows down into the file. This means I get issues when trying to load this file into another cube using a load rule.

      These are the settings I have at the top of my export file.

      SET LOCKBLOCK HIGH;
      SET UPDATECALC OFF;
      SET AGGMISSG ON;
      SET NOTICE DEFAULT;
      SET MSG SUMMARY;
      SET CACHE HIGH;
      SET CALCPARALLEL 3;
      SET EMPTYMEMBERSETS ON;
      SET CREATEBLOCKONEQ OFF;
      SET CREATENONMISSINGBLK OFF;
      SET FRMLBOTTOMUP ON;

      SET DATAEXPORTOPTIONS
      {
      DataExportLevel LEVEL0;
      DataExportDynamicCalc OFF;
      DataExportDecimal 6;
      DataExportPrecision 16;
      DataExportColFormat ON;
      DataExportColHeader "Synapse Pipeline Stage";
      DataExportDimHeader ON;
      DataExportRelationalFile OFF;
      DataExportOverwriteFile ON;
      DataExportDryRun OFF;
      };


      Thanks in advance for any help.