admin 管理员组

文章数量: 1086019


2024年4月29日发(作者:span中的文字上下不居中)

外 文 翻 译

原文1:

译文1:

原文2:

译文2:

Building a Web-Based Analysis System Part1

构建基于

Web

的分析系统

第一部分

Building a Web-Based Analysis System Part2

构建基于

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 Lynn

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 product's price—which would increase profit

per unit but probably reduce number 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 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 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 or 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 you're analyzing can be tricky. Analysis Services and

OLAP Services can help correlate these groups of loans so that analysts can model

loan assumptions. To help a client's 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 by their

interest rate, term to maturity, or property location. The interface needed to be easy to


本文标签: 文字 系统 居中 分析