Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

We need a way to default date filters to the current day/month/Year while opening date range filter

Needs Votes
43
Views
2
Comments
Ancy Paul-Oracle
Ancy Paul-Oracle Rank 5 - Community Champion
edited Sep 29, 2025 11:38AM in Oracle Analytics Cloud and Server Idea Lab

We need functionality that allows date filters to automatically default to the current day/ month/ year. This will help streamline reporting, reduce manual input, and ensure users always see the most relevant data by default.

Currently , if DB has 10+ years data, filter will sit in 2009( if this is starting year) while opening the filter in date range. If I restrict data with a unknown filter(year greater than 2016) , user can not find old data

image.png
Tagged:
9
Up
9 votes

Needs Votes · Last Updated

Comments

  • Michal Zima
    Michal Zima Rank 7 - Analytics & AI Coach

    @Ancy Paul-Oracle Why don't you simply bind date/datetime column (which you want to default to current date) in dashboard filter with system defined parameters Current Date/Current DateTime ( https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/system-parameters.html ) - those parameters are having values, you need for you filtering. And this (I hope) can be done by not very experienced author (no logical SQL knowledge needed).

    Michal

  • Pablo Moreno
    Pablo Moreno Rank 3 - Community Apprentice

    Hello,

    I have defined a date filter with parameters with from current_date-7 to current_Date:

    image.png

    I expect this values will be displayed for all users but there is only visible for my user. The other users by default see the full range.

    This is a bug? We need to be able to define default values.

    Thanks and regards.