cancel
Showing results for 
Search instead for 
Did you mean: 

object need to create in universe (1st day of current week the day should be start sunday)

Former Member
0 Kudos

Hi

Backend: oracle 11g

BO: 4.2 sp2

using Information design tool i want to create a object in universe (1st day of current week the day should be start sunday)

and how to create current date object in universe.

any body help me ASAP.

Thanks,

S Surya teja           

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

For your current date object, simply use SYSDATE - it won't parse but you can use it with table-based objects and it will work fine.

In terms of 1st day of current week, run this SQL in your Oracle client and let me know what it returns:

select to_char(sysdate,'d') from dual;

amitrathi239
Active Contributor
0 Kudos

try this.no idea if you can do with some straight forward function in IDT.Used Case statement to get the sunday date in current week.

This will not parse but it will work in reports.

Case

When

dayOfWeek(curDate())=1

then

curDate()

when

dayOfWeek(curDate())=2

then

decrementDays(curDate(),1)

when

dayOfWeek(curDate())=3

then

decrementDays(curDate(),2)

when

dayOfWeek(curDate())=4

then

decrementDays(curDate(),3)

when

dayOfWeek(curDate())=5

then

decrementDays(curDate(),4)

when

dayOfWeek(curDate())=6

then

decrementDays(curDate(),5)

when

dayOfWeek(curDate())=7

then

decrementDays(curDate(),6)

end