1、 外 文 翻 译 原文 1： Building a Web-Based Analysis System Part1 译文 1： 构建基于 Web 的分析系统 第一部分 原文 2： Building a Web-Based Analysis System Part2 译文 2： 构建 基于 Web 的分析系统 第二部分 原文 1 Building a Web-Based Analysis System Part 1 A real-world look at using the Analysis Services Thin Web Client Browser Mark Scott, John L
2、ynn Using OWC to Deploy Office on the Web When working with analytical databases, analysts organize data into common groups and try to determine what would happen if things were different. For example, would increasing a products price which would increase profit per unit but probably reduce number
3、of units sold yield a higher or lower overall profit? Or how would a drop in the federal discount rate affect the yield of real estate loans? To help analysts make educated projections based on historical trends, Microsoft provides Analysis Services in SQL Server 2000 and OLAP Services in SQL Server
4、 7.0. These services provide OLAP capability and can process data stored in SQL Server (or any other OLE DB compatible data source) into multidimensional data structures called cubes. Data cubes simplify the process of analyzing trends and correlating the way entities interact with one another. For
5、example, real estate investors use cash-flow modeling to isolate a group of loans that have common characteristics (e.g., types of properties, geographic area, range of interest rates) and project the effects of different kinds of events. What will happen if loans mature more rapidly than expected o
6、r if the borrowers default? And how might such unpredictable events affect the yield of bonds that the loans secure? Selecting from lists that can include hundreds of loans and isolating the loans that have the characteristic that youre analyzing can be tricky. Analysis Services and OLAP Services ca
7、n help correlate these groups of loans so that analysts can model loan assumptions. To help a clients real estate analysts project the performance of commercial mortgage-backed securities, our development team needed to devise a system that simplified the grouping of loans in different ways such as
8、by their interest rate, term to maturity, or property location. The interface needed to be easy to learn and use. And the system we developed needed to be securely deployed through the Internet. To meet these criteria, the development team chose Analysis Services. Having settled on a back-end techno
9、logy, the development team began working on a plan for implementing the front-end interface. Most financial analysts use Microsoft Excel and are familiar and comfortable with its interface. Excel includes PivotTable Service, which lets analysts connect to Analysis Services databases. Excels drag-and
10、-drop interface provides simple, intuitive access to multidimensional data without requiring users to have extensive training. And by using Excels graphing capabilities, users can present data in graphs and charts. So for the front-end interface, the teams first choice was Excel 2002, which is part
11、of Microsoft Office XP. Figure 1 shows Excels PivotTable Service exploring an Analysis Services OLAP cube. Excel would have been a fine choice if all the clients users worked together in the same building and could access the Analysis server through the same LAN. But because the users needed to shar
12、e the application from a variety of organizations whose offices are scattered around the world, the team needed a component similar to Excel that users could access through the Internet. The team found the solution to this challenge in Office Web Components. OWC is a set of ActiveX controls that you
13、 can use on Web pages to provide Office functionality. The OWC PivotTable component is a Web version of Excels PivotTable Service； PivotTable uses PivotTable Service and requires that PivotTable Service be installed before it will run. But the OWC PivotTable works without Excel. PivotTable can retri
14、eve multidimensional data from an Analysis server and present the data in an interactive, drag-and-drop interface. Users who have Microsoft Internet Explorer (IE) 4.01 or later can use OWC to analyze Analysis Services data without installing additional component software. Figure 2 shows the OWC Pivo
15、tTable client interface, which looks and works like the familiar Excel interface. The OWC PivotTable also provides intelligent caching, which improves performance by reducing the number of trips PivotTable makes through the network to the server. So by actively working with Analysis Services, PivotTable can reduce data transfer and work faster.
