Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Default dates as start and end of financial year

Received Response
22
Views
1
Comments
User_7Q1KS
User_7Q1KS Rank 1 - Community Starter
edited Aug 13, 2024 5:31PM in Oracle Analytics Cloud and Server

Hello,

I have a BI publisher report which uses 2 date parameters i.e. Start and End Date. They must be defaulted to the start and end of financial year. i.estart date would be 01-jul-2022 and end date 30-jun-2023 for this year.


Is there any function I can use for this in the default box or can we write SQL case statements in default value box?

Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist

    Hi,

    Setting the default value at parameter level is one option but its an static value. use sql statement to get the value in dynamic manner.

    Regards,

    Arjun