Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Working with Oracle BI Views in Oracle BI Answers >

Allowing Users to Change Columns in Requests Using Oracle BI Column Selector View

Use the column selector view to allow users to dynamically change which columns appear in a request. One column selector can be attached to each column in a specific request, and multiple columns (attributes) can be attached to each column selector.

To add or modify an Oracle BI column selector view

1. In Oracle BI Answers, create or modify the request with which you want to work, and then perform one of the following actions:
   • To add a new column selector view, click the Results tab and choose Other Views > Column Selector from the views drop-down list.
   • To edit an existing Column Selector view, click the Results tab, choose Compound Layout from the views drop-down list, and then click the Edit View button for the column selector view.

     The workspace shows the options and settings for the view.

2. Select the Include Selector option for each column that you want a column selector to appear.
3. Type a label for each selector and select a position for the label.

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

4. From the subject area in the selection pane, select the columns you want in the selector.
5. If you want to remove a specific choice from a column selector, click the Delete button.

   To remove all choices, click the Clear Choices link.

6. When you are done, you can save the request with the column selector view.

Related Topics

Overview of Oracle BI Answers

Performing Common Tasks When Working with Oracle BI Views