New Object in a Universe

[Former Member]

Hi Guys,

I want to create an object in the universe which will point to first day of every week. Object can be designed in such a way that it can be used only when using with another object.

For Ex:

Object Name: First Day of Week

Object Value: 25/07/2011, 18/07/2011, 11/07/2011 etc..

Best Regards,

Shazin

[Former Member · Accepted solution]

What data source are you reporting against?

[Former Member · Accepted solution]

It is an Oracle Database!!

[Former Member · Accepted solution]

So you want an object to return the first day of the current week?

In oracle, that's

trunc(sysdate,'Day')

It won't parse when you build it in Designer but it will work when included in a report with other objects that do reference a table.

Regards,

Mark

[Former Member · Accepted solution]

Hi Mark,

Thanks for the ifo. I tried the same in universe and was successfull.

Meanwhile, please can you advise if the same will be possible in any way by using variables in deski as trnc functionality is not available in deski variable functions.

Best Regards,

Shazin

[Former Member · Accepted solution]

For Deski, you need to look at ToDate and FormatDate functions.

Just note that MM is minutes, mm is months and that hh is 12 hour format, HH is 24 hour format.

So to convert a date time of 27/07/2011 14:15:23 to just 27/07/2011 you would use:

ToDate(FormatDate([Date Object],"dd/MM/yyyy"),"dd/MM/yyyy")

To do the same in Webi/Rich Client, use semi-colons instead of commas.

Regards,

Mark