I. Overview
1. Version
Report server version |
---|
11.0 |
2. Problem description
In the user's actual usage scenario, the default parameters of some templates change every day, such as today()-1. At this time, the first visit of the day will still be slow to fetch data.
3. Solutions
The cache is generated in advance through task schedule and the extracted data cache function, so that the template with dynamic parameters will not be fetched slowly when it is accessed for the first time on the same day.
II. Example
1. Configure caching for template datasets
For details, please refer to: Section III.4 of the Extracted Data Cache Introduction.
2. Generate the specified parameter cache regularly
Note: For the specific setting steps of task schedule, please refer to: Task Schedule Setting
1) The template parameter does not contain the fine_username parameter
Enter the decision-making platform as an administrator, click Manage > Task Schedule, add a new task schedule, select the corresponding cache template, and set the corresponding parameters, such as: =today()-1,you can pass the date of the previous day as a parameter into the cache. As shown below:
In the "Scheduling Cycle" step, set the start time before the cache timing update time, as shown in the following figure:
In the "File Process" step, select the processing method as Timed calculation, and save the task schedule. As shown below:
When the start time of the scheduled task is reached, a cache of dynamic parameters will be generated. As shown below:
2) Template parameter contains fine_username parameter
Enter the decision-making platform as an administrator, click Manage > Task Schedule, add a task, and select the user who needs to generate a cache in the "Basic Settings" step, as shown in the following figure:
In the "Dispatcher Object" step, check "In addition to the general results, members of the default user group will receive individual results", as shown in the following figure:
In the "Scheduling Cycle" step, set the start time before the cache timing update time, as shown in the following figure:
In the "File Processing" step, select the processing method as timing calculation, and save the timing scheduling task. As shown below:
After reaching the start time of the scheduled task, each user generates its own cache separately. As shown below: