Use the Select by Range dialog box to choose a range of contiguous time periods.
Selection Type box -- Contains the following options for the way newly selected values will affect the current selection:
Select -- Replaces the current selection with new values.
Add -- Adds new values to the current selection.
Keep -- Keeps newly chosen values in the current selection and discards the others.
Remove -- Removes newly selected values from the current selection and keeps the others.
Interval box -- Contains the following options for different types of intervals:
The last -- Selects a specific number of the most recent time periods. When you pick this interval, the Time Periods box contains an At Level box for choosing a level, an Including box for choosing the number of time periods, and a text label indicating the last date currently defined at the selected level.
To date -- Selects all time periods from a particular period to the present. When you pick this interval, the Time Periods box contains an At Level box for choosing a level, a From box for choosing the beginning of the range, and a text label indicating the last date currently defined at the selected level.
A range of -- Selects all time periods between (and including) starting and ending periods. When you pick this interval, the Time Periods box contains an At Level box for choosing a level, a From box for choosing the beginning of the range, and a To box for choosing the end of the range.
Time periods box -- Contains two or more of the following boxes for defining the range.
In hierarchy box -- Lists the hierarchies that are defined for the selected dimension. Select the hierarchy that you want to use.
At level box -- Displays the levels in the Time hierarchy. Select the level you want to use.
From box -- Specifies the beginning of the range when Interval is To date or A range of.
To box -- Specifies the end of the range when Interval is A range of.
Including -- Specifies the number of time periods to include in the range, when Interval is Last.
Script box -- Displays the criteria that will be added to the selection script if you choose OK.
Preview button -- Displays the Preview dialog box, which allows you to examine the change you are considering and lists the dimension values that will be selected if you adopt the change.
Replacing or refining a selection
Copyright © 1984, 2005, Oracle. All rights reserved.