BusinessObjects Board

Create a case statement for last 12 months

building semantic layer
#1

Hi guys
I have not been able to create a date filter object in my universe for ex
I need to create a case statement for my date where if the date is between last 12 months, then filter says ‘y’, if date is between last 13 and 24 months, the filter says ‘n’ else ‘null’

I have a sql server database.

Any ideas how?

nutty (BOB member since 2015-10-19)

#2

What have you tried so far?

Have a look here: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

Debbie

Debbie :uk: (BOB member since 2005-03-01)

#3

Hi Debbie
I know these sql functions well but they don’t work at the universe level.
I want the BO equivalent of these sql functions.
IDT does not even like getdate().

nutty (BOB member since 2015-10-19)

#4

because you created a MULTI-source UnX instead of a single-source UnX, hm?

Andreas :de: (BOB member since 2002-06-20)

#5

Yes that’s correct… It’s a multi source universe… So how do I get on with it to create a filter/ case statement for last 12 months for a given date in my table?

nutty (BOB member since 2015-10-19)

#6

Further down that link to the sticky (last page, I think), there is a set of dates that work with multi-source IDT universes.

But honestly, performance with multi-source is so bad, I wouldn’t bother … :nonod:

Debbie

Debbie :uk: (BOB member since 2005-03-01)