BusinessObjects Board

Date Filters

Hi all,

We have a requirement to add filters to the universe to be available for reporting. Could anyone help with the syntax of the filters? I would really, really appreciate. I know the list is long, and I have done something like this before, but cannot remember, so seeking help from you all :slight_smile: These are all date related filters, and I assume we would use sysdate?

o Current Year
o Previous Year
o Current Quarter
o Previous Quarter
o Current Month
o Previous Month
o Last 7 Days
o Today
o Yesterday

o YTD
o Prior YTD

o WTD
o Prior WTD

o MTD
o Prior MTD

• Rolling 3 Months
• Rolling 12 Months


hkhan83 (BOB member since 2014-02-26)

Hi,

This sticky topic can get you started:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Thank you very much, Marek! I will take a look at the link. I also wanted to know if it would be best to create a derived table and create the necessary objects to be made available from the sql in your link, or if I should create universe filters. Are both cases possible? The requirement was to have objects available in a “Date Class.” Usually, in the past, I have seen this in practice with the use of filters only. Thanks!


hkhan83 (BOB member since 2014-02-26)