E.3 Export

The shell script file bsp_forecastset_export.sh is available under the <FIC_DB>/bin folder. This file can be executed for exporting the dimensions and forecast set cash flow results.

This shell script file can be executed directly from a putty session or creating an ICC batch in the application.

1. Execution from Putty session:

   Navigate to <fic_db>/bin folder and execute the following statements:

   ./bsp_forecastset_export.sh <infodom name> <forecast_set_id>

   Example: ./bsp_forecastset_export.sh OFSBSPINFO 200275

   Figure E-1 Export Dimensions using Putty Session

   
   

   

   
   

   Figure E-2 Export Dimensions using Putty Session

   
   

   

   
   
2. Execution using ICC batch:
   Batch Creation:

   1. Navigate to Common Object Maintenance > Operations > Batch Maintenance screen and click on the “Add” link for adding the new batch definition.
   2. Provide the all necessary details in the “Batch Maintenance” popup screen and click on the Save button.
   3. Select the new batch definition in the “Batch Name” grid.
   4. Click on the “Add” link in the “Tasks Details” grid for adding the task details. Provide the following details in the “Task Definition” popup screen and click on the Save button.

      Components: RUN EXECUTABLE

      Executable: bsp_forecastset_export.sh,<Infodom Name>,<Forecast set id>

      Example: bsp_forecastset_export.sh,OFSBSPINFO,200275

   Batch Execution:

   1. Navigate to Common Object Maintenance > Operations > Batch Execution screen. Select the new batch definition in the “Batch Details” grid and also provide the date and click on the “Execute Batch” button for executing the batch.

      Note:

      The selected date is not used anywhere so it can be any date.
   This batch execution will export the dimensions and forecast set cash flow results.

   Note:

   <ftpshare>/logs/bsp_export_log.log file can be referred for detailed log information’s.