TM1 Forum

hi,

I am trying to create a calender dimension using excel perspective.(dim.xdi). in that my date format is like 1-mar-2010-thu. but when the dimension is getting saved , the elements (sample =1-mar-2010-thu) are displayed in the dimension editor as a numerical value(something like 45678) corresponding to the date format given in the excel.I need to display date as '1-mar-2010-thu' in the dimension structure also.So please give me suggestions how to do over this....

Thanks and regards,
Angel

angel1234 wrote: I am trying to create a calender dimension using excel perspective.(dim.xdi). in that my date format is like 1-mar-2010-thu. but when the dimension is getting saved , the elements (sample =1-mar-2010-thu) are displayed in the dimension editor as a numerical value(something like 45678) corresponding to the date format given in the excel.I need to display date as '1-mar-2010-thu' in the dimension structure also.So please give me suggestions how to do over this....

I suggest that you have a read of my Using Dates And Times In TM1 thread. But in short, you'll need to define the dates as text in the .xdi, not merely using formats for date values. You can use Excel to create the dates as values, then use the =TEXT(CellContainingDate,"DD-Mmm-YY") function to convert that to text, copy and paste as values over your original calculated dates.