Forum Stats

  • 3,769,714 Users
  • 2,253,014 Discussions
  • 7,875,157 Comments

Discussions

Essbase report script

Hyp_Learn
Hyp_Learn Member Posts: 327 Blue Ribbon

Hello Everyone,

Can you please advice how to spool data to a file from the report script. I am using the option "Execute in the background" so the output will be spool to a file. I tried giving spool on to "result.txt" but i am getting syntax error. Can you please help. Also i am unable to use "Output file" which runs in foreground as i get timeout and moreover this is a time consuming process so i wanted to run the report extract in the background.

I appreciate any suggestions. Thanks for your valuable time.

Answers

  • Srinivas Bobbala
    Srinivas Bobbala Member Posts: 856 Bronze Trophy

    I suggest to use MaxL to do that; Here is a sample command

    export database sample.basic input data
    to data_file 'exp_input.exp';
    export database sample.basic using report_file "'$ARBORPATH/App/Sample/Basic/asym.rep'" to data_file 'home/month2.rpt';
    
    
    


    Read this for additional details:
    https://docs.oracle.com/cd/E57185_01/ESBTR/maxl_export.html