BIP report working fine for admin login but exceeding time limit for user login

Question

Summary:

We have a BIP report that delivers report within 2 minutes for admin login but when HR specialist (user) logs in to run the same report, it exceeds time limit

Content (please ensure you mask any confidential information):

The report is a payslip report. Its single data model fetches bank detail, citizenship, employment details given 1 person as parameter.

It has sub queries in from clause, each fetching details for just 1 person within about 30 seconds,  and the main clause gets employee level information, again, for the same person.

The sub queries as well as the main queries use secured_list views at assignments and per_all_people_f level, and get just 1 person. THe data model fetches for 1 person and the report has a html template.

The main issue is that for admin login the report delivers within about 40 seconds, but for user login, it takes more than 6 minutes and displays timeout error.

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):

Shankar-Oracle · Answer

Please check whether there are any tuning opportunities that exist for this report.

You can check this by clicking on the "Validate" button while editing the data model.

Some times the system might retrieve the results for one user, but for the other users it may timeout. This is due to sub-optimal tuning. Over the time, even the user for whom it is working would get start seeing time out. Likely underlying cause is sub-optimal tuning. Please review "Validate" button results and start working on tuning.