【正文】 f data as part of BI Integrated Planning. Finally, special analysis tools such as the Analysis Process Designer (APD) and the Data Mining provide the analysts at your pany with the tools to merge, mine, preprocess, store, and analyze data without support from your technical team. Note: New corporate governance rules, such as the SarbanesOxley Act in the United States, frown on the creation of uncontrolled data. The APD lets analysts manipulate the data (like they would have done in Microsoft Excel and Access) and keep it in the warehouse. Mobile Reporting You can use BEx Mobile Intelligence to call up the Web applications you created with the Web Application Designer. You can even do this when away from your desk. The following devices are supported: ? Personal digital assistant (PDA) with Windows CE and Pocket Inter Explorer ?WAPenabled mobile telephone ? iModeenabled mobile telephone ?Mobile device with EPOC32 operating system (the Nokia Communicator 9210, for example) SAP NetWeaver Business Intelligence: Data Warehouse Layer The Data Warehouse layer is the subject of this class, and its overview will be in the 重慶 郵電 大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì) （論文）附件 附件 C：譯文 C16 lesson that follows. Briefly, the warehouse is responsible for the cleansing, loading, storage, and management of the data needed for the enterprise. You now have the basics, but one other m ajor point should be made. SAP, unlike other providers of BI solutions, provides you with robust, delivered BI content. With BI Content, SAP delivers preconfigured role and taskbased information models and reporting scenarios that are based on consistent metadata. BI Content gives selected roles in a pany the information they need to carry out their tasks. The information models delivered cover all business areas and integrate content from almost all SAP applications an d selected external applications. In BI projects, determininguser requirements and then designing extraction programs are the two hardest things. With BI Content we provide these as well as database schemas, queries, and outputs via the Web or Excel for 60% to 90% of a typical project39。s decision making process . A more technical definition might be: the subset of a Business Intelligence tool set responsible for modeling, structuring, storing as well as extraction translation and loading (ETL) of the underlying data needed for analysis. So in summary, Business Intelligence software is the collection of applications needed to make sense of business data. The Data Warehouse, a ponent of this Business Intelligence tool set, is the more specific tool responsible for the cleanup, loading, and storage of the data needed by the business. Although we will address the overall BI tool set in the next lesson, this class focuses on the Data Warehouse ponent. A Data Warehouse can help to organize the data. It brings together all operative DataSources (these are mostly heterogeneous and have differing degrees of detail). The job of the warehouse is to provide this data in a usable form to the whole organization. The data can then be used for future requirements as the need arises. A warehouse has the following properties: 重慶 郵電 大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì) （論文）附件 附件 C：譯文 C11 ? Readonly access: Users have readonly access, meaning that the data is primarily loaded into the Data Warehouse via the extraction, transformation and loading (ETL) process. ? Crossorganizational focus: DataSources from the entire organization (production, sales and distribution, controlling), and possibly external sources, make up the basis of the system. ? Data Warehouse data is stored persistently over a particular time period. ? Data is stored on a longterm basis. ? Designed for efficient query processing: The technical environment and data structures are optimized to answer business questions . not to quickly store transactions. R. Kimball, another guru of Data Warehousing, defines a Data Warehouse as .A copy of transaction data, specially restructured for queries and analyses.. (The Data Warehouse Toolkit, 1996, page 310). Business Intelligence Systems Objectives A modern Business Intelligence system must meet the following requirements: Standardized structuring and display of all business information: Decision makers urgently need reliable information from the production, purchasing, sales and distribution, finance, and human resources departments. They require an uptodate and prehensive picture of each individual business area and of the business as a whole. This results in high demand being put on the data collection process from the underlying DataSources. The data is defined uniquely across the entire organization to avoid errors arising through varied definitions in different sources. Simple access to business information via a single point of entry: Information must be bined homogeneously and consistently at a central point from which it can be called up. For this reason, modern Data Warehouses usually require a separate database. This database enables a standalone application environment to provide the required services. Highly developed reporting for analysis with self service for all areas: In terms of presentation, efficient analysis and meaningful multimedia visualization techniques are essential. The system must be able to cope with the information needs of varied user groups. Quick and costefficient implementation: When implementing the Data Warehouse, an influential cost factor is its integration into an OLTP system and the straightforward 重慶 郵電 大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì) （論文）附件 附件 C：譯文 C12 loading of heterogeneous data. Alongside robust metadata man