Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Allowing Users to Change Columns in Analyses (Column Selector View)

Use the Column Selector view to allow users to dynamically select columns to change the data that appears in an analysis. A column selector is a drop-down list that contains preselected columns. In a Column Selector view, you can attach one column selector to each column in an analysis, and you can attach multiple columns (attributes) to each column selector.

To edit a Column Selector view

  1. If the view is not already in the compound layout, then add the view.

    For instructions on adding views, see Adding and Editing Views.

  2. In the Results tab of the analysis, click the Edit View icon for the column selector view.

    The Column Selector view editor opens.

  3. Select the Include Selector check box for each column in which you want a column selector to appear.
  4. To attach a new attribute to a column selector:
    1. Select the column to which you want to attach the attribute.
    2. In the Subject Areas pane, double-click the name of the field for the attribute

      NOTE: When you attach attributes to a column selector in this way, the attribute columns are not added to the analysis in the Criteria tab. Instead, when you display the Criteria tab, you see that the column is now referred to as a column group, with the default column for the list shown. The default column is the one on which you created the drop-down list.

  5. Enter a label for each selector.

    NOTE: If you do not enter a label, users viewing the results will not see a label on the selector.

  6. In the toolbar, in the Label Position field, select a position for the labels.
  7. If you want results to be refreshed as soon as a user selects any new choice from a column selector, then select the Automatically refresh when a new column is selected check box in the toolbar. If you deselect this check box, then users see an OK button next to the column selectors, and must click OK to see the new results.
  8. When you finish making changes, click Done to close the Column Selector view editor.
  9. Save the analysis.

Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.