BusinessObjects Board

Howto create derivedtable for sysdate,sysdate-1 in Designer?

building semantic layer
#1

Hi Friends,

I want to create derived table for Sysdate, Sysdate-1 in Designer.
I have created derived table as like

select sysdate, sysdate-1 from dual and parsed. But while creating object withthis table iam getting error.
Please help how to create derived table and how create objects with this columns.

Thanks,
Arjun.

arjun1780 :india: (BOB member since 2009-01-28)

#2

Hi,

It’s good to mention what error message you got.

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

#3

Another option is to just create relative date objects, as described in this sticky topic.

Regard,s
Mark