This discussion is archived
0 Replies Latest reply: Aug 29, 2013 9:48 AM by hypbigbee RSS

Hyperion SQR production reporting 11.1.2 performance after migration from Peoplesoft

hypbigbee Newbie
Currently Being Moderated

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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points