Forum Stats

  • 3,836,791 Users
  • 2,262,191 Discussions
  • 7,900,111 Comments

Discussions

PBCS data not exported

user10419203
user10419203 Member Posts: 3
edited Feb 1, 2019 11:25AM in Planning and Budgeting

Hi all,

I have a BSO cube of data in my PBCS instance. I am a service administrator. I am trying to export data by creating a job. The export output file contains only the header row. There is no data.  It does not throw any error or no message. It simply completes the job. Where am I going wrong?   I have tried all the combinations of data involved.

Tagged:
Srikanth Grandhe

Answers

  • Jonathan A Cohen
    Jonathan A Cohen Member Posts: 90 Bronze Badge
    edited Jan 31, 2019 2:32PM

    Hard to tell based upon your description.  I would guess that you have one or dimensions that are selected in the job that returns no data.

    I have moved away from data export jobs to business rules because they provide much more control.  I have rules that will export in both CSV and Essbase formats.  The latter can be uploaded into PBCS without editing and are great to backups.

    Note the Data Management can also be setup to export text files and provides more flexibility.  However, I have come across a bug that is preventing me from using it now and Oracle Support is looking into it.

    For CSV export business rule:

    +++++++++++++  CODE START +++++++++++++

    SET EMPTYMEMBERSETS ON;

    SET CACHE HIGH;

    SET LOCKBLOCK HIGH;

    SET COPYMISSINGBLOCK OFF;

    SET UPDATECALC OFF;

    SET DATAEXPORTOPTIONS {

         DataExportLevel LEVEL0;

         DataExportDynamicCalc OFF;

         DataExportNonExistingBlocks OFF;

         DataExportColFormat ON;

         DataExportColHeader Period;

         DataExportDimHeader OFF;

         DataExportRelationalFile ON;

         DataExportOverwriteFile ON;

         DataExportDryRun OFF;

    };

    FIX({Scenario},{Version},{Year})

         FIX(

              "BegBalance",@RELATIVE("YearTotal",0),

              @RELATIVE("Accounts",0),

              @RELATIVE("Entities",0),

             

              /* ADD OTHER DIMENSION FIXES */

             

         )

         DATAEXPORT "File" "," "/u03/lcm/Gold_Data.csv" "NULL";

         ENDFIX

    ENDFIX

    +++++++++++++  CODE COMPLETE +++++++++++++

    For Essbase format, use:

         SET DATAEXPORTOPTIONS {

              DataExportLevel ALL;

              DataExportDynamicCalc OFF;

              DataExportNonExistingBlocks OFF;

              DataExportOverwriteFile ON;

              DataExportDryRun OFF;

         };

  • Sidharda Chava
    Sidharda Chava Member Posts: 124 Blue Ribbon
    edited Jan 31, 2019 4:38PM

    first thing to try to would be

    1, figure out one combination which has data.

    2, try to export only that combination.

    If you really want all data to be exported. Then put periods in column and account in row. then select @relative(dim,0) for all dimensions.

    This will export only level 0 data.

  • user10419203
    user10419203 Member Posts: 3
    edited Feb 1, 2019 12:35AM

    Hi Jonathan,

    I tried the Essbase script. It executed the rule successfully. Please tell me where this output file is saved. It is not available in the outbox folder.

  • Jonathan A Cohen
    Jonathan A Cohen Member Posts: 90 Bronze Badge
    edited Feb 1, 2019 11:08AM

    Inbox/Outbox Explorer.  Application Overview -> Action Button -> Inbox/Outbox Explorer

    Be aware that every time the rule runs, it will overwrite the current file, even if there is no data in the export file.  I have not been able to make the file name dynamic.

    Srikanth Grandhe
  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Feb 1, 2019 11:25AM

    re: I have not been able to make the filename dynamic, you kind of can....

    1. Use a variable to pass the filename in the export script

    2. Use epmautomate to maintain the variable to a name appended with date / datetime / whatever takes your fancy

    3. Use epmautomate at the same time to run the rule and download the file, in that order

    It is not all in the system as I would ideally like, but there is a way....

    Srikanth Grandhe