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?
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.
Above answer was rated as good by the following members: abhipali
RE: How to break a Date field into Year, month, week,d...
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.
RE: How to break a Date field into Year, month, week,d...
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
RE: 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?
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.
RE: 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?
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.
1 
0