Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

Working with Selections of Data

As you specify which data members to include in an analysis, you create selections of data from the data source. Each selection specifies the criteria for a set of members for a particular column, such as Product or Geography. Each selection consists of one or more steps. A step is an instruction that affects the selection, such as add Product members whose values contain the text "ABC." The order in which steps are performed affects the selection of data. Each step acts incrementally on the results from previous steps, rather than acting on all the members for that column.

You can view these selection steps in the "Selection Steps pane." Steps are created using the following means:

Selection steps can be one of the following types:


When working with selection steps, if you search for members in hierarchical columns that are non-text (for example, date or time), then the search will yield no results.

Creating Selection Steps

You create steps in the "Selection Steps pane," which you can display in various places. The following procedure describes how to create steps in the Results tab.

To create selection steps:

  1. Display the "Analysis editor: Results tab."

  2. If the Selection Steps pane is not visible, then click the Show Selection Steps pane button on the toolbar to display it.

    The pane might also be collapsed at the bottom of the Results tab. Click the plus sign icon to expand it.

  3. For the column whose steps you want to define, click the Then, New Step link.

  4. From the menu, select the option for the step type to create and complete the resulting dialog.

Selection steps are automatically created when you use the right-click interactions (such as Add Related or Keep Only) to refine the selection of data for a particular hierarchical column or attribute column in a view. See "Right-Click Interactions in Views."

After you add selection steps to the analysis, you can go to the "Analysis editor: Results tab" and add the Selection Step view to the analysis. If you add the Selection Steps view, at runtime the user can view the selection steps that are applied to the analysis. For more information about adding the selection steps view, see "Results tab: Selection Steps editor."

Editing Selection Steps

You can edit existing selection steps, as described in the following procedure.

To edit selection steps:

  1. Hover the mouse pointer over the step in the Selection Steps pane and click a button on the resulting toolbar.

    You can perform various tasks such as displaying a dialog for editing the step, deleting the step, or changing the order of the step in the list of steps.

    For a group or calculated item, click its name to display a menu with options for editing and saving.

Saving Selection Steps as a Group Object

If you have created a set of selection steps, then you can save and reuse the set as a group object, as described in "Saving Groups and Calculated Items as Inline or Named."

Working with Selection Steps and Double Columns

If your repository is configured for double columns, then you can create a selection step on a double column. To do so, select the display values for that column and the step is automatically evaluated using the code values that correspond to those display values.

If you use double columns, then use care with the "New Calculated Item dialog." You can include a positional operator in the custom formula for the calculated item, such as $1, which specifies the column from the first row in the data set. When you include a positional operator, the display values cannot be mapped to the code values when evaluating the formula.

For information on double columns, see "Understanding the Double Column Feature."