Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Inline Prompt Issue
Hi,
I was trying to display an inline prompt on top of an analysis and it works fine using Presentation Variable but if the Prompt is not selected then it leaves the variable name as is "@{PTable}" which Users dont want so is there a way to not show anything if not selected
OBIEE Version: 12.2.1.3.0
Thanks,
Kash
Answers
-
CASE WHEN '@{PTable}{SomeRandomDefault}' = 'SomeRandomDefault' THEN 'WhateverYouWantToShow' else '@{PTable}{SomeRandomDefault}' END
0 -
Nice and let me try
0 -
I tried the CASE statement but its not working and can you elaborate as to how it would be used? I am using a Static Text box on top of the analysis?
0 -
In a static text view you can only show the variable itself. Not the whole formula.
0 -
No reason you couldn't make your default value the thing you wanted to show, and change the filter on that column using a case statement to change it to the column in question (so it is always equal itself - if you want your default to show all values!)
0