all I've been reading on the internet and documentation about caches, makes me think that seeding the cache is only useful for running reports, but not Dashboards. Is this true?
I have seeded the cache with one iBot, and if I run the report iit goes to the caché. But if I use the dashboard which contains the report, it does not go to the cache. Could this be because in the dashboard I have 5 prompts which I'm using in the report?
Does the cache work when the dashboard contains prompts used as filters in the report?
I have seen in the forum and blogs the conditions for a query to go to the cache instead of going to the database, and I follow all the rules. But for example, if I have in a dashboard with prompts, a report with the following columns:
Column A, B, C, D
where C is prompted
and D is prompted
what should be the ibot to execute?