Cache Management

Cache Management in OBIEE


1. Admin tool Manage > Cache > Purge

You can purge all the cache or cache by Subject Area or Cache by query


2. Physical Layer

Physical Table Properties > Cacheable, Cache persistence time


3 Event Pooling Table


4. EM(Enterprise Manager) > Capacity Management >Performance > Cache Enabled


5. Analysis > Advanced tab > Bypass presentation cache


6. Analysis > Advanced tab >

 Prefix     set variable DISABLE_CACHE_HIT=1;


7. When dynamic variable value changes the cache associated with that subject area purges

8.. Creating a batch file and scheduling it