IBM Cognos, User Manual

Page: 44 / 411

data source to add the first query to the model, and use the duplicate report data
source to add the second query to the model.
Cognos Transformer may reflect a cascade prompt as two multi- or single-select
prompts:
v
The first prompt represents the first level of the original cascade prompt.
v The second prompt represents the second cascade level.
For query results in Cognos Transformer, only the second level is relevant. You
should be aware that the first prompt may appear as a multi-select prompt in
Cognos Transformer, even though the prompt in Report Studio is a drop-down list
box; in this situation, Cognos Transformer will ignore the first prompt.
When using a report that includes prompts as a data source, some types of
prompts produce supporting queries. Although these queries can be selected in
Cognos Transformer, error messages will occur if you select them. You can ignore
the messages.
Procedure
1. Right-click a query in the model and click Edit Prompts .
If the query does not contain any prompts, Cognos Transformer displays a
message indicating that no prompts were found.
2.
For each prompt that you want to specify values for, in the
Query Prompts
dialog box, click the
Value
box for the prompt that you want to define.
v
An asterisk beside a prompt name identifies a mandatory prompt.
v
A cross beside a prompt name identifies an obsolete prompt. This prompt
exists in the Cognos Transformer query, but cannot be found in the report or
package used as a data source.
v
An arrow that points to the right beside a prompt name identifies a new
prompt. This prompt exists in the report or package used as a data source,
but cannot be found in the Cognos Transformer model.
3. Define the variable or value for the prompt:
Tips:
v
For a prompt that requires a single value, such as a text box prompt, type the
value that you want used when Cognos Transformer executes the query.
v
For a prompt that permits multiple values, such as a value prompt, the
Enter
values for dialog box appears. Type a value in the Provide a value box.
Click the right arrow to add the value to the Choices list. Continue to type
and add values until all values you want the user to choose from appear in
the
Choices list. Click OK .
v
For a prompt that requires a value selected from a hierarchy, such as a Tree
prompt, the
Select values for dialog box appears. Click a value and click
OK .
v
For a prompt that requires a value selected from a list defined within the
report or package, such as a list of cities, the list of defined values appears
automatically. Click the value in the list.
v
For a prompt that requires a value selected within a specific range, type the
initial value in the
range (Range-From)
box and the final value in the
range
(Range-To) box.
– To quickly delete the value for one prompt, click the row in which the
prompt appears and click Clear Value .
– To quickly delete the values for all prompts, click Clear All .
30
IBM Cognos Transformer Version 10.1.1: User Guide