on 07-22-2016 4:41 AM
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
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.