May 03, 2005, 06:35 AM<Renuka>
creation of quarter field in time dimension
creation of quarter field in time dimension.
source database = MS Access
field name = shippeddate; format = HYYMDs
Now i want to create a table which contains quarter1 field in MS SQL Server.
please let me know what is the procedure to create a quarter1 field and also format of the field in sql server.
May 03, 2005, 02:32 PMFrancis Mariani
First convert the HYYMDs column to a YYMD column (DATE_Z in my example). Then you can isolate any of the date components.
DEFINE FILE EMPDATA
DATE_X/A8YYMD = HIREDATE;
DATETIME/HYYMDS = HINPUT(8, DATE_X, 8, 'HYYMDS');
DATE_Z/YYMD = HDATE(DATETIME, 'YYMD');
TABLE FILE EMPDATA
BY DATE_X NOPRINT