Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher - Issue with parameter defaulting to 'All'

Received Response
11
Views
4
Comments
3234813
3234813 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

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)...

pastedImage_2.pngpastedImage_3.png

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...

pastedImage_4.png

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.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    Remove the 'All' from the default for both parameters ... it may be you have an extra space or something ...
    2017-05-24 09_45_22-Oracle BI Publisher.png
    2017-05-24 09_45_57-Oracle BI Publisher.png

  • 3234813
    3234813 Rank 1 - Community Starter

    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
    Sherry George Rank 7 - Analytics & AI Coach

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

  • 3234813
    3234813 Rank 1 - Community Starter

    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!