Use expiration schedules to specify when the data that
is related to your visual project must expire.
About this task
Expiration schedules can be set up to automatically refresh
the data that is called in a visual project. If an expiration schedule
is assigned to a query in a visual project, the query results that
are obtained from the query are saved for the given amount of time
that the schedule dictates. When a user runs the visual report or
dashboard, the query results that are saved in the cache are used
and the query is not rerun. Once the time and date set up by the schedule
is reached, the query results expire, and the next time a user runs
the visual report or dashboard, the query is rerun. Expiration schedules
can save time and database resources by only running queries when
updated data is needed.Note: You can use expiration schedules only
for the visual projects that are saved to repository.
To
create a new expiration schedule:
Procedure
- The Expiration Schedule Configuration wizard
can be opened in one of the following ways:
- From the Project Explorer view, expand
the Globals node. Right-click the Expiration
Schedules node. Select Insert Schedule from
the pop-up menu. The Expiration Schedule Configuration wizard
opens.
- From the Project Explorer view, expand
the Globals node. Double-click the Expiration
Schedules node. The Expiration Schedule Configuration wizard
opens.
- Enter a name for the expiration schedule in the Schedule
name field
- Select how often the schedule expires in the Data
expires radio group. Valid choices are:
- hourly to have the schedule expire every
hour.
- daily to have the schedule expire every
day.
- weekly to have the schedule expire every
week.
- monthly to have the schedule expire every
month.
- at specific date to have the schedule expire
only at a specific date.
- never expires to never have the schedule
expire. The same query results will be used every time the project
is run.
- always expired to always have the schedule
expired. The query results will never be saved and the query will
be rerun every time the project is run.
- after the visual project is closed to have
the schedule expire after you close the visual project.
- If you selected never expires or always
expired, click Finish.
The Expiration Schedule Configuration wizard
closes and the new expiration schedule is saved under the Expiration
Schedules node in the Project Explorer view.
- If you selected any of the other options, click Next.
The Set schedule properties page
of the Expiration Schedule Configuration wizard
is different depending on your selection.
- Specify the Set schedule properties options
and click Finish.
The Expiration
Schedule Configuration wizard closes and the new expiration
schedule is saved under the Expiration Schedules node
in the Project Explorer view.