BI Publisher - Issue with parameter defaulting to 'All'

3234813

We are having an issue with BI Publisher prompts where a small handful of columns from SQL, when used as prompts, are appending and defaulting the string 'All' to the column values.

I have a Report where two seemingly similar columns/prompts are behaving in two different ways (Geomarket is behaving correctly)...

The SQL for the List of Values are both the same format - select distinct COLUMN from TABLE - and 'All' is not a value in the column representing High School.

Both DB columns are of type VARCHAR2.

Both Parameters are set up to point to their respective LOVs, but are otherwise identical...

The impact of this is that an optional prompt such as High School will require the user to switch the value from the string 'All' (or whatever arbitrary string we choose) to the 'All' that represents All Column Values. In many cases optional prompts are rarely touched, so to require a user to change the value every time would be challenging.

Any thoughts?  We would appreciate any input.

Thomas Dodds

Remove the 'All' from the default for both parameters ... it may be you have an extra space or something ...

3234813

Thanks for the quick response!

Unfortunately, when we remove the 'All' as a default value, it defaults to the first column value from the LOV.  It does not default to 'All'.  Additionally, I've confirmed there is no extra space in the string 'All'.  Any other suggestions?

Sherry George

Instead of 'All', can you try changing to * for the default value and test.

3234813

I ended up finding a solution.  Leaving out the default value in the Data Model parameters, and choosing 'All' in the parameters section in the Report solved this issue.  Both parameters are now correctly defaulting to the 'All' that means All Column Values.

Thanks, all, for your help!