Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am extracting data directly from a Data Warehouse. There is table for Time_Dimension which I am using.
The Time_Dimension data contains months in numeric / integer. For Example: 1, 2, 3,4,.....12.
Now I want to display 1 as JAN , 2 as FEB ........12 as DEC.
Please Advise!!
Thanks,
H
hi
If your monthnames variable is right, use something like
month(makedate(2011,your_month_field)) as MonthName
if you have a year field, use this version
month(makedate(your_year_field,yourmonthfield)) as MonthName
Create an INLINE table with the names
Load * INLINE [ Month_Num, Month_Name
1, JAN
2, FEB....];
OR use
pick(your_month_field, 'JAN','FEB','MAR'.......'DIC')
rgds