MULTISELECT PROMPT AND PRESENTATION VARIABLE CAUSES ‘NO CHOICES AVAILABLE’

You are on OBI 10.1.3.3.3 and have configured a Dashboard Prompt with a couple of columns where the value selected by the user in the first prompt column gets stored in a presentation variable, and the values in the second prompt column depends on
the value in this presentation variable.

When both column prompts are defined as ‘Drop down’ type. The prompts work
fine. The second column correctly displays in the dropdown the values.

However when the second column prompt control is defined as ‘multi select’.

ACTUAL BEHAVIOR
———————–
No data is displayed in the prompt. The prompt displays ‘No Choices available’.

EXPECTED BEHAVIOR
———————–
The multiselect prompt column should correctly display values in the prompt as it does when it is defined as a dropdown.

Cause

Statement describing the cause of the problem
This issue has been determined to be a bug, which is now reported in Change Request Bug No: 7571682 (MULTISELECT PROMPT AND PRESENTATION VARIABLE CAUSES ‘NO CHOICES AVAILABLE’).
The proof that this is the cause of the problem
This issue is caused by Bug No: 7571682 (MULTISELECT PROMPT AND PRESENTATION VARIABLE CAUSES ‘NO CHOICES AVAILABLE’) as per our inhouse testcase which replicated the same behavior your system exhibits.

Solution

This issue has been determined to be a bug, which is now reported in Change Request Bug No: 7571682 (MULTISELECT PROMPT AND PRESENTATION VARIABLE CAUSES ‘NO CHOICES AVAILABLE’).

As possible workarounds we have found that, on the Dashboard, when you click the ellipsis and invoke the multiselect popup and you get the message “No Choices Available.”,

1. Click the ‘Go’ button will bring back data

2. Alternatively you can enter a value in the match box and it returns data

3. Also you can consider using the vanilla constrain option for the dashboard prompts, so you can have column 2 constrained by column 1.

Please consider the above as possible workarounds.