I have created a BIP report with a simple query which take only 2 seconds to run on Database.
But when i embed that BIP report as a PDF on OBIEE dashboard. It takes 5 minutes to complete.
It is a report with 10000 records. Not sure how to optimize it as the Query takes 2 seconds only and the slowness occurred at the BIP level.
Is there are optimization i can do at PDF generation or at BIP level.