Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a cube deployed into a Test environment and Production environment. I've noticed something strange happen with the date dimension.

When deployed into our test environment, the Date Key comes out looking like this:

Date Key on Test

However, when deployed into Production it comes out looking like this:

Date Key on Production

Both servers are running SQL Server 2012 and Analysis Services. On the test environment analysis services is installed on the same machine as SQL Server on the production one it is a different server. Apart from that they should be identical...

I would like the DateKey to look like how it appears in the Test environment. I.e. 2012-12-01 00:00:00.

share|improve this question
Are the Regional Settings of the two servers the same? – Jon Seigel Mar 18 '13 at 17:13
Are you referring to the windows Region and Language settings? then yes, both are set to English (United Kingdom) – kzhen Mar 18 '13 at 17:36
Have you ever figured this out? I have the same problem. – Ralph Jansen Jun 26 '14 at 8:38
What language and data format does the OLEDB or ODBC connection from the cube set when connecting to the server? You can see this in sys.dm_exec_sessions from SQL Server (in the language column). Note that this can override regional settings. – Thomas Kejser Sep 24 '14 at 15:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.