Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Adding Column Filter Prompts

A column filter prompt allows users to select values to filter a column in a report. You can define the range of possible filter values and how the user selects the filter values for the report.

Column filter prompts appear on the Define Prompts page. When you have multiple column filter prompts constructed for a report, they are presented to the user one at a time, in the order they are listed, from top to bottom.

To add or modify a column filter prompt

  1. In Siebel CRM On Demand Answers, select a report to which you want to add a column filter prompt, and then navigate to the Define Prompts page.
  2. From the Create Prompt drop-down list, select Column Filter Prompt.

    The Prompt Properties dialog box appears.

  3. Enter a caption for the column filter prompt in the Caption box.

    The caption will appear to the user.

  4. Enter a description in the Description box (optional).
  5. From the Filter on Column drop-down list, select the column in the report that you want to filter, and then, from the Operator drop-down list, select the operator to use.

    If you want the user to select the operator, select the operator *Prompt User.

  6. Specify how the user should select values by clicking the appropriate option.

    Users can select values from a drop-down list, or browse through choices and enter them into a text box.

    NOTE: A maximum of 1000 values are permitted if selected from a drop-down list.

  7. To allow the user to select only one value for the column filter prompt, select the Single Value Only check box.
  8. Under the What values should be shown to the user item, select one of these options:
    • To show no values, click None.

      The user will need to enter the value.

    • To show all possible values, click All Values.
    • To show a subset of values, click Filter Limited Values.

      Limiting values is useful when prompting for multiple columns, or when the results already contain a filter. It prevents a user from choosing values that would result in no data. For example, suppose a report contains a country column and a city column, and already contains the filter Country=France. By selecting limited values for the city column filter, the choices are constrained to cities in France only, which prevents the possibility of choosing mutually exclusive filters, such as Country=Italy and City=Paris. Limiting values may require more time to process the prompt compared to the two other options.

  9. Make selections for the options in the Other options area:
    • To allow the user to constrain the filter choices, select the Allow user to constrain choices check box. If this checkbox is selected, the users are presented with a picklist where they can use conditions (such as begins with, ends with, and contains) to constrain the choices.

      Constrained choices help the user locate the values to use as a filter. For example, if a filter contains all the cities in France, a user can constrain the filter choices to those cities starting with P.

    • To allow a user to skip this column filter, select the Allow user to skip prompt check box.

      This causes a Skip Prompt option to appear. The user can then click this option to bypass making a selection for this filter.

  10. When you are finished, click OK.

    The column filter prompt is shown on the Define Prompts page.

  11. To view the column filter prompt, click the Preview Analysis button.

To modify the properties of a column filter prompt

  1. Click the edit button to open the Prompt Properties dialog box.
  2. Make your changes, and then click OK.

To move a column filter prompt up or down in the execution order

  • Click the Move Up and Move Down buttons.

    These buttons appear only when more than one prompt is shown in the Prompts area.

To delete a column filter prompt

  • Click the delete button.

Published 05/11/2007