BusinessObjects Board

How to make predifined filter

building semantic layer
#1

Hello All,

I have a one object which is date format and format is mm/dd/yyyy.

I need to make a filter in the universe so that when i use into the query filter it will give me the last month data.

Like for example i ran report today :1/10/2011.It will show me the last month data.
like 12/1/2010 to 12/31/2010

The column/ table is “Transaction/Date”. I am using My SQL 4.1.22

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

#2

check this thread for creating objects in Oracle and SQL Server for Prevoius months. Use something similar for your database and use it.

https://bobj-board.org/t/152613

BO_Chief :us: (BOB member since 2004-06-06)

#3

Semantically, you can run the report for Last Month by using following:

Month_Of(Current_Date - DayOf(Current_Date))

Modify the syntax for MySQL

aneelf (BOB member since 2006-05-15)