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:
However, when deployed into Production it comes out looking like this:
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.