Use Deliveries to Seed the Query Cache

You can configure deliveries to seed the Oracle Analytics Cloud query cache.

Seeding the cache can improve response times for users when they run analyses or view analyses that are embedded on their dashboards. You can accomplish this by scheduling deliveries to run requests that refresh this data.

1. In Oracle Analytics Cloud, open the Classic Home page, and select Delivery (Create section).
2. On the General tab, select Recipient for the Run As option. Personalized cache seeding uses the data visibility of each recipient to customize delivery content for each recipient.
3. On the Schedule tab, specify when you want the cache to be seeded.
4. Optional: Select Condition and create or select a conditional request. For example, you might have a business model that determines when the ETL process is complete. You could use a report based on this business model to be the conditional trigger for the cache seed to begin.
5. On the Delivery Content tab, select an individual request or an entire dashboard page for which you want to seed the cache. Selecting a dashboard page can save time.
6. On the Recipients tab, select individual users or groups to be the recipients.
7. On the Destinations tab, clear all user destinations and select Oracle Analytics Server Cache.
8. Save the delivery by selecting the Save button in the upper-right corner.

The only difference between cache seeding deliveries and other deliveries is that they clear the previous cache automatically and don't appear on the dashboard as alerts.

Note:

Cache seeding deliveries only purge exact match queries, so stale data might still exist. Ensure that the caching strategy always include cache purging, because delivery queries don't address ad-hoc queries or drills.