date object

building semantic layer
1

Hi,

I want to create a date object in the Universe which will be the last day of last month. I can do this in SQL the following way…

last_day(add_months(sysdate,-1))
from dual

How can I accomplish this in BO? Table Dual is not available in the Universe. Is there another way around this?

Thanks!

mutsy (BOB member since 2007-11-27)

2

Hi,

Create your date object with this definition

last_day(add_months(sysdate,-1))

The object will not parse because it does not reference any table. However, it could be used with any other normal object(s) in one query and it will work just fine.

Give it a try and you will see :yesnod:

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

3

This idea (using sysdate) is covered in one of our Designer FAQ entires too. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)

4

tip: you can use derived tables to ‘make’ any dual table
just type

select … as unique name,1
… as unique name2
etc
from dual

into sql code and presto, dual is present for you to use

IngeH :netherlands: (BOB member since 2004-06-22)