阿里會(huì)計(jì)繼續(xù)教育網(wǎng)：Excel2007新知-XI 關(guān)鍵性能指標(biāo)，動(dòng)作和名稱(chēng)集

高頓網(wǎng)校友情提示，*7阿里會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-XI 關(guān)鍵性能指標(biāo)，動(dòng)作和名稱(chēng)集等內(nèi)容公布如下：
　　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模型可以有一個(gè)隨帶“動(dòng)作”。動(dòng)作允許用戶(hù)當(dāng)他們?cè)谒麄兊臄?shù)據(jù)里發(fā)現(xiàn)什么時(shí)相應(yīng)在Analysis Services里瀏覽數(shù)據(jù)……執(zhí)行動(dòng)作會(huì)使用報(bào)告的上下文（用戶(hù)正在查看的數(shù)據(jù)），并且使用該上下文作為輸入運(yùn)行一個(gè)不同的應(yīng)用程序。例如，下面的數(shù)據(jù)透視表連接到Analysis Services模型，該模型有一個(gè)產(chǎn)品類(lèi)別關(guān)聯(lián)的動(dòng)作。如果用戶(hù)在該級(jí)上任意地方單擊右鍵（例如我們選擇Accessories），就會(huì)有個(gè)Server Actions菜單，帶有一個(gè)啟動(dòng)Accessories報(bào)告的選項(xiàng)。

　　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.

　　在本例中，該動(dòng)作是使用SQL Server 2005 Reporting Services（報(bào)表服務(wù)）創(chuàng)建Accessories的銷(xiāo)售比較報(bào)表。這是在我網(wǎng)頁(yè)瀏覽器上的報(bào)表截屏。

　　Note 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.

　　注意，該動(dòng)作可以使用各種形式——運(yùn)行ERP應(yīng)用程序，瀏覽到網(wǎng)頁(yè)，等等。這里有個(gè)連接到MSDN的指南。
 

　　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（分析服務(wù)）提供一個(gè)功能，叫做“名稱(chēng)集”，它可以供Analysis Services模型創(chuàng)建者用來(lái)提供一個(gè)簡(jiǎn)單的方式給終端用戶(hù)使用復(fù)雜但是經(jīng)常使用的成員集。例如，模型創(chuàng)建者可以定義一個(gè)集合，列出當(dāng)前非盈利產(chǎn)品，或者交付時(shí)間長(zhǎng)的產(chǎn)品。名稱(chēng)集有很多好處。首先，因?yàn)樗鼈兛梢栽诜?wù)器上定義，所以每個(gè)看Analysis Services模型的人看到的都是相同的信息。再者，作為項(xiàng)目包括進(jìn)入一個(gè)集合的標(biāo)準(zhǔn)可以是動(dòng)態(tài)的，當(dāng)模型中的數(shù)據(jù)隨著時(shí)間添加或者更改了，項(xiàng)目清單是可以自動(dòng)更新的。再次使用上面的名稱(chēng)集例子，列出當(dāng)前非盈利的產(chǎn)品。你可以想象當(dāng)時(shí)間遷移，該集合包含的產(chǎn)品會(huì)自動(dòng)更改——無(wú)論是模型作者還是終端用戶(hù)都不需要做任何事情。

　　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.

　　名稱(chēng)集顯示在數(shù)據(jù)透視表的字段清單里，因此用戶(hù)可以添加到數(shù)據(jù)透視表的行或列中。這里是我示例模型的產(chǎn)品維度定義的集合截屏。

　　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.

　　一個(gè)用戶(hù)創(chuàng)建顯示2004年每個(gè)新產(chǎn)品模型銷(xiāo)售報(bào)表僅需要做的是勾選該集合的復(fù)選框。

 　　　　

　　掃一掃微信，學(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)開(kāi)通，通過(guò)針對(duì)性地講解、訓(xùn)練、答疑、?？迹瑢?duì)學(xué)習(xí)過(guò)程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。