喀什會(huì)計(jì)繼續(xù)教育網(wǎng)：Excel2007新知-X 服務(wù)器格式，翻譯和成員屬性

高頓網(wǎng)校友情提示，*7喀什會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-X 服務(wù)器格式，翻譯和成員屬性等內(nèi)容公布如下：　　PivotTables X: Server formatting, translations, member properties

　　In this post I’ll walk you through three Analysis Services features that we now support in Excel PivotTables – server formatting, translations, and member properties. One thing to keep in mind as you read is that since all these are defined in Analysis Services (i.e. on a server), every PivotTable created that pulls data from Analysis Services will get the benefit of these features without the PivotTable author or user needing to do anything.

　　在本文里，我將帶領(lǐng)你瀏覽我們現(xiàn)在在Excel 數(shù)據(jù)透視表里支持的Analysis Services功能——服務(wù)器格式，翻譯和成員屬性。你在閱讀的時(shí)候請(qǐng)牢記一件事，因此這些都是在Analysis Services（例如在服務(wù)器上）上定義的，從Analysis Services獲得的數(shù)據(jù)而創(chuàng)建的每個(gè)數(shù)據(jù)透視表將會(huì)從中獲益而不需要數(shù)據(jù)透視表作者或者用戶去做任何事情。

　　Server formatting

　　When designing a model in Analysis Services, formatting can be associated with values. Excel PivotTables will display this formatting by default (you can control it in the connection properties dialog for the connection being used by the PivotTable, so if you want to turn off the formatting, you can).
 

　　在Analysis Services設(shè)計(jì)模型時(shí)，設(shè)計(jì)數(shù)據(jù)的同時(shí)也可以設(shè)置格式。Excel數(shù)據(jù)透視表將會(huì)默認(rèn)地顯示這些格式（你可以在連接屬性對(duì)話框里控制它，因此如果你想要關(guān)閉格式的話，你可以做到）

　　Here is an example of a PivotTable displaying number formatting as defined on the server – in this case dollars with two decimals. As you add fields to the Values area of the PivotTable, the formatting is done automatically.

　　這里有個(gè)例子，數(shù)據(jù)透視表顯示服務(wù)器上設(shè)計(jì)的數(shù)字格式——在本例中，為帶兩位小數(shù)位數(shù)的美元。當(dāng)你添加字段到數(shù)據(jù)透視表的數(shù)值區(qū)域時(shí)，格式會(huì)自動(dòng)完成。

　　The next screenshot illustrates fill color formatting defined on the server. In this case, the formatting is actually based on a rule (MDX *), setting different fill colors based on the value in each cell. You can think of this as conditional formatting defined in Analysis Services. Again, the user didn’t have to do anything but add the fields to the PivotTable to get server defined conditional formatting based on centralized business rules. In the example, the rule colors cells with acceptable values green, cells with unacceptable values red and cells with values in between are colored yellow.

　　下一張截圖示范在服務(wù)器上設(shè)計(jì)的填充色格式。在這種情形中，格式實(shí)際上是基于一個(gè)規(guī)則（MDX表達(dá)式）的，基于每個(gè)單元格的數(shù)值設(shè)置不同的填充顏色。你可以將其看作是定義在Analysis Services里的條件格式。同樣，用戶不必做任何事情，只是添加該字段到數(shù)據(jù)透視表，以獲取服務(wù)器基于集中的業(yè)務(wù)規(guī)則定義的條件格式而已。在該例子里，顏色規(guī)則是，可接受的數(shù)值為綠色，不可接受的數(shù)值的單元格為紅色，位于兩者之間的數(shù)值單元格填充為黃色。

　　This is pretty powerful … business logic can be defined in an Analysis Services model, and everyone that views the data sees that business logic in their spreadsheet without having to do anything except add fields to their PivotTable.

　　這功能真是非常強(qiáng)大……業(yè)務(wù)邏輯可以在Analysis Services模型里定義，然后查看數(shù)據(jù)的每個(gè)人在他們的電子表格里都可以看到該業(yè)務(wù)邏輯，而不必做任何事情，除了添加字段到他們的數(shù)據(jù)透視表。
 

　　For global companies, it is important that employees and customers in different countries can access corporate data in their native language. Analysis Services 2005 offers a new “translations” feature that enables you to have multiple translations of the same model. For example, you might have you product catalog available in English, French, German and Spanish. Excel 12 PivotTables expose these translations in the report itself as well as in the field list. Based on the language settings on the machine where Excel is running, Excel will automatically pick the same language if it exists on the server. If that language does not exist, the default language specified on the server will be picked. You can override this automatic behavior by specifying a locale identifier in the connection information for the PivotTable and thereby force the use of a specific language.

　　翻譯

　　對(duì)于一個(gè)全球性公司，不同國家的員工和客戶能夠用其母語訪問公司數(shù)據(jù)是非常重要的。Analysis Services 2005提供了一個(gè)新功能“翻譯”，讓你可以使同一個(gè)模型有多種翻譯。例如，你的產(chǎn)品目錄可能有英語的，法語的，德語的和西班牙語的。Excel 12數(shù)據(jù)透視表不但將這些翻譯出現(xiàn)在報(bào)表本身，而且也出現(xiàn)在字段列表里。基于Excel運(yùn)行的機(jī)器上的語言設(shè)置，如果該語言在服務(wù)器上也存在的話，Excel將自動(dòng)選擇相同的語言。如果該語言不存在，那么服務(wù)器上指定的缺省語言就會(huì)被選上。你可以忽視該自動(dòng)行為，為數(shù)據(jù)透視表在連接信息里指定一個(gè)當(dāng)?shù)貥?biāo)識(shí)符，強(qiáng)行要求使用指定的語言。

　　Let’s look at an example. Here is a PivotTable displaying the English translations of the server model, which is what you would see if you open the Excel file on a machine running English Excel 12.

　　我們來看一個(gè)示例。這里是一個(gè)顯示從服務(wù)器模型來的英語版數(shù)據(jù)透視表，如果你在一個(gè)英語版的Excel 12運(yùn)行的機(jī)器上打開Excel文件的話，這也是你想看到的。

　　Now, I’ll pick a different connection file pointing to the same server model. This connection file specifies that I want the Spanish translations.

　　現(xiàn)在，我將選擇一個(gè)不同的文件連接到同一個(gè)服務(wù)器模型。該連接文件指定我需要西班牙版本。

 　　　　

　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧

　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開通，通過針對(duì)性地講解、訓(xùn)練、答疑、模考，對(duì)學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。