Obiee Cache Question — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Obiee Cache Question

Received Response
12
Views
5
Comments
dilek
dilek Rank 6 - Analytics Lead

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

Answers

  • Hi Dilek,

    This is what you get with cache: before to enable cache, one must have a cache management strategy in place.

    Turn off cache and no problem anymore. If you want to keep cache on, you must define a process fitting into your current processes and workflow, depending on the sources etc. to define when and how to purge cache.

  • dilek
    dilek Rank 6 - Analytics Lead

    Thank you. Turning off cache is not a solution of course But since I do not know the correct way, I just want to learn how to go on. Here, I understand that deleting cache 6 hours apart is ok for us. That should be our process Right

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • 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]
    [Deleted User] Rank 2 - Community Beginner
    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