OBIEE Cach size Filled up?

Question

BI Folks,

1. I am wondering what will happen if the cache files reached the maximum size for the settings mentioned in nqsconfig I.e 200 MB.

2. How often the cache will files will be removed I set the cache never expires in the physical layer. I have seen restarting the server does'nt clear files in the backend servver ( .tbla files.

thanks,

thi rural

rmoff · Answer

1. It will start to delete the entries that have been least-recently-used (LRU)

2. Either when you purge the cache manually in the admin tool, use an ODBC command to purge it, use EPT; or when you deploy an RPD that's got changes not compatible with the current entries in the cache. Setting cache entries to never expire is only really valid if your data never changes - which is probably unlikely.

This article might help clarify things for you: OBIEE BI Server Cache Management Strategies - Rittman Mead Consulting