Home > IT Answers > SQL Server > Changing date fields in SQL Server Analysis Services
SQL Server Ask the Experts
2,585 pts.
 Changing date fields in SQL Server Analysis Services
SQL Server Analysis Services, SSAS
In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

Software/Hardware used:
ASKED: July 21, 2009  6:08 PM
UPDATED: July 22, 2009  8:31 AM
RELATED QUESTIONS
Answer Wiki:
er I think that analysis services stores dates and then you need to format them in whatever front-end. also you need ot be aware of locale settings on your SSAS server and on the client. Andrew (andrew.fryer@microsoft.com)
Last Wiki Answer Submitted:  July 21, 2009  6:52 pm  by  Deepfat   15 pts.
All Answer Wiki Contributors:  Deepfat   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for your replay.
The case is that the front end does not support formatting dimensions. Thus we have to do it on the the analysis server.

Thanks
Costas

C0sc0s
 15 pts.