Use column prompts

The column prompt is the most common type of prompt. This type of prompt applies a value to a selected column for a chosen field. The column prompt acts as a filter when the report is run, returning only the matching results.

You can now create language agnostic column prompts that will show correct results no matter the language used in the report. For more information, see Filter with multiple languages.

This topic covers how to add column runtime prompts to an Interactive Report Writer (ICRW) report. For information on other types of runtime prompts you can add to reports, see Include runtime prompts in a report.

Subscription Interactive Custom Report Writer

Platform Services

Regional availability

All regions
User type Interactive Custom Report Writer: Business, Project Manager
Permissions

Interactive Custom Report Writer: Run, List, View, Add, Edit, Delete

Platform Services: Run, List, View, Add, Edit, Delete

Add column prompts

The column prompt is the most common type of prompt. This type of prompt applies a value to a selected column for a chosen field. The column prompt acts as a filter when the report is run, returning only the matching results.

When you create the prompt, you select the columns and operators, then specify how the prompt appears and how the values are selected.

  1. Select an ICRW report to Edit.
  2. Go to the Prompts tab, select the New icon A plus sign icon that adds a new item when selected. , and select Column Prompts from the dropdown list.
  3. Select the column to which you want to add a prompt.
    If the appropriate column is not available from the list, select More Columns in the dropdown list. Then, choose the appropriate column in the Select Column dialog.
  4. In the New Prompt dialog, enter the necessary information for the prompt. The options differ based on the column type that you selected.
  5. Select OK.
  6. Optionally, to add a row or column to the prompts page, select New Row or New Column in the Definition page toolbar.
  7. Optionally, repeat the previous steps to create additional prompts.
  8. To see how the prompt appears at runtime, select the Preview icon The Preview icon brings up a preliminary view of a selected item..

Add dimension or dimension group prompts

You can prompt users to select dimensions or dimension groups when they run an ICRW report. These options allow reporting results to be quickly refined to values within a dimension group. For example, a dimension group might contain all customers with a particular attribute.

  1. Select an ICRW report to Edit.
  2. Add a dimension ID object from the Dimension subfolder as a column to the report.
    For example, from the Dimension folder, select Location, then the ID [Department] object.
  3. Go to the Prompts tab, select the New icon A plus sign icon that adds a new item when selected. , and add a Column Prompt for the new dimension ID column.
  4. Set the following:
    1. Operator: is equal to / is in.
    2. User can select from: Choice List.
  5. Select OK.

When you preview the report in edit mode, you’ll only be able to select from single dimension members, not dimension group members.

When you run the report, users can select from a list of dimensions, or dimension group members associated with the dimension name column you added.