Oracle Business Intelligence

Products Banner

Date prompt in OBIEE analysis

Received Response
112
Views
1
Comments

Hello,

I need to create a date prompt as From Date: and To Date: for the date column with default values as blank.  how to create the variable prompt with default blank value but when the user wants to select, they should be able to select using the calendar.

Thank you in advance.

Answers

  • #Mayur
    #Mayur ✭✭✭✭

    Hi ,

    Please find the below solution,

    • Select New > Dashboard Prompt

    pastedImage_3.png

    • Select the Subject Area

    pastedImage_5.png

    • Click on Symbol it will ask what type of prompt you must create select COLUMN PROMPT

    pastedImage_7.png

    • Select date column from the Dimension table

    pastedImage_9.png

    • Add the following Highlighted settings,

    pastedImage_10.png

    Result :

    pastedImage_0.png

    Thanks,

    #Mayur