Use this dialog box to set the date and time of the first materialized view refresh, and to set the interval for subsequent refreshes.
Refresh on date at time
Refreshes the dimension or cube once at the scheduled date and time.
Refresh every n days at time
Refreshes the dimension or cube on a regular interval of one or more days.
Refresh every n weeks on day at time
Refreshes the dimension or cube on a particular day of the week at regular intervals of one or more weeks.
Refresh every n months on day n at time
Refreshes the dimension or cube on a particular day of the month at regular intervals of one or more months.
Refresh every n months on the n day of the month at time
Refreshes the dimension or cube on a particular day of the week at regular intervals of one or more months.
Edit the Start With expression
Displays the function that defines the current schedule. You can modify the current schedule by editing the expression displayed in the box.
Start With Datetime
Displays the date and time of the first refresh as currently defined.
OLAP Expression Syntax: Analytic Functions
Copyright © 2003, 2007, Oracle. All rights reserved.