Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 209 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
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
11g ... Two Prompts for One Column (Is or Isn't equal)

J Weis-Oracle
Rank 3 - Community Apprentice
I'd like to create two variable prompts for one column. 1. Program Code "is equal to / is in" and 2. Program Code "is not equal to / is not in".
I followed instructions below, creating one Choice List on Program Code", then added a second column prompt changing formula to Program Code and made it Text Field.
It didn't work. Any advice?
Instructions not working (from Sivakumar Bala) OBIEE 11g: Create Prompt based on Same Column with different type
- Go to Prompt and Add a Account Name Column as " Choice List " and name it in Label as Account name
- in the same Prompt , Add any other column (If you add same column it will through you a error so choose any other column ) Then Click on Edit Formula and change it to Account name column formula and Format as "Text Field"
- Delete the Label of above step and just Press Back space for Null.
0