Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Clear Prompt Selection On One Field When Something is Selected on Another Field
I am trying to accomplish something like the opposite of a Default Selection in a dashboard prompt. I have 2 field selections that should be mutually exclusive. If user sets a value of one, the value of the other field should be reset (set back to null). It shouldn't be possible for both fields to be filled in at the same time. I am using 11g. Is such a thing possible?
Answers
-
Looking for Radio button type for Prompts!!
for time being: You may go for report level validations for those 2 prompts using Presentation variables.
0 -
Could you elaborate regarding 'report level validations'?
FYI, I experimented with setting up a main prompt, then having a separate 'switch' prompt (composed of 2 choices), and then having two more separate conditionally visible prompts that showed the field corresponding to the user's radio button option. This method doesn't fully meet my needs because a user could potentially 'break the switch' by selecting a radio choice, filling out corresponding conditional field selection, then changing switch to other option and selecting this new corresponding conditional field. What I'm really interested in is that automatic clearing out.
0 -
Something like
when PromptA='A1' and PromptB='B1' then 'None'
when PromptA='A1' and PromptB!='B1' then 'B Prompt'
when PromptA!='A1' and PromptB='B1' then 'A Prompt'
condition value 'A Prompt' goes to PromptA field in report
condition value 'B Prompt' goes to PromptB field in report
0