HI,
OBIEE 12.2.1.0.0
We are using event pulling tables to purge cache, we do manual inserts into BI12C_BIPLATFORM.S_NQ_EPT as a last step of our daily ETL.
I can find entries in BI12C_BIPLATFORM.S_NQ_EPT at 6.20 am today, but when I run the dashboard it was pointing to old data.
when I verified BI12C_BIPLATFORM.S_NQ_ACCT for usage tracking first query was logged at 6:200 and hit the cache .
There were no issues earlier, this is just happening last couple of days .
Where can I find somewhere in the logs when my cache is purged?
Appreciate your help.
Thanks
Hesh