Oracle Analytics Cloud and Server

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

OAS Date in DV manual query - Parameter / Filter

Accepted answer
369
Views
22
Comments
13»

Answers

  • The error is quite constant: your parameter requires an initial (a default) value.

    You can select a date and that will be hardcoded initial value, or you can make that dynamic with a Logical SQL query. Christian posted an example, and you can also use the same approach to generate that value based on various criteria (current date, 1 year ago, anything else you may need).

  • User_VMJII
    User_VMJII Rank 4 - Community Specialist

    Thank you both. I'll let you know how I manage