Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BI Publisher Report Parameters Performance Issues — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher Report Parameters Performance Issues

Received Response
5
Views
1
Comments
edited Aug 17, 2021 7:50AM in Reporting and Analytics for SCM 1 comment

Content

Hi,

We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL Date.

In order to establish a dependency between these parameters , we have enabled Refresh other parameters on change" option on most of the parameters. But with this option, the main area that is required to show the parameters is taking

time i.e. around 10-15 secs. If  we remove the dependency between parameters then the performance is much better and the results are returned in couple of seconds.

 

Has anyone faced this issue. If so, then how to handle this with the "Refresh other parameters on change" option enabled.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!