高頓網(wǎng)校友情提示,*7阿里會計繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-XI 關(guān)鍵性能指標(biāo),動作和名稱集等內(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模型可以有一個隨帶“動作”。動作允許用戶當(dāng)他們在他們的數(shù)據(jù)里發(fā)現(xiàn)什么時相應(yīng)在Analysis Services里瀏覽數(shù)據(jù)……執(zhí)行動作會使用報告的上下文(用戶正在查看的數(shù)據(jù)),并且使用該上下文作為輸入運行一個不同的應(yīng)用程序。例如,下面的數(shù)據(jù)透視表連接到Analysis Services模型,該模型有一個產(chǎn)品類別關(guān)聯(lián)的動作。如果用戶在該級上任意地方單擊右鍵(例如我們選擇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(報表服務(wù))創(chuàng)建Accessories的銷售比較報表。這是在我網(wǎng)頁瀏覽器上的報表截屏。
  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.
  注意,該動作可以使用各種形式——運行ERP應(yīng)用程序,瀏覽到網(wǎng)頁,等等。這里有個連接到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(分析服務(wù))提供一個功能,叫做“名稱集”,它可以供Analysis Services模型創(chuàng)建者用來提供一個簡單的方式給終端用戶使用復(fù)雜但是經(jīng)常使用的成員集。例如,模型創(chuàng)建者可以定義一個集合,列出當(dāng)前非盈利產(chǎn)品,或者交付時間長的產(chǎn)品。名稱集有很多好處。首先,因為它們可以在服務(wù)器上定義,所以每個看Analysis Services模型的人看到的都是相同的信息。再者,作為項目包括進(jìn)入一個集合的標(biāo)準(zhǔn)可以是動態(tài)的,當(dāng)模型中的數(shù)據(jù)隨著時間添加或者更改了,項目清單是可以自動更新的。再次使用上面的名稱集例子,列出當(dāng)前非盈利的產(chǎn)品。你可以想象當(dāng)時間遷移,該集合包含的產(chǎn)品會自動更改——無論是模型作者還是終端用戶都不需要做任何事情。
  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.
  名稱集顯示在數(shù)據(jù)透視表的字段清單里,因此用戶可以添加到數(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.
  一個用戶創(chuàng)建顯示2004年每個新產(chǎn)品模型銷售報表僅需要做的是勾選該集合的復(fù)選框。
     
  掃一掃微信,學(xué)習(xí)實務(wù)技巧
   
  高頓網(wǎng)校特別提醒:已經(jīng)報名2014年財會考試的考生可按照復(fù)習(xí)計劃有效進(jìn)行!另外,高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通,通過針對性地講解、訓(xùn)練、答疑、???,對學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo),可以幫助考生全面提升備考效果。