Dynamic column heading based on a variable in Oracle Analytics Server

Question

Hello everyone,

Thank you for taking the time to read my question.

I have a column in my analysis that I want to display values based on a variable selected by the user. The user can choose between two options:

* Revenue
* Revenue plus everything paid in the next year related to prior sales

I was able to modify the column's values using a CASE statement based on the selected option. However, I cannot find a way to dynamically change the column heading based on the user's variable selection.

Is this possible in Oracle Analytics Server?

If not, would a workaround be to give the column a generic title like "Sales" and place the selected variable name as a text label next to the graph instead?

Thank you for your insights.

Here im making a case statement allowing the value to change based on the box selected.

And here's the prompt and the variable settings

gregg.rm · Answer

Thank you so much Chad! It worked

Chad Williams · Answer

To add, there are lots of different approaches here, and many of them should be documented in the OA documentation that is out there.

Chad Williams · Answer

Yes, in Classic mode, you can put Presentation Variables directly in the Column header in your analysis.

You can also use global variables from your RPD/Semantic Model as well if you want them to appear in your subject area.