Format string issue with non calculated members (SSAS)
I have some calculated members and some non calculated members with their format string set to "#,#". When I get them from SQL Server Management Studio, a very weird thing happens:
- Calculated members are displayed correctly ( for example: 1.000.000)
- Non calculated members are allways displayed in U.S. english ( for example: 1,000,000)
I've read some people have exactly the opposite problem, and changing locale settings for SSAS service is working for them... OK, this workaround doesn't work for me.
My regional settings are:
- Windows XP PRO with regional settings set to SPANISH (os Spain)
- Windows SQL Server 2005 SP1 in english
Upvotes: 5<=-=Oct 5 2006 12:20PM=-=>
Thank you for reporting this issue. We will investigate and get back to you.<=-=Apr 18 2007 7:18AM=-=>
This is not fixed in SP2 – both calculated and real measures now display the US format regardless of the client locale.<=-=Sep 19 2010 6:22AM=-=>
You may override the LCID with the cube script to whatever you need. The list of supported LCID can be found on: http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx.
Unfortunately this approach applies to all clients alike and cannot be individualized (user-specific).
LANGUAGE (THIS) = 2055 /* German – Switzerland */