Hi Friends,
Cache on OBIEE server is not cleared on a daily basis before each new load.
As a consequence, if a query is not cleared by users and if they do change it, A user query will return the same value from a day to another even if new data have been loaded.
User will not get the latest updated result when they run a query.
Please suggest how can we clear the cache on a daily basis before new data load happens.
Thanks,
Kumar