Oracle Analytics Cloud and Server

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

Date prompt in OBIEE analysis

Received Response
182
Views
1
Comments
manyam16
manyam16 Rank 4 - Community Specialist

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 Rank 5 - Community Champion

    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