How can the management of the cache made? | OBIEE

It could split in three distinct ways: in the first case we can disable the cache of the server by setting a parameter to NO from the NQConfig.INI file and then a restart of the server. This method will stop the queries from updating or using the cache. In the second case we can adjust the cache at every physical table from the general settings where we will find the “Make cacheable” option. In this way the queries will be able to use the cache and update it. In the third case event polling data table is used to keep an eye of the updates made on each table.