Trigger Cache refresh at OBIEE level

Question

Hi,

OBIEE 12.2.1.0.0

I have some issues with Cache Refresh using Event Polling , I will investigate on that , but meanwhile, I would like to trigger cache refresh after ETL completion (we use ODI)?

I know about  call SAPurgeAllCache(), but,  I have another constraint here.

My DB is on a different server and OBIEE is on an other server! I do not want to reach Unix team for any 'keys' exchange kind of things which is generally performed to allow communication between two Linux servers.

Appreciate your thoughts.

Regards

Hesh

Gianni Ceresa · Answer

Hi,

Have a look at this: https://www.rittmanmead.com/blog/2015/09/managing-the-obiee-bi-server-cache-from-odi-12c/

From ODI and doesn't require to be on the same server.

I guess it was written based on OBIEE 11g, but same thing for 12c.

ArijitC · Answer

OBIEE BI Server's  Web Service can be used to invoke cache purge procedures from any machine . You need to do some configuration on the OBIEE server side though.

It also can be purged with database direct SQL. The solution depends on  how much access you have and how you want to achieve it.

Thanks

Arijit