Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard Prompt selections are not staying highlighted when using SQL to develop the list of prompt

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
-
Don't have any OAC instances that old anymore. Did you patch one instance to test already?
0 -
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.
0 -
I can test on mine later tonight to counter-check
0