showing column values as "empty values" whenever i didnt select any filter value in obiee 11g dashbo — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

showing column values as "empty values" whenever i didnt select any filter value in obiee 11g dashbo

Received Response
2
Views
2
Comments
3231180
3231180 Rank 2 - Community Beginner
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

Hi All,

In below screenshot,whenever i didnt select program short name then it should show all names in 'program' ...but it is showing empty.(mark as highlighted)

anyone please give me inputs.......thanks in advance.

Cap.PNG

Answers

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    It's hard to answer your question without a crystal ball, but I'll try.

    It seems that your prompt initializes some presentation variable which is later used in a report. In the report this variable is used in a form like this: @{variable_name}{'filterValues'}. If nothing is selected the variable remains undefined and a default value appears ('filterValues'). And what you want is to show something instead of this default.

    The easiest solution is to change the default value to something more user-friendly. "All programs" for example.

    Another solution is to change prompt default selection to all programs.

    It's up to you to decide.

  • 3231180
    3231180 Rank 2 - Community Beginner

    Hi,

    Thanks for your inputs.I wanna display all values in program column instaed of blank when i didnt choose any value in the program short name prompt.