Case in text box in obiee

mmajdana1

Hello, I am using OBIEE12c

In text box on Dashboard I placed a thing like this

Year: @P_YEAR  (which is a presentation variable i put my prompt in)

So I can show which year i chosed in prompts,

but when i dont choose anything it says Year: @P_YEAR

What i want to do is if i dont chose year  it should give me   Year:

How can i do that??

Can i make some case statement or something like that??

Robert Angel

Hi,

put a default on your value in the place you are presenting it; @{P_Year}{WhatEverYouWantHere} then the user will see the default when it is not populated