I have installed Analysis Services and two Cubes in Finland. The Regional setting are set to US English date format id M/D/YYYY long date = DDDD MM`YYYY and Input Locales set to Finnish.
The Cunes runs correctly however when I look at the Dimension (Called Time) the data is in Finnish i.e instead of 16May2003 it is 16Tou2003, this then does not allow me to process my reports.
Can anyone therefore tell me how the following
1. Where does Analysis Manager get it's dates from (running Select @@Language return US English)
2. How I can change this so that the correct date is returned.
Many thanks
The Cunes runs correctly however when I look at the Dimension (Called Time) the data is in Finnish i.e instead of 16May2003 it is 16Tou2003, this then does not allow me to process my reports.
Can anyone therefore tell me how the following
1. Where does Analysis Manager get it's dates from (running Select @@Language return US English)
2. How I can change this so that the correct date is returned.
Many thanks