Dashboard Prompt selections are not staying highlighted when using SQL to develop the list of prompt — Oracle Analytics

Oracle Analytics Cloud and Server

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

Dashboard Prompt selections are not staying highlighted when using SQL to develop the list of prompt

Received Response
11
Views
3
Comments
Mark.Thompson
Mark.Thompson Rank 6 - Analytics Lead

I am working with OAC 12.2.4.0.0, and I may have discovered a bug. 

Situation: I have created a dashboard prompt with two prompt entries, both of which use SQL to generate their lists of values. 

Problem: The 2nd prompt entry does not maintain the highlight on its selected value.

Scenario:

The first prompt entry, generated with this SQL, presents a list of all week ending dates in the past year, sorted latest to earliest:

select "Date"."Fiscal Week Ending"

from "XYZ"

where "Date"."Fiscal Week Ending" between current_date - 365 and current_date 

order by 1 desc

This first prompt entry sets a presentation variable named Selected_FWE

The second prompt entry, generated with this SQL, contains the list clients for whom we performed any significant hours of work during the selected week.

select "Projects"."Client Name"

from "XYZ"

where "Date"."Fiscal Week Ending" = @{Selected_FWE}

  and "Facts"."Revenue" > 2500

This prompt entry sets a presentation variable named Selected_Client

The list of clients is displayed correctly every time.  When a date is selected, the list of Clients populates correctly, showing only those clients for whom we did work with generated revenue of more than $2,500 during the selected week.  If I select a different week, the list of related clients changes correctly.  If I then select a client from the list, any reports that are filtered using the Selected_Client presentation variable work perfectly.  For example, if I select Nissan from the client list, my analysis only shows me Nissan data.  So far, so good.

But what I cannot see, in the prompt itself, is "which client did I select?".  If I use radio buttons, and select a client, the radio button remains highlighted (ticked) for a very short amount of time, and then is unhighlighted.  With a glance at the radio buttons alone, I cannot tell which one is selected.  The same thing happens with any prompt widget - choice list, list box, checkbox, doesn't matter.  None of them will continue to highlight which value is selected.

This behavior does not occur when the list is generated using the 'All Values' option.  It only occurs when using the SQL Results option to generate the list.  Using the 'All Values' option in conjunction with the 'Limit values by' option causes the list to change correctly, and the client selection stays highlighted after selection.  But, of course, that isn't perfect for my needs, because of the need to include the "and revenue > 2500" clause in the SQL. 

It does not seem to matter whether the Apply button is present or not.  Clicking Apply causes the highlight to disappear, and it disappears immediately if the Apply button is not present.  But as noted above, the Presentation Variable IS getting set.  Everything is working perfectly downstream.

The same behavior is exhibited whether the date prompt and the client prompt are in two separate dashboard prompts, or are in the same dashboard prompt.

Could I ask someone else to confirm this behavior please?  Thanks!

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Don't have any OAC instances that old anymore. Did you patch one instance to test already?

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Working at a client site, so I don't have the option of patching an instance to a later version.    I do, however, have a more recent version at a different client.  I can test over there.  Thanks for the suggestion, Christian.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I can test on mine later tonight to counter-check