Caching in obiee 11g
My requirment has an executive dashboard which has 30 reports on it.This dashboard can be accessed by 1000 users.
My requirment here is when the users open the dashbard page it has to hit the cache and the reports in the dashboard should appear immediatley without taking time.The cache also should be updated daily.
My first queation here is:
1) we dont have any prompts or data security .The report data is same whoever opens the report.So is it fine if we use ibots to clear the cache daily and run the reports for a user and if anyother user opens the dashboard since it is the same reports will hit hit the cache or not?
2) when i tried its not hitting the cache when a different user opens it.Is there a solution where there is a group level cache and users in that group hits the same cache entry.