XI 關鍵性能指標，動作和名稱集（二）

XI 關鍵性能指標，動作和名稱集（二）

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

Actions Analysis Services models can have “actions” associated with them. Actions allow users exploring data in Analysis Services to react to what they find in their data … executing an action will take the context of the report (the data the user is looking at) and run a different application with the context as input. For example, the PivotTable below is connected to an Analysis Services model that has an action associated with the product category level. If a user right-clicks any item of that level (here we have picked Accessories for example), there is a Server Actions menu with the option to launch a report for Accessories. 動作 Analysis Services模型可以有一個隨帶“動作”。動作允許用戶當他們在他們的數據里發現什么時相應在Analysis Services里瀏覽數據……執行動作會使用報告的上下文（用戶正在查看的數據），并且使用該上下文作為輸入運行一個不同的應用程序。例如，下面的數據透視表連接到Analysis Services模型，該模型有一個產品類別關聯的動作。如果用戶在該級上任意地方單擊右鍵（例如我們選擇Accessories），就會有個Server Actions菜單，帶有一個啟動Accessories報告的選項。

In the example, the action is launching a sales comparison report for Accessories built using SQL Server 2005 Reporting Services. Here is a screenshot of that report in my web browser. 在本例中，該動作是使用SQL Server 2005 Reporting Services（報表服務）創建Accessories的銷售比較報表。這是在我網頁瀏覽器上的報表截屏。

Note that the action can take a wide variety of forms – running ERP applications, navigating to web pages, etc. Here is a link to a tutorial on MSDN. 注意，該動作可以使用各種形式——運行ERP應用程序，瀏覽到網頁，等等。這里有個連接到MSDN的指南。

Named Sets Analysis Services provides a feature called “Named Sets” which can be used by Analysis Services model builders to provide a simple way for end users to work with complex but commonly used sets of members. For example, the model builder could define a set that lists the currently non-profitable products, or products that have a long lead time. Named sets offer a number of benefits. First, since they can be defined on the server, everyone that looks at an Analysis Services model sees the same information. Second, as the criteria for the items to include in a set can be dynamic, the list of items can automatically update over time as data is added or changed in the model. Again using the above example of a named set that lists the currently non-profitable products, you can imagine that as time passes, the products included in the set will change automatically – neither the model author nor the end user needs to do anything at all. 名稱集 Analysis Services（分析服務）提供一個功能，叫做“名稱集”，它可以供Analysis Services模型創建者用來提供一個簡單的方式給終端用戶使用復雜但是經常使用的成員集。例如，模型創建者可以定義一個集合，列出當前非盈利產品，或者交付時間長的產品。名稱集有很多好處。首先，因為它們可以在服務器上定義，所以每個看Analysis Services模型的人看到的都是相同的信息。再者，作為項目包括進入一個集合的標準可以是動態的，當模型中的數據隨著時間添加或者更改了，項目清單是可以自動更新的。再次使用上面的名稱集例子，列出當前非盈利的產品。你可以想象當時間遷移，該集合包含的產品會自動更改——無論是模型作者還是終端用戶都不需要做任何事情。

Named sets are displayed in the PivotTable field list so that users can add them to a PivotTable on rows or columns. Here is a screenshot of sets defined for the product dimension of my example model. 名稱集顯示在數據透視表的字段清單里，因此用戶可以添加到數據透視表的行或列中。這里是我示例模型的產品維度定義的集合截屏。

All a user has to do to build a report showing the sales for each of the new product models of 2004 is to check the checkbox for that set. 一個用戶創建顯示2004年每個新產品模型銷售報表僅需要做的是勾選該集合的復選框。

Published Tuesday, January 10, 2006 10:29 PM by David Gainer

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。