Hello,

we are experiencing some performance problems with BI Publisher reports.

Since I am not so familiar with BI Publisher, I wonder if this is a matter of correct BI Publisher settings.

This is the behaviour that we noticed after some analyzing of the runtimes:

- we have a dashboard page with 5 BI Publisher reports - one is separate (always displayed), 4 are under 4 different (BI Publisher) tabs

- when we open the dashboard page, all five of BIP reports are loaded (even those on the inactive/not displayed tabs), SEQUENTIALLY - this takes about a minute!

- once the BIP reports are loaded, we are on an active tab - if we switch now to one of the inactive tabs, ALL 5 BIP reports get loaded again! But since the data was now cached, the actual sql/query part takes 0 seconds, but each BIP still takes a few seconds to build/render from that data. So it takes a while to even switch the tabs.

- if we go back to a tab that we already had opened, the switch is almost instant

Here are my questions, if it is possible to change that via settings or fix somehow else:

- Is it possible for BIP reports to load all at the same time, just like a standard dashboard page with multiple analysis reports would?

- Is it possible to change that not all reports get loaded, but rather just those that are currently displayed on the screen? Which would mean that those in non-displayed tabs would not get loaded.

- Why do all 5 reports get loaded again when I change tabs?

- A bit of a separate question, do temp files that begin with xdo and end with .tmp belong to BI Publisher? I am noticing on our filesystem we have a lot of old temp files (some are several months old) like that, that are quite large...

Example:

xdoP4N6XGKAtH1710921179631585974.tmp

xdoyn26GlIt9R5154223478261218658.tmp

Would it be safe to delete these?

Thanks for the help