Forum Stats

  • 3,853,801 Users
  • 2,264,276 Discussions
  • 7,905,450 Comments

Discussions

Export of Data Doubt

Robert Angel
Robert Angel Member Posts: 4,535 Bronze Crown
edited Sep 28, 2018 8:06AM in Planning and Budgeting

Hi,

I use the following to export data from a database in PBCS, it works, but the data exported does not have a consistent number of columns populated, sometimes it exports the 13 periods of content, othertimes the import content just ends.

SET DATAEXPORTOPTIONS
{
     Dataexportlevel "Level0";
       
        Dataexportdynamiccalc off;
        DataexportDecimal 2;
        Dataexportoverwritefile on;
        Dataexportnonexistingblocks off;
        Dataexportcolheader "Period";
        Dataexportcolformat on;
        DataexportDimHeader on;
    };
   

fix({Year},local,basedata,{Scenario}, {Version}, Jan:Dec, BegBalance)

dataexport "File" "|" "/u03/lcm/WorkExportZeroLevel.txt" "#MI";

endfix;

Is there anyway to force it to populate with #MI 'all the way', am I assured that if the data is missing then it is missing because it is not populated and there is no misalignment to the file headings?

i.e. I sometimes get; -

"HSP_InputValue"|"BaseData"|"FY17"|"Forecast66"|"Working"|"Local"|"LE002"|"D110"|"C81010"|"BAR004"|"FIN01"|"A561020"|#MI|#MI|32649.92|466.05|4800.00|4800.00

And sometimes I get; -

"HSP_InputValue"|"BaseData"|"FY17"|"Forecast66"|"Working"|"Local"|"LE002"|"D110"|"C83010"|"No_Project"|"No_Product"|"A541010"|#MI|#MI|#MI|#MI|#MI|#MI|#MI|0.00|14587.91|19494.91|9477.28|18535.56|66352.17

I always want the latter, is there a way or failing that am I assured that #MI will appear when there are columns in the latter end of the year but not the start of the year??

Note Period is dense.

thank you.

Tagged:

Best Answer

Answers

This discussion has been closed.