Build your Own Prompt and Prompt Page

Create your own prompt and prompt page to control how they appear in a report.

Note: The Promotion Success sample report in the GO Data Warehouse (analysis) package includes a prompt page.

Procedure

  1. In the navigation menu, click Report, and then click Prompt pages.
  2. Click the Toolbox icon toolbox icon, and drag Page to the Prompt pages box.
  3. Double-click the page you just created.
  4. Click the Toolbox icon toolbox icon, expand Prompting, and then drag one of the available prompt controls to the prompt page. For information about the prompt types, see Adding prompts to filter data.

    The Prompt Wizard dialog box appears.

  5. If you are creating a text box, date, time, date and time, interval, or generated prompt, do the following:
    • Create a new parameter for the prompt or use an existing or global parameter.
    • Click Next.
    • If you created a new parameter, define the expression by selecting a data item from the package and the operator to use.
      Tip: Make the prompt optional by selecting the Make the filter optional check box.
    • Go to step 7.
  6. If you are creating a value, select & search, or tree prompt, do the following:
    • Create a new parameter for the prompt or use an existing or global parameter.
    • Click Next.
    • If you created a new parameter and you want to use the parameter to filter data, select the Create a parameterized filter check box and define the expression by selecting a data item from the package and the operator to use.

      If you are creating a tree prompt, you must choose in in the Operator box.

      You can also use a parameter to provide a value for a layout calculation, such as showing a user's name in the report. When the report is run, you can use a parameter to prompt the user to type his name and have it appear in the report.

      Tip: Make the prompt optional by selecting the Make the filter optional check box.
    • Click Next.
    • If you created a parameterized filter and you have more than one query defined in the report, select the check box for the query on which to filter and click Next.
    • Select the Create new query check box to create the query that will be used to build the list of data values shown when the report is run.
      Tip: Do not create a new query if you want to link the prompt to an existing query or if you intend to create the query at a later time.
    • Click the ellipsis button beside Values to use and click the data item on which to prompt.
    • To choose a data item that is different than what users will see when they are prompted, click the ellipsis button beside Values to display and click the data item.
    • To create a cascading prompt, in the Cascading source box, click the parameter that represents the cascade source.
  7. Click Finish.

Results

The prompt control is added to the prompt page. A prompt page is like a report page. You can insert graphics and text and apply formatting.