Automation of BI server and BI Presentation server cache in OBIEE 11g

2844292

Hi Experts ,

My current OBIEE 11.1.1.7 environment is a cluster, it has 4 node cluster . I want to clear the BI server cache and Presentation server (Close All Cursors ) cache  every 12 hrs .Actually total no of users are around 250 users per day, This is the average users are using BI system every day . Some times users are complaining that still they are seeing stale data, instead of real-time data .So i want to automate the cache script that ensure it clear all BI server which means RPD and BI Presentation server which is Close All Cursors in Analytic page .

Please suggest that how can i do this .If i want to achieve what all i need to do . Please advice .

Thanks for your help in advance .

Thomas Dodds

If your users REALLY want real-time data - disable all cache ...

You can run a script to purge the cache at any interval you want ... simple Google search reveals plethora of approaches.

rmoff

Why not purge your cache when the data changes, rather than some spurious schedule?

Have a read of this: OBIEE BI Server Cache Management Strategies - Rittman Mead Consulting

2844292

Thank you for your suggestions ...

Still am having some doubts .. if i have a automate cache script which is CALL SAPURGEALLCACHE() . If i schedule this batch script file will it be automatically clear Close All Cursors in BI presentation server ??

Once this CALL SAPURGEALLCACHE() procedure schedule automatically will it take care clearing Presentation and Server cache ?? Please clarify.

Thank  your support

rmoff

SAPurgeAllCache clears the BI Server cache only.