Excel:SSAS:Locale Reference 語言設定參考

SSAS/EXCEL語言設定參考孖寶 SSAS/EXCEL Translation reference

1.setting up connection
http://www.extremeexperts.com/sql/Tips/ExcelDiffLocale.aspx
2.Locale code
http://www.krafft.com/scripts/deluxe-calendar/lcid_chart.htm

中文有關設定 Chinese related settings:
繁中: 1028 (TAIWAN)
簡中: 2052 (PRC)
香港地區(3076),澳門地區(5724),最後如果沒在SSAS指定,會resolve成1028(即繁中)
詳看msdn

Where to set excel "default" locale for SSAS connection

Control panel->
regional and language option->
"standards and format" section (UPPER section):
select the region
("location" section setting is NOT related)

SSAS Translation: Enterprise vs Standard
標準版只支援維度內容.
standard version support only translation of content in dimension.

metadata translation的意思是維度名稱,cube部件的名字等等...