Post reply

Change of Date formats when Processing Cubes

  • March 10, 2003 at 6:47 pm

    #159444

    We have an issue I thought was produced by SQL2000 SP3, where processing a cube on a clients machine changed the date format from dd/mm/yyyy to mm/dd/yyyy ?? But today another client phoned with the same problem but has not had SP3 loaded on her machine. Has anyone had this problem ? Any ideas would be greatfully received.

  • March 11, 2003 at 4:10 am

    #450768

    Hi Angie,

    SQL OLAP is very sensitive to regional settings. It just like the US one. I have troubles with my OLAP server too.

    I don't know if the client regional settings may infer to the result of their queries... But it can be a way to investigate.

    Tom

  • March 11, 2003 at 2:13 pm

    #450830

    Thanks Tom, yes we had come to that conclusion. We have checked the client and the servers regional settings and found them to be the same ???? One client Machine has SP3 the other client has not. The SQL Server is SP3 but the OLAP Server is not as I am loathed to do it until I resolve the Date format issue. ~ :o)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply