X 服務(wù)器格式，翻譯和成員屬性

X 服務(wù)器格式，翻譯和成員屬性

譯者：hxhgxy? 來源：http://blogs.msdn.com/excel 發(fā)表于：2006年7月7日

PivotTables X: Server formatting, translations, member properties 數(shù)據(jù)透視表 X：服務(wù)器格式，翻譯，成員屬性

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ù)器格式，翻譯和成員屬性。你在閱讀的時候請牢記一件事，因此這些都是在Analysis Services（例如在服務(wù)器上）上定義的，從Analysis Services獲得的數(shù)據(jù)而創(chuàng)建的每個數(shù)據(jù)透視表將會從中獲益而不需要數(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). 服務(wù)器格式 在Analysis Services設(shè)計(jì)模型時，設(shè)計(jì)數(shù)據(jù)的同時也可以設(shè)置格式。Excel數(shù)據(jù)透視表將會默認(rèn)地顯示這些格式（你可以在連接屬性對話框里控制它，因此如果你想要關(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. 這里有個例子，數(shù)據(jù)透視表顯示服務(wù)器上設(shè)計(jì)的數(shù)字格式——在本例中，為帶兩位小數(shù)位數(shù)的美元。當(dāng)你添加字段到數(shù)據(jù)透視表的數(shù)值區(qū)域時，格式會自動完成。

The next screenshot illustrates fill color formatting defined on the server. In this case, the formatting is actually based on a rule (MDX expression), 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í)際上是基于一個規(guī)則（MDX表達(dá)式）的，基于每個單元格的數(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ù)的每個人在他們的電子表格里都可以看到該業(yè)務(wù)邏輯，而不必做任何事情，除了添加字段到他們的數(shù)據(jù)透視表。

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

In this case I chose a new connection, but the same thing would have happened had I opened the Excel file on a Spanish machine running Excel 12. 在本例中，我關(guān)閉了一個新連接，但是如果我在一個西班牙語機(jī)器運(yùn)行的Excel 12中打開該Excel文件時，同樣的事情也會發(fā)生。

Member properties When analyzing data, it can be very helpful to get at additional information about an item to make better decisions. For example, if you’re looking at product sales, it might be very helpful to be able to quickly look up all the information on a specific product to better understand the sales amount for that product. Member properties in Analysis Services allow you to do just that. Excel 12 PivotTables expose member properties in tooltips, so all you have to do is to hover over the product that you want more information on, and this information will be displayed in a tooltip. 成員屬性 在分析數(shù)據(jù)時，如果能獲取某個項(xiàng)目的額外信息的話，那么對于做一個更好的決定是很有幫助的。例如，如果你正在查看產(chǎn)品銷售情況，如果能夠快速查看某個具體產(chǎn)品的所有信息，以更好地理解該產(chǎn)品的銷售量，那么會很有幫助的。Analysis Services里的成員屬性允許你實(shí)現(xiàn)這個。Excel 12數(shù)據(jù)透視表將成員屬性顯示在工具提示里面，因此你所有要做的事情只是將鼠標(biāo)移到你需要更多信息的產(chǎn)品之上，該信息就會被顯示在工具提示上。

The member properties can also be added inside the PivotTable itself when you need to print the information or just have it be visible all the time. Here is what that looks like. 成員屬性也可以添加到數(shù)據(jù)透視表本身內(nèi)部，當(dāng)你需要打印該信息或者只是想讓它時時可見。這是它的樣子。

Finally, the Excel Object Model can be used to make member properties display instead of the members those properties pertain too. For example, if you have quarters represented as “First Quarter 2004”, “Second Quarter 2004”, etc., you can define a member property with abbreviated names like “Q1 04”, “Q2 04” etc. and set a flag to show the properties when the field is placed in the column area, making the report more readable (less wide). 最后，Excel對象模型可以用來顯示成員屬性，而不是擁有那些屬性的成員。例如，如果你有一些季度，表現(xiàn)為“First Quarter 2004”，“Second Quarter 2004”，等等，那么你可以定義成員屬性為一些縮寫的名稱如“Q1 04”，“Q2 04”等，并且當(dāng)放置該字段到列區(qū)域時設(shè)置一個標(biāo)志以顯示該屬性，這樣可以使報(bào)表更易讀（列寬窄一些）。

Published Thursday, January 05, 2006 5:40 PM by David Gainer

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時內(nèi)刪除侵權(quán)內(nèi)容。

版權(quán)聲明：本文內(nèi)容由網(wǎng)絡(luò)用戶投稿，版權(quán)歸原作者所有，本站不擁有其著作權(quán)，亦不承擔(dān)相應(yīng)法律責(zé)任。如果您發(fā)現(xiàn)本站中有涉嫌抄襲或描述失實(shí)的內(nèi)容，請聯(lián)系我們jiasou666@gmail.com 處理，核實(shí)后本網(wǎng)站將在24小時內(nèi)刪除侵權(quán)內(nèi)容。