OLAP cube DateTime dimension
 

Sorry if this is in the wrong place, however I am not sure which group
to put it in.

I am creating an OLAP cube (using the wizard in the Excel import
external data menu) from an SQL server and I am adding a date/time
field as a dimension.

I need this as a standard UK date ("dd/mm/yyyy") but the dimension
comes up as a Year-Period-Month-Week-Day-Hour-Minute set.

Is there an easy way (I have to provide quick project handover) of
changing it back, or do I have to manually edit the .cub file.

I have already tried converting to text in SQL server before creating
the cube but this mess's up my subsequent calculations.

Any help would be much appreciated.

Giff