OAS : Dashboard Slowness Issue

Sometime we face slowness issue while trying to open any dashboard. Reason behind this When the dashboard list link is clicked, a lot of Catalog object permissions need to be checked. When there are multiple dashboards, the number of operations checking permissions get multiplied - these result in multiple calls back and forth to BI Server, the database, etc., causing slowdown.

Solution : 

Solution is to enable Catalog Cache as follows.

1. Edit <DOMAIN_HOME>/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

2. Enable catalog cache by adding the below tags under Cache section.

<Cache>
...
<CatalogAttributes>
<Enabled>true</Enabled>
</CatalogAttributes>
</Cache>

3. Restart OBIPS(obips1) to reflect the change.

Note:

The same issue resolved in another case for a different root cause by adding the below tag in instanceconfig.xml

<Dashboard>

<CacheBannerList>true</CacheBannerList>

</Dashboard>

This setting would give performance improvement on dashboard menu listing within a user session i.e. first time in a new session, user may see slowness.

But after that within the same session, it would be instantaneous irrespective of how long the session ends.

But there is an implication of it: Any newly created dashboard would not get automatically listed in the dashboard menu until user logs off and logs in again.

Happy Learning !!