Thank you for your reply.

I have Schedule table and Date is a column of the table,? which contain Date and time like 2013. 01.10 12:00:13.Now if u plz tell how can I add Year, Month, Day in the? cube and/or Dimesion and also how can I fetch/show those in Excel?