cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with report running in production

monishasandra
Explorer
0 Kudos

Hi all,

We have created a report with 74 objects which belongs to 32 tables in which some of them are derived tables. In dev environment we didnt face any problem with refresh of teh report even after running the report for the period of 2 years.

But while transporting to production we are facing critical issue with report refresh its taking 7 mins of time to run for 5 days and didn't running atleast for the period of a month.

Please help us on resolving this.

Regards,

moni

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Moni,

Do your report uses any comeplex functions on derived tables?

Is all the indexes are enabled for the tables and the derived tables keys?

Regards,

madhu

monishasandra
Explorer
0 Kudos


HI madhu,

checked all the indexes and missed indexes had given now, but then report is not running...

derive tables contains complex logics like stingagg() and groupby functions.

regards

Former Member
0 Kudos


if so try to create all the objects in a single derived table using inline query or try to reduce number of tables (if business permits)

Regards

madhu

Answers (0)