Analytics Software

Hello,

I have a dashboard page with a pivot table and dashboard prompt. I want to seed the cache for this report for all combinations of data selection. My strategy was to make a copy of the original request from the dashboard. Then with this new request add the possible selection columns to the table object and generate the table for all combinations of data selection. I cannot get the dashboard to use the cached results. The logical SQL for the dashboard pivot shows aggregation that is not in the table request used to seed the cache…but if all columns are available it should be able to use the cache to aggregate. Right??

Can anyone point me to the problem? Does anyone have any advice from experience in seeding the cache?

(I have read the server admin guide and believe I am playing by the rules…as I understand them.)

Thanks in advance!