Date Format is different in Prod and test environments.


  • Hi All,


    I have three servers(PROD,TEST and Dev) for SSAS.I have same code base in all of the three environments.

    I have an Attribute called "Expiry Date" in a dimension called "Dim1" and this dimension is not a time dimension.

    In TEST and Dev environments, "Expiry Date " is shown in dd/MM/yyyy (English UK)  Format and in PROD "Expiry Date" is shown in M/d/yyyy (English US) . But I need dd/MM/yyyy format in all the environments. How can I achieve it ?

    Is the date format setting done on server level properties?

    Please help.

    Thanks in Advance.


    MSBI Developer

    Tuesday, December 17, 2013 3:02 PM


All replies