Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Case in text box in obiee

Received Response
1
Views
1
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:45PM in Oracle Analytics Forum

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??

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    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