Cache Purging in OBIEE 11G

Sometimes we will face issue like data miss-match.

It might be because of cache.

We can use Call SAPURGEALLCACHE() function to purge the cache in OBIEE 11g.

Steps:

Click on Administration:

Click on Issue SQL in Administration page:

Write Call SAPURGEALLCACHE() Function and Click on Issue SQL:

You can see the Result Message as Succeeded.

Happy Learning !!!!!!

Cache Purging in OBIEE 11G

Sometimes we will face issue like data miss-match.

It might be because of cache.

We can use Call SAPURGEALLCACHE() function to purge the cache in OBIEE 11g.

Steps:

Click on Administration:

Click on Issue SQL in Administration page:

Write Call SAPURGEALLCACHE() Function and Click on Issue SQL:

You can see the Result Message as Succeeded.

Happy Learning !!!!!!