|Create Variable Prompt|
|Add your Presentation Column names in the 'Choice List Values', just as they are in the RPD|
|Example of Presentation Columns in RPD that match the custom|
values in the Variable Prompt
2. Now, I update my OBIEE query to have the Presentation Variable as part of the column name. Now, when I put these together in a dashboard, the Presentation Variable allows me to select the column that I want to show in the dashboard. Like I said, a column selector will do the same thing if you only have one query/view. However, if you want to update more than one compound view, a column selector isn't really going to allow you to update all views with the same column selector. This approach allows you to do this without any RPD development.
|Now, I add my Presentation Variable 'SELECT_COLUMNS' in the column formula to allow for the Variable Prompt to drive the Presentation Column that will be displayed in my dashboard.|