Results
Note: Alternatively, you can remove obsolete prompts by directly editing the
prompt specification file that is generated from the model.
Specifying a Segmenting Prompt for an SAP BW Query
A segmenting prompt is used when querying a SAP BW data source for fact data.
Also known as a BEx variable, a segmenting prompt ensures that the query
retrieves a representative sampling of the fact data.
A segmenting prompt can be single value, multiple value, or a range. If you
specify a range, it must be inclusive, including a value for both the beginning and
end of the range. A segmenting prompt must be optional and have no default
value specified.
Multiple prompts, or BEx variables, are allowed. If you have multiple prompts,
you can select one as the segmenting prompt. The segmenting prompt should not
have values specified in any query. Mandatory prompts that are not specified as
the segmenting prompt must have a value specified. Optional prompts that are not
specified as the segmenting prompt may or may not have a value, as necessary.
Since prompts apply to all queries in the Cognos Transformer model but are
maintained separately for each query, the specified values should be the same in
all queries. If there is more than one fact query, each may use a different prompt as
the segmenting prompt. The queries can use the same segmenting prompt, if
suitable.
Tip: Segmentation is only supported for fact queries that have the Use stream
extract option selected on the Data Source property sheet, Source tab.
Procedure
1. In the Data Sources window, right-click the query item named Key Figures.
Key Figures contains measures.
2. In the Data Source dialog box, click the Source tab.
3. Ensure that the Use stream extract check box is selected. Click OK.
4. Right-click Key Figures again and click Edit Prompts.
The Name column in the Query Prompts dialog box lists all the prompts for
the data source.
5. In the Prompt for segmenting data list, select the prompt for segmenting the
fact data.
Only valid prompts are listed.
6. Ensure that the segmenting prompt does not have a default value specified.
Tip: To clear the values for a prompt, click the prompt in the Current prompt
values list, and click Clear Value.
7. Ensure that any mandatory prompts listed in the Current prompt values list
have a value specified.
8. Click OK.
9. When prompted to apply the prompt values to all the queries in the package,
click Yes.
32 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Need help?
General