Inline Prompt Issue

Question

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

Robert Angel · Answer

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!)

[Deleted User] · Answer

In a static text view you can only show the variable itself. Not the whole formula.

KashSidd · Answer

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?