Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Using an SQL Date Formula in OBIEE Report — 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

Using an SQL Date Formula in OBIEE Report

54
Views
8
Comments
edited Sep 20, 2018 8:51PM in General Transactional Reporting (OTBI) 8 comments

Summary

How do I display previous 30 days of data

Content

Could someone please show me how to tweak the below formula.  I’d like to pull data from the previous 30 days; however, it seems to be pulling for the future 30 days instead. 

               timestampadd(sql_tsi_day, 30, current_date)

When I change the formula to the below example it gives me an error and doesn't return any data:

                timestampadd(sql_tsi_day, -(30), current_date)

Thank you.

Version

OBIEE 11.1.1.9.0
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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