0 Replies Latest reply: Aug 29, 2013 11:48 AM by hyp big bee RSS

    Hyperion SQR production reporting 11.1.2 performance after migration from Peoplesoft

    hyp big bee

      Hi,

      I am provided with sqr report includes multiple select statements but with simple small joins and also have reference to standard sqc files and other sqc.

      I installed SQR on AIX and database as oracle 10g.But now hyperion does not provide any sqc file.

       

      So manually created all sqc.But the report is taking more than 4 hours to produce the output file.Previously users get it in 10 minutes as informed.

      Kindly help and suggest how to improve the time,