Hello All,

I have a doubt regarding the cache.

There is an Dim_employee table in my physical layer of .rpd.

In the general properties of the employee table we have a setting called "Cache Persistence time" = 8 hrs

Whenever we have created a report out of that Dim_employee we can see rpd cache against it (by opening the rpd online mode).

Now,

I have created a repository dynamic variable (cache_pruge_test) which refresh at 5 min based on current date/time.

I have also created logical column (in the BMM of Dim_employee) which is taking data from the repository dynamic variable(cache_purge_Test).

But my question is does it purge the cache of rpd. I guess no, as cache persistence time is set.

But as per the oracle doc it should be purged

OBIEE 11g - How To Purge / Clear the BI Server Cache Using a Dynamic Repository Variable (Doc ID 2057123.1).

Kindly let me know if I have to do some setting or is my understanding is correct that if Cache Persistence time is set, then only way to purge the cache is by manually.

Thanks for your help