IMPROVING SPECIFIC REPORT PERFORMANCE

OBIEE 11g analysis has query performance option to “Share query with multiple users”

BiCoach Tip: This option is more to do with BI Presentation Server Cache. This has no impact on settings saved for BI Server Query Cache.

To enable this option,

* Analysis’ Advanced tab

* In the bottom of the page select “Share query with multiple users (may improve performance after initial run)

* Click “Apply” and save your analysis.

DISABLE CACHE FOR A PARTICULAR REPORT

Hi Friends,

This will be a quick post – Let’s say we have a requirement where we want to disable caching only at the Report Level, i.e to say – for a specific Report, we don’t want to refer to Cache.

Simply,

• Go to advance tab,

• In the prefix section, paste SET VARIABLE DISABLE_CACHE_HIT=1;

• click on apply button,

• save your report.

Didn’t I say – this is going to be a quick post  :)