Obiee Cache Question

Question

Hi,

In our company, we use obiee 12. There are lots of dashboards and analysis seen by customers. Sometimes, because of obiee cache reports are not refreshed and does not bring latest value.

How can we solve this issue? We thought that we can clear total cache every 6 hours :S Is it a good opinion? Or, do you suggest any other idea?

Thank you for your help.

Regards,

Dilek

[Deleted User] · Answer

Gianni Ceresa wrote:And obviously also what Christian suggested: this is a "per user" approach with users having cache and others not having it.

Per user, per app role...anythng you want

Gianni Ceresa · Answer

dileraco wrote:Here, I understand that deleting cache 6 hours apart is ok for us. That should be our process Right

If 6h is the answer, then go for 6h

In general you start looking at the sources you use for the analysis, you identify how often those changes and get the business owner deciding if they always want to see the fresh data as soon as possible or are happy to have a delay. Based on all the answers you can decide the best strategy: do you purge cache on the BI side at a fixed schedule? Or do you get the source to trigger the purge of the cache?

Many add a purge cache step to their ETL: when all the data is refreshed it's time to purge the BI cache so people see the freshly loaded data. As the ETL is the one knowing when it's over, adding a step there is also a good practice.

There isn't a good or bad way, there just is a worse or better way for your own use case, and you can also have multiple cache management strategies in a single OBIEE. Different rules for different subject areas.

And obviously also what Christian suggested: this is a "per user" approach with users having cache and others not having it.

[Deleted User] · Answer

Alternative approach:

Add a SQL prefix to all the analyses which are being sent out: "SET VARIABLE DISABLE_CACHE_HIT=VALUEOF(NQ_SESSION.CACHE_HIT_FLG)";

Then simply create a session variable CACHE_HIT_FLG which you set to 1 or 0 depending on who runs the analysis - i.e. whether it's being sent out or kept internally.

Done. Easy as pie.