This content has been marked as final. Show 7 replies
Many things you can check:
Start with "Did you manage to cache the report without ibot?" If yes, then your caching is ok - and you need to look into ibot config.
If not, then check the following
a) does any of the tables used have a "is Caching" property unchecked?
b) Did you check Job Manager?
c) Any security conflicts (filters, groups, SA permissions, etc.)
d) Event-polling table config
In addition of Wildmight, here a list of the reasons why a query is not cached :
Thanks for your replies.
I have checked all these points and everything seems to be OK. I have made further tests and it seems that my problem comes from the fact that in my dashboard page I have a prompt. I thought that my ibot would have calculated the cache with the default value of my prompt but apparently I am wrong.
What I have to do to seed the cache for a dashboard page with a prompt ?
Thanks for your help.
I think these issues are still open.
1. Currently, iBots do not seed Dashboard Pages.
2. Seed the cache with Ibots logging in as a user who is NOT defined in the rpd is not working
You can very well seed dashboard pages but the trick is you ought to select either "Active Delivery Profile" or "Interactive dashboard" added to BI Server cache as the destination when you are creating the Ibot for
seeding the Dashboard Page.
This is a known bug of Oracle which is supposed to get rectified in 11.1... version donno the exact one.
Thank you very much Dhrubo, now it's OK.
I'm running into the same problem which I can't solve. I'm trying to cache a dashboard page using iBots for a group of users rather than a single user. I know that the page will cache if I just access the page so there are no caching properties that need to be adjusted. Here are the details of the iBot:
Receipts: APAC Users Group
Delivery Content: Reginonal Sales Scorecard
Destinations: Oracle BI Server Cache
I know there is a bug if you don't select something in the User Destintation tab in iBot. I have downloaded the patch for this so I don't think that is the issue. If I just select a group only, I can see in job manager that it runs in 1 second and nothing appears in the cache. How is the functionality supposed to work if you only select a group when trying to seed a dashboard page?