Table Prompts erroneous data

Question

Environment 11.1.1.7.150120 ; I have a table prompt with some filter conditions. When the dashboard is opened first time, it shows no data on the default selected table prompt (first value in the criteria). This is in error, If i switch the value to another and back to the first value again, it shows data. Please help  if this is a bug or if i should change something.

Here 201706 is the first value in the criteria and it shows no data

When i re-select the same value, data is returned.

deeps · Answer

Rebuilding the report didn't fix the issue, it comes back when the dashboard prompts are changed. Do you have any other suggestions?

deeps · Answer

HI Gianni, I will try building the analysis from scratch. This report was untouched when this issue started but probably could have saved something as you explained.

Gianni Ceresa · Answer

Hi,

Did you clicked on the table prompt while editing/building the analysis?

Often the issue is that people play with prompts while editing the analysis but not in the preview window but directly in the analysis itself. When you do that OBIEE saves these things and you end up with that message.

So try by building the same analysis again from scratch (ignoring the visual settings for the test) and do not play with the analysis if not in the preview window (opened by clicking the preview button).

Your error will probably not appear anymore.