BusinessObjects Board

Previous Filter - Teradata

building semantic layer
#1

I am using Teradata. How can I create a create a Previous Month and Week filter at the universe level?

Thanks
r

RO (BOB member since 2003-08-07)

#2

Create some new objects calculated related to today:

1st of Last Month
Last of Last Month
1st of Last Week
Last of Last Week

I don’t know the specific Teradata syntax off hand, but I do this all the time with Oracle and SQLServer using sysdate and getdate(). Warning… These objects fail parsing, but they actually work fine in the reports.

The create new filters:

Last Month = where dimension date between 1st of Last Month and Last of Last Month

Last Week= where dimension date between 1st of Last Week and Last of Last Week

I always create a whole suite of dates in their own class called ‘Prompts and Constants’. Then they can be used for all kinds of calculations (like aging) and filters.

datagal :us: (BOB member since 2005-12-21)

#3

https://bobj-board.org/t/162166 might help you.

anorak :uk: (BOB member since 2002-09-13)