How to break a Date field into Year, month, week,day?(For example: I have a field INVOICE_DATE. Now i want to break it as Year, month..... i.e. in time dimension.) DO i need to have some changes in Universe?

sameerbhave
Profile Answers by sameerbhave Questions by sameerbhave
Apr 18th, 2006
5
32863

Showing Answers 1 - 5 of 5 Answers

sithu
Profile Answers by sithu

Apr 19th, 2006

using date functions seprate the date, day, week, year, qutr, decade, holiday and more, then you can get your answers
Cheers,
Sithu, sithusithu@hotmail.com

pat.mclean
Profile Answers by pat.mclean Questions by pat.mclean

Apr 24th, 2006

Create objects in your universe with date functions.
Let's say your DB is Oracle. In your "Select" statement of new object called year, try
to_char(INVOICE_DATE, 'YYYY') similarly for month create object called month & repeat process, simply replace'YYYY' with 'MM' of 'MMM' in the select statement. & so on.
Cheers,
Pat.

Lanka Madhav

Sep 26th, 2006

Hi
There is another way if you need only year Qtr and Month.
Right click the Date Object, go to Properties tab, There is a button Automatic Time Hierarchy. Click that and automatically you will get 3 objects below the object selected.
Note: i am not sure of higher versions since i am still working on 5.1.6
Thanks
Lanka

sreenivas27
Profile Answers by sreenivas27

Jul 1st, 2008

Hi,

Just you have create Variables like year, month, week and day base your objects so that you can use these variable and you can do what your.

Regards,

Sreenivas.

prashantpurohit2000
Profile Answers by prashantpurohit2000

Mar 4th, 2009

No need to change the universe, create some report level variables like:
Year =Year([Date]), Month =Month([Date]), DayNumber([Date]) etc, but if you want to only show them differently just change the dateformat of the cell.