Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Dynamic Date Ranges Using SQL Expressions In Insight (OBIEE) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic Date Ranges Using SQL Expressions In Insight (OBIEE)

Received Response
in Eloqua 28 comments

OBIEE doesn't appear to have any dynamic date ranges as native functionality. You typically have to prompt date or add static values to limit date ranges. I've found a way to do this so thought I would share if others are experiencing the same issue.

If you want a report to default to the last n months or the last n days you will need to apply a filter and use the "SQL Expression". In the example below I want to show all page views that have happened in the last 30 days. I have added the activity field "Page View Date" to the filter and now I want to edit this.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!