IBM Support

Conditional Block Always Renders "Other" Block

Troubleshooting


Problem

In the report, no matter what is chosen in the parameter field, the conditional block always chooses the default "Other" option.

Symptom

Reports work correctly in Cognos 10.2.x but not in Cognos 11.0.x.

 

In the report specification "ParamDisplayValue" was referenced. This is correct, however in the static choices on the prompt page value prompt, there was no display value defined and so the reference to the "ParamDisplayValue" ... "='Block1'" wouldn't work as the display value of the choice "Block1" was blank.

Cause

Display value of the Static choices dialog box was empty.

This worked in Cognos 10 because in previous versions, if the display value was not defined, "ParamDisplayValue" -expression would use the "Use value" from static choices prompt.

Resolving The Problem

The issue is resolved by the following steps:

1) Go to the prompt page and select the value prompt.

2) Open the preferences window and double click Static choices.

3) Click the first variable. The use field is filled in but the display field is blank.

4) Click the pencil icon and add a display value to the display field.

5) Do the same for the second variable adding a different display value to the display field.

Note: For this to work with your current report, the display value would have to be set to the value that is referenced by "ParamDisplayValue" in a report object.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Reports","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 November 2018

UID

ibm10742769