SAP BusinessObjects Analytic Application Lincoln Lu
SAP Business Explorer 用户指南说明书
iAbout the T utorialSAP Business Explorer (BEx) provides you the set of tools to perform reporting, query analysis and to support strategic decisions. It is a complete product which provides different reporting procedures and an analysis tool to run queries and reports with SAP NetWeaver BI System. You can also use Business Explorer to broadcast the objects created under Business Explorer.SAP Business Explorer is a front-end tool to run different types of reports, analyze data and perform business planning on top of OLAP cubes which are stored in SAP Business Warehouse System.AudienceThis tutorial is prepared for those readers who wish to learn the essentials as well as the enhancements of SAP BW and various options for querying, reporting, broadcasting and integration for the objects created in SAP Business Explorer.This tutorial is intended to make you comfortable in getting started with SAP BEx Query Designer, Analyzer, WAD and Broadcaster along with integration options with SAP Business Objects.PrerequisitesThis is a simple tutorial and the concepts explained here can be easily understood. The readers should have a good understanding of SAP BW concepts. In addition, it will certainly help if you have ample business knowledge on various application areas and a little experience regarding the use of Queries, Reporting and Business Objects Reporting and Dashboard Tools.Copyright & DisclaimerCopyright 2018 by Tutorials Point (I) Pvt. Ltd.All the content and graphics published in this e-book are the property of Tutorials Point (I) Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republish any contents or a part of contents of this e-book in any manner without written consent of the publisher.We strive to update the contents of our website and tutorials as timely and as precisely as possible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt. Ltd. provides no guarantee regarding the accuracy, timeliness or completeness of our website or its contents including this tutorial. If you discover any errors on our website or inthistutorial,******************************************T able of ContentsAbout the Tutorial (i)Audience (i)Prerequisites (i)Copyright & Disclaimer (i)Table of Contents .................................................................................................................................... i i 1.SAP BEX – OVERVIEW . (1)Business Explorer – Features (3)Business Explorer – Product Suite (4)2.SAP BEX – ARCHITECTURE (8)Business Explorer – Architecture (8)Business Explorer – Integration with BO (10)3.SAP BEX – BEX QUERY DESIGNER (11)Business Explorer – BEx Query Designer Overview (11)Business Explorer – Functions in a Query Designer (12)Business Explorer – Creating New Queries (17)4.SAP BEX – BEX QUERY DESIGNER FEATURES (23)Business Explorer – Different Query Components (23)Business Explorer – Setting Query Properties (30)Business Explorer – Properties of Query Components (34)5.SAP BEX – BEX WEB (36)Business Explorer – Web Application Designer (36)Business Explorer – Analysis and Reporting (44)Business Explorer – BEx Web Analyzer Options (48)6.SAP BEX – BEX WEB INTEGRATION (51)Business Explorer – Pattern Options in BEx (51)Business Explorer – Integrating BEx and BW objects in the Portal (52)Business Explorer – BEx Mobile (53)7.SAP BEX – BEX ANALYZER (54)Business Explorer – Analysis Mode in Analyzer (55)Business Explorer – Design Mode in Analyzer (59)Business Explorer – Creating Planning Applications (61)8.SAP BEX – ANALYSIS FUNCTIONS IN BEX (66)Business Explorer – Performing Local Calculations (66)Business Explorer – Conditions (66)Business Explorer – Exception Reporting (67)9.SAP BEX – BEX OBJECTS (71)Business Explorer – Working with BEx Objects (71)Business Explorer – Opening and Saving Objects (74)10.SAP BEX – ACCESSIBILITY MODE (77)11.SAP BEX – INFORMATION BROADCASTING (79)12.SAP BEX – INTEGRATION WITH BO (81)SAP Business Explorer 1SAP Business Explorer (SAP BEx) provides you the set of tools to perform reporting, query analysis to support strategic decision. This tool provides a lot of queries and report designing functions. You can also develop Web applications on top of the SAP BI content using BEx Web Application Designer (WAD). Using the BEx Broadcast option, you can also broadcast the objects that are created using Business Explorer in email or in the form of a URL. This can also be published under the Knowledge Management Content on the NetWeaver portal.The BI content is available in SAP NetWeaver BI system and the data is analyzed by defining the queries in BEx Query Designer . The BEx WAD can be used to develop Web Application based on the BI content available in the SAP BW system. The BEx Report Designer tool can be used to create formatted reports for printing and presentation. The following tools are available under SAP Business Explorer:∙Analyzer ∙Query Designer ∙Report Designer ∙ Web Application DesignerLet us now understand in detail about the above given tools.AnalyzerThe Analyzer under Business Explorer is a reporting and designing tool , which provides integration with Microsoft Excel. You can use this tool to analyze data in an Info Provider under SAP BW. This can be used for planning by writing queries in a BEx Query Designer. Query DesignerThe BEx Query Designer can be used to analyze the data in InfoProviders under the SAP BW System. You can define the characteristics and the key figures in a Query Designer to analyze the data in any InfoProvider.Report DesignerA Report Designer can be used to create formatted reports by using extensive formatting options and these reports can be used for printing and can be generated in different formats such as – PDF.For example:∙Invoice ∙ Balance Sheets1.Sales Report, etc.Web Application DesignerThe Web Application Designer can be used to create web based applications using BI Content. These applications contain HTML pages which can be accessed via Web Browsers in the client machines or can also be published on the NetWeaver Portal under the Knowledge Management Content.To see the list of tools under Business Explorer, navigate to Program Files in your SAP system Business Explorer.Once you expand this folder, you can see the full set of Business Explorer tools as mentioned in the previous topics.23Business Explorer – FeaturesSAP Business Explorer is a frontend tool to design Data visualization on Business Intelligence information in SAP Business Warehouse system. It is a popular product that provides extensive report formatting and designing features along with Web Application Development and broadcasting of objects developed in Business Explorer.The following is the list of features that are provided by SAP Business Explorer BEx Suite: BEx Query Designer Key Features∙You can use queries in the BEx Query Designer for OLAP reporting and for enterprise reporting. ∙Queries can contain different parameters like variables for characteristic values, hierarchies, formulas, text, etc. ∙ In the Query Designer, you can apply a filter to restrict the whole query. Whiledefining the filter, you can add characteristic values from one or more characteristics or also key figures in the filter. All the InfoProvider data is aggregated using the filter selection of the query.∙ You can also use user-defined characteristics and determine the content of the rows and columns of the query. This is used to specify the data areas of the InfoProvider through which you want to navigate.∙You have an option of navigating through the query that allows you to generate different views of the InfoProvider data. This can be achieved by dragging any of the user defined characteristics into the rows or columns of the query. BEx Analyzer Key FeaturesBEx Analyzer is divided into two modes for different purpos es −∙ Analysis mode −It is used for executing OLAP analyses on queries.∙Design mode − It is used for designing the interface for query applications. Analysis Mode: You can perform the following tasks in the Analysis mode: ∙You can access the BEx Query Designer to define queries.∙You can analyze the InfoProvider data by navigating in the queries.∙You can use different functions like sorting, filtering, drilling, etc., which are common in OLAP.∙Distribution of workbooks with BEx Broadcaster.∙For advanced programming, you can embed your own customized VBA programs.∙You can save workbooks on the server/locally on your computer or into favorites. Design Mode: You can perform the following tasks in the design mode: ∙It can be used to design the query and you can embed different query design items like dropdown box, radio button groups, grid and buttons into your Microsoft Excel workbook.∙You can also customize your workbook with Excel’s formatting and chart functionality.BEx Report Designer Key FeaturesYou can perform the following tasks with the report designer:∙You can use formatting options to create report for printing and presentation.∙Different Layout functions that can be used to design corporate reports to meet business requirements.∙You can print web applications and reports in various formats.BEx Web Application Designer (WAD) Key FeaturesYou can perform the following tasks with the web application designer:∙You can use BEx WAD to generate HTML pages which contain BI specific contents such as, Tables, Maps and different Chart types.∙Web Applications can be published on the portal and can be accessed via a web browser.∙Use of standard markup languages and Web Design API.∙You can create and design web templates that can be saved and used in Web applications.Business Explorer – Product SuiteBy using SAP BEx frontend tools, you can leverage various reporting and analysis capabilities on the BI information in SAP Business Warehouse. This allows you to write4queries, format and design report for printing and presentation, develop web applications and broadcast these objects. The SAP BEx frontend tools can be installed with or without SAP GUI tools.In older versions, SAP Business Explorer was delivered with SAP GUI installer as an add-on tool. Business Explorer can be installed independently of SAP GUI for Windows 7.10 or higher or together with SAP GUI for Windows 7.10 or higher version. When the installation is done independently for BEx frontend tools, the following tools are available under BEx:∙BEx Analyzer∙BEx Query Designer∙BEx Report DesignerWhen the installation is done as a part of the frontend package with SAP GUI, you can also use BEx Web Application Designer (WAD). This tool is not available in Release 7.10 or higher if SAP GUI is not installed on the client machine.Hardware and Software RequirementsHardware Requirements: System should meet all the requirements for Microsoft Excel 2003 and Windows XP or Vista.Software Requirements:∙Windows XP or Vista∙Microsoft .Net Framework 2.0∙Microsoft Excel 2003 or higherTo perform the installation of the frontend tools, you need an installer or a CD which contains the setup file. The user should have an administrator privilege to run the installer file.Start SapBISetup.exe by using run as administrator option if you are not logged in with an administrator user. This will open the setup wizard as shown in the following screenshot.5When you click on Next, you need to select the frontend tools that you want to install. Under the Product Selection, you should select SAP Business Explorer.It also shows you the required disk space requirement.6SAP Business Explorer Make the selection of frontend tools, click on Next. You need to select the target drive where you want the installation to be done. Once you select the target drive, click on Next and it will start the setup installation.You can see the status in the Progress bar, and once it is 100% done, installation is completed for the frontend tools.Your Business Explorer is now successfully configured and ready to use. You can navigate to Business Explorer folder under Program Files and verify the installation by checking following tools shown in the screenshot given below.7SAP Business Explorer 8In this chapter, we will discuss in detail about the architecture of SAP Business Explorer and how it can be integrated with SAP BusinessObjects.Business Explorer – ArchitectureSAP Business Explorer consists of multiple tools that can be used to design queries and to perform report analysis, create web applications. The BEx Web Analyzer, Report Designer and Query Designer uses BI content in SAP NetWeaver BW system and communication happens using BI Consumer Service also called as BICS.The content developed using Business Explorer can be published in the NetWeaver Portal or can also be used in Composite Applications.The following image shows the functional area/ basic architecture of SAP Business Explorer suite:Components in SAP BEx Architecture2.At the bottom, you have SAP NetWeaver BI content in the BW system. The BI Content is managed in the form of OLAP Cubes from InfoProviders. An InfoCube is defined as a multidimensional dataset which is used for analysis in a BEx query. An InfoCube consists of a set of relational tables which are logically joined to implement the star schema.You can add data from one or more InfoSource or InfoProviders to an InfoCube. They are available as InfoProviders for analysis and reporting purposes.BI Consumer Service (BICS)BICS is used to connect the Business Explorer queries to SAP NetWeaver BW system. While creating an OLAP connection in IDT, you can use BICS connectivity to connect to the SAP BW system.The next in line is SAP Business Explorer Suite that contains multiple tools to perform query analysis and design and for Report formatting. The Web Application Development (WAD) can be used for application development and content can be published on to the portal or composite applications using Broadcasting Information.The BEx Analyzer provides an option for excel integration and you can analyze selected InfoProvider data and use it for planning by navigating in queries created in a BEx Query Designer.At the top, you have the presentation layer that is used to publish the objects that are created using SAP Business Explorer. The NetWeaver Portal can be used for publishing the9project or you can also use them in composite applications or analyze further using Microsoft Excel.Business Explorer – Integration with BOYou can integrate SAP Business Warehouse system with SAP BusinessObjects, then the use of Business Explorer increases in terms of reporting and querying options. SAP BusinessObjects provide a complete set of Analytical reporting, Dashboard and Data Visualization tools.The following integrations can be performed:∙You can integrate SAP BusinessObjects Dashboard (Xcelsius) tool to create an interactive dashboard on top of the BI Content in the SAP BW server.∙It is also possible to integrate a Crystal Report with BW that can be used to generate form based data on top of the BW content which can be used for printing purposes.∙It is also possible to call Web Applications created using BEx Web Application Designer in SAP BusinessObjects BI Launchpad and to store and publish them intoa BO repository server.To integrate a SAP BW system to BusinessObjects tools, you can create a BICS connection to the BEx query. You can select a Cube while creating an OLAP connection using the BICS connection.1011SAP Business Explorer 12In this chapter, we will discuss what a Query Designer is and understand its functions. We will also learn how to create new queries.Business Explorer – BEx Query Designer OverviewWith the BEx Query Designer you can analyze the BI Content by combining characteristics and key figures along with other query elements. You can pass different parameters- hierarchies, variables, text and formulas in the query.Filters can be applied in the query to restrict the data returned for the query. You can also insert query in workbook and that has been shown in the BEx Analyzer.To open the BEx Query Designer, navigate to the Business Explorer → Query Designer → Run.Select SAP logon screen, BW system as per your SAP GUI system.3.In the next window, you need to enter your Login Credentials. Enter the Client, User, Password and the Language.This will open the SAP Business Explorer NetWeaver Query Designer. You will not be able to see the home screen for the SAP BEx Query Designer.13Business Explorer – Functions in a Query DesignerOn the left side of the home screen of the Query Designer, you have the InfoProvider pane – it has the name of the Infocube and the list of all the characteristics and key figures available under that Infocube. It also shows all the Calculated Key figures and Restricted Key figures in the Infocube.In the middle pane, you have the Characteristics Restrictions– it shows all the filters that have been used in the query. You have 4 tabs under the characteristics restriction, which are –∙Filter∙Rows/Columns∙Conditions∙ExceptionsLet us now discuss each one of these in detail.Filter: Here you can see the list of dimensions in the query on which the filter has been applied to restrict the values in the query.Rows/Columns: In this tab, you can see the list of dimensions and key figures under rows and columns section. You can also see the free characteristics and preview under this tab.1415End of ebook previewIf you liked what you saw…Buy it from our store @ https://16。
SAP Business One 简介
友好的用户界面
SAP Business One® 中文版的界面采用用户熟悉的 Microsoft Windows风格，其清晰易懂、设计布局合理的界 面让用户使用起来非常方便、降低了软件的培训成本。 快捷的模糊定位搜索查询，个人的快捷功能键，个人的用 户菜单，鼠标右键的快捷功能菜单； 熟悉的窗口菜单栏、快捷图标栏、窗口蓝色标题栏，最大 化最小化窗口功能，简捷的日期输入格式，可实现全键盘 操作；
SAP Business One®商业价值
SAP Business One 为管理人员、员工，甚至客户和合作伙伴提供了 强大的功能。该解决方案实现的业务好处包括：
准确、最新的业务视图 -- SAP Business One 为您提供了单一的全面解 决方案，可实现所有关键业务流程的自动化和流畅化，包括财务管理、 银行业务、采购、生产、仓库管理和客户关系管理。 即时访问财务、生产和销售信息 -- 统一的直观环境可保证员工快速开展 工作 -- 获得他们所需的信息。与Microsoft Outlook 的集成使用户能够同 步日历、联系人和任务。同时，拖放和关联工具使用户能够通过单击鼠 标将不同的信息关联在一起，通过深入挖掘功能查看更详细的信息。 自动提示和响应关键业务活动 -- 业务所有者可以对意外事件进行管理 -特定事件发生时进行监控、通知，并采取行动。用户可以接收自动提示 ，轻松地查看更详细的信息，并且制订许可和工作流程序。
在线报警、审批功能
用户可以在系统中灵活配置工作流程。例如对销售过程中的报价审批，采 购过程中的审批等。根据用户配置，当销售折扣超出权限范围系统将自动 发E-mail或SMS信息到相应的管理者，并且可以对超出的折扣重新进行审 批。 凭证审批流程定义功能融合自定义报表条件的定义与权限管理，灵活应变 企业业务管理流程； 灵活的预警信息定义中心，配合查询向导使用，可定义自己要获得更有效 的业务信息； SMS、传真、MAIL等多途径获取来自系统的信息，大大扩展了获取信息 的能力；
SAP各模块介绍
SAP各模块介绍SAP在管理功能上，它共有12个系统模块,下面为你一一介绍, 希望对你了解SAP有所帮助。
（1）SAP MM模块（物料管理模块），主要有采购、库房与库存管理、MRP、供应商评价等管理功能。
（2）SAP SD模块（销售与分销模块)，其中包括销售计划、询价报价、订单管理、运输发货、发票等的管理，同时可对分销网络进行有效的管理。
（3）SAP AM 模块（资产管理模块)，具有固定资产、技术资产、投资控制等管理功能。
（4）SAP CO模块(管理会计模块)，它包括利润及成本中心、产品成本、项目会计、获利分析等功能，它不仅可以控制成本，还可以控制公司的目标，另外还提供信息以帮助高级管理人员作出决策或制定规划。
（5）SAP FI模块（财务会计模块），它可提供应收、应付、总账、合并、投资、基金、现金管理等功能，这些功能可以根据各分支机构的需要来进行调整，并且往往是多语种的。
同时，科目的设置会遵循任何一个特定国家中的有关规定。
（6）SAP PS模块（项目管理模块），具有项目计划、项目预算、能力计划、资源管理、结果分析等功能。
（7）SAP HR模块（人力资源模块），其中包括：薪资、差旅、工时、招聘、发展计划、人事成本等功能。
（8）SAP WF模块（工作流管理模块），可提供工作定义、流程管理、电子邮件、信息传送自动化等功能。
（9）SAP QM模块（质量管理模块)，可提供质量计划、质量检测、质量控制、质量文档等功能。
(10) SAP PP模块（生产计划模块)，可实现对工厂数据、生产计划、MRP、能力计划、成本核算等的管理，使得企业能够有效的降低库存，提高效率。
同时各个原本分散的生产流程的自动连接，也使得生产流程能够前后连贯的进行，而不会出现生产脱节，耽误生产交货时间。
(11) SAP PM模块（工厂维修模块），可提供维护及检测计划、交易所处理、历史数据、报告分析。
(12) SAP IS模块(行业解决方案），可针对不同的行业提供特殊的应用和方案。
SAP-Business-One系统使用手册
1. 选择公司 ......................................................................................................................... - 10 2. 汇率和索引 ..................................................................................................................... - 10 3. 系统初始化 ..................................................................................................................... - 11 4. 设置 ........................................................................................................................... - 12 5. 数据导入/导出 ............................................................................................................... - 12 6. 实用程序 ......................................................................................................................... - 12 7. 审批流程 ......................................................................................................................... - 12 8. 增强模块管理器窗口 ..................................................................................................... - 13 9. 警报管理 ......................................................................................................................... - 14 10. 发送消息 ....................................................................................................................... - 16 -
HANA是什么
HANA是什么HANA(High-Performance Analytic Appliance)高性能分析设备定义1：HANA是一个软硬件结合体，提供高性能的数据查询功能，用户可以直接对大量实时业务数据进行查询和分析，而不需要对业务数据进行建模、聚合等。
用户拿到的是一个装有预配置软件的设备。
至于HANA的云服务，只是对用户而言可以在不购买相关硬件的情况下享受HANA的高性能，而HANA云服务的背后还是需要更高性能的硬件支撑的。
定义2：基于内存计算技术的高性能实时数据计算平台，是全球一个发布商用的基于内存计算的产品，通过 SAP 内存计算技术优化应用，转变人们的思考、规划和工作方式。
SAP提供一系列前所未有的新型企业应用，其中结合了大量交易与实时分析能力，能够显著优化现有的计划流程、预测流程、定价优化流程等数据密集型流程。
借助 SAP 内存数据库，充分发挥实时数据的潜力。
SAP 内存数据库采用改进的数据压缩、多栏式数据存储和内存计算技术，支持新一代企业数据管理。
基于 SAP 内存工具的创新型业务分析功能可使您获得洞察力。
作为一款灵活、多用途且与数据源无关的内存工具，SAP 内存工具（SAP HANA）整合了通过硬件（由 SAP 领先的硬件合作伙伴提供）进行优化的 SAP 软件组件。
借助 SAP HANA，企业能够根据大量实时的详细信息分析业务运营状况。
软件方面HANA的内存数据库（SAP In-Memory Database, IMDB）是其重要组成部分，包括数据库服务器(In-Memory Database Server)、建模工具（Studio）和客户端工具（ODBO、JDBC、ODBC、SQLDBC等）。
HANA的计算引擎（Computing Engine）是其核心，负责解析并处理对大量数据的各类CRUDQ操作，支持SQL和MDX语句、SAP和non-SAP数据。
比较显而易见的一点是，HANA计算引擎要快速处理用户复杂的查询请求，快速返回查询结果。
SAPBEx-快速指南
SAP BEx - 快速指南SAP BEx - 概述SAP Business Explorer（SAP BEx）为您提供了一组工具来执行报告，查询分析以支持战略决策。
这个工具提供了很多查询和报表设计功能。
您还可以使用BExWeb应用程序设计器（WAD）在SAP BI容的基础上开发Web应用程序。
使用BEx广播选项，您还可以通过电子或以URL的形式广播使用Business Explorer 创建的对象。
这也可以在NetWeaver门户的知识管理容下发布。
BI容在SAP NetWeaver BI系统中可用，并且通过在BEx查询设计器中定义查询来分析数据。
BEx WAD可用于基于SAP BW系统中可用的BI容开发Web应用程序。
BEx报表设计器工具可用于创建格式化的报表以进行打印和显示。
SAP Business Explorer中提供了以下工具：•分析仪•查询设计器•报表设计器•Web应用程序设计器让我们现在详细了解上面提到的工具。
分析仪Business Explorer下的分析器是一个报告和设计工具，它提供与Microsoft Excel的集成。
您可以使用此工具在SAP BW下分析信息提供者中的数据。
这可以用于通过在BEx查询设计器中写入查询进行计划。
查询设计器BEx查询设计器可用于分析SAP BW系统下的InfoProviders中的数据。
您可以在查询设计器中定义特征和关键值，以分析任何InfoProvider中的数据。
报表设计器报表设计器可用于通过使用大量格式化选项创建格式化的报表，这些报表可用于打印，并可以生成不同格式，如- PDF。
例如-•发票•资产负债表•销售报告等Web应用程序设计器Web应用程序设计器可用于使用BI Content创建基于Web的应用程序。
这些应用程序包含可以通过客户端计算机上的Web浏览器访问的HTML页面，也可以在NetWeaver Portal的知识管理容下发布。
HANA产品特点和优势
HANA产品特点和优势HANA（SAP High-Performance Analytic Appliance）是德国SAP公司推出的一款高性能分析平台。
HANA的产品特点和优势可以总结如下：1.实时分析：HANA能够在实时数据流中进行高速分析，快速提供实时的决策支持。
相对于传统的数据分析工具，HANA具备更高的计算速度和响应速度，可以实现在毫秒级别完成复杂的查询和操作。
2.数据复杂性处理：HANA能够以高速度处理大量的数据，包括结构化和非结构化数据。
无论是来自关系型数据库、日志文件、传感器数据还是互联网数据，HANA都能够迅速提取、清洗和分析这些数据，帮助企业从中挖掘出有价值的信息。
3.内存计算：HANA以内存计算为基础，将数据存储在内存中，大大提高了数据的访问速度。
相对于传统的硬盘存储方式，内存计算具有更低的访问延迟和更快的计算速度，能够在短时间内完成大规模的数据分析任务。
4.多模型数据处理：HANA支持多种数据模型，包括关系型、文档型、图形型和时间序列型数据。
这样的特点使得HANA能够处理更加多样化和复杂的数据，满足不同业务场景下的数据分析需求。
5.数据集成能力：HANA具备强大的数据集成能力，能够与各种数据源进行无缝整合。
无论是来自SAP系统还是第三方系统的数据，HANA都能够快速将其加载到内存中进行处理和分析，实现数据的全面整合和统一管理。
6.高度扩展性：HANA是一个高可扩展的平台，能够根据业务需求快速进行横向和纵向扩展。
无论是单个节点的扩展还是集群的扩展，HANA都能够有效地满足大规模数据分析的需求。
7. 建模和数据分析工具：HANA提供了丰富的建模和数据分析工具，包括SAP BusinessObjects Suite、SAP Lumira和SAP Predictive Analytics等。
这些工具可以帮助用户进行高级的数据分析、可视化和预测，提供更加直观和全面的数据分析结果。
8. 跨平台支持：HANA支持多种操作系统和云平台，包括Windows、Linux、SAP HANA Cloud和Amazon Web Services等。
SAP商务分析解决方案完整版
Middle East and Africa
North America Western Europe Japan Eastern Europe 3.7% 3.0% 6.7%
18.3%
17.8%
13.2%
11.6%
Gartner Market Share Analysis: Business Intelligence, Analytics and Performance Management Software, Worldwide, published March 2011
Challenge Rank
Complexity of BI tools and interfaces
Cost of BI software and per-user licenses Difficulty accessing relevant, timely, or reliable data Insufficient IT staffing or excessive software requirements for IT support
Column Databases
Up to 1,000x faster More data in less space
Calculation Engine Business Intelligence Query Results
Query
Data Warehouse Data Data Warehouse Warehouse
Lower Memory Costs
16
A Revolution is On Its Way…
Credit Suisse, ―The Need for Speed‖
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
商务智能应用的现状 什么是商务分析（BA）？ SAP BAA能解决哪些问题 SAP BAA产品介绍 SAP BAA产品演示
SAP BAA产品营销策略
© 2010 SAP AG. All rights reserved. / Page 11
到2010年7月已经完成的BAS产品
医疗卫生行业 SAP BusinessObjects 医疗卫生质量管理（HQM）
创新的技术
的专家
内存计算技术、先进的消费模型、
移动技术、SOA架构和云计算…
SAP 分析应用为客户带来的益处
降低成本和实施复杂性的同时，加速按时实现价值
客户分析应用
组件 实现价值时间 成本/风险 最佳实践 支持
横向应用的软件工具 数月 成本高，风险变化 有限 自己摸索实现
SAP BAA的分析应用
打包的、按照行业应用为目标设计的软件 几周 成本低，风险可控 嵌入行业最佳实践 由厂商的专家进行维护和支持
6. 有人称商务智能是决策支持系统，但是，项 目实施部门很难知道领导需要什么，所以开 发完成后往往不能得到领导的认可 7. 由于对需求了解的不充分，使得项目的周期 延长，成本增加，风险加大 8. 项目成功的几率非常低
© 2010 SAP AG. All rights reserved. / Page 4
银行行业 SAP BusinessObjects 银行业预算和合并报表
银行行业 SAP BusinessObjects 企业风险报告
公共事业行业 SAP BusinessObjects Rapid 国防能力评估
© 2010 SAP AG. All rights reserved. / Page 12
方案描述
对于信用风险、运营风险、流动风险的整合报告和 分析模板，采用最佳实践，实现银行风险的管控 银行进行计划、预算、合并报表应用的统一平台解 决方案 提供对于运营、财务、质量度量的探索，确保复杂 医疗设备管理的有效性 提供医疗行业的计划、预算、合并报表的统一平 台，确保实现端到端的计划和报表解决方案
“对于打包的分析应用，按需要的应用将继续增长，它不但提供需求的功能，而且还提供最佳实践 和专家的配置”
- Gartner 1/10
© 2010 SAP AG. All rights reserved. / Page 9
SAP BAA的主要优势
优化商务的行业和部门级解决方案
快速实现价值
完整的预置了行业应用的解决方案
Promotion Effectiveness Improves Account & Trade Promotion Management Decisions
“从摸索到实现”方法成本的1/2
上线按周计算，而不是数月
可交互执行的探索
按业务角色划分 向前看，基于事实的决策
© 2010 SAP AG. All rights reserved. / Page 13
SAP 商务分析应用的远景
预置行业分析解决方案，满足内部部署、按需部署和 设备部署
企业应用专家
BI 和 EPM产品 Porta? Felis a? 的行业领导者
Semper pede?
企业商务应用厂商领 导者
分析应用
预置行业和部门应用 数据来源于任何系统 可以在任内部部署、按需部署、设备部署 突破技术创新 无缝将战略和执行360度结合起来
© 2010 SAP AG. All rights reserved. / Page 2
内容安排
商务智能应用的现状 什么是商务分析（BA）？ SAP BAA能解决哪些问题 SAP BAA产品介绍 SAP BAA产品演示
SAP BAA产品营销策略
© 2010 SAP AG. All rights reserved. / Page 3
业务角色
部门风险管理副总，首 席风险官、风险委员会 财务副总、财务计划部 门、审计官 CEO, CIO, CTO, CMIO, CMO, VPs CFO, 财务副总、预算 副总 业务副总 店铺运营副总 销售副总 生产副总 市场副总 品牌营销副总 销售副总
银行计划和合并报表
医疗质量管理
医疗行业预算和合并报表
快消品货架有效性分析
贸易促销有效性分析
电信行业客户行为分析和保持
提供给电信行业的可视化解决方案，主要解决客户流 CMO 失的因素分析，增加市场营销战役的绩效 销售副总 客户服务副总 提供完整的战力装备评估的视图，可以钻去到子部 门的功能，确保快速反应，和战力的布局 参与士兵 首席指挥官
国防装备评估快速分析
商务分析的方法
■满足行业和部门专门需求的、对事后分析
、事中预警、研究和事先预测的解决方案
■对于指定的商务目标，确保能实现从战略
按照静态报表分发给相关的人
■结构化的通用绩效报告，主要关注消费者、
到执行闭环的一致行动
■决策者可以直接利用分析结果，还可以和
或者财务的指标
其他决策者进行交互式探讨分析
*Source: Thomas H. Davenport, The New World of “Business Analytics”, March 2010
SAP BusinessObjects 分析应用产品介绍
鲁百年博士、教授
SAP BusinessObjects中国区首席顾问
2010年12月13日
鲁百年:
应用数学博士、教授。有特殊贡献的专家，享受政府 津贴。北京大学、清华大学、美国肯尼迪大学、国家行政 学院特聘MBA咨询顾问。现任SAP BusinessObjects中国区首 席顾问，2006、2007年中国培训十佳，2008年首届黄炎培职 业教育管理奖。 曾在美国SAS软件研究所任北方区销售总监、高级咨询顾问、在创智 科技股份有限公司CRM事业部任副总裁、美国Hyperion公司高级销售经理、 北京Oracle软件有限公司高级咨询顾问经理、美国BO公司中国区售前咨 询顾问总监。 在英国剑桥大学和Sussex大学学习两年。曾任中国青年计算数学会常 务理事。在国内外发表学术论文110余篇，主持过两项国家自然科学基金 资助的项目和一项回国人员基金，成果获省、部级科技进步一等奖、二 等奖。出版《如何做好大客户的战略营销》、《全面企业绩效管理》、 《获得大订单的三部曲》和《客户也疯狂》光盘各一套，北京大学出版 社出版《全面企业绩效管理》、《大客户战略营销》、《说服老板签大 单》和《客户也疯狂》专著四本。
© 2010 SAP AG. All rights reserved. / Page 6
内容安排
商务智能应用的现状 什么是商务分析（BA）？ SAP BAA能解决哪些问题 SAP BAA产品介绍 SAP BAA产品演示
© 2010 SAP AG. All rights reserved. / Page 7
仪表盘、报告、 有帮助的分析
第3方 系统
Web Intelligence
自己开发 系统
Governance Risk & Compliance
SAP BusinessObjects产品
技术内容
服务
关系结构 预置的过程方法 工作模板数据库 Business Objects语义层 Web Intelligence报告 Xcelsius 仪表盘
医疗预算的有效性和战略财务的有效性
零售行业销售分析
不准确的库存，导致很难掌握客户的需求， 实时对销售点数据分析，了解销售的趋势，决策企 更不知道何时补货，最佳补货量. 业的最佳采购趋势 缺乏下游需求约束的直观整体视图，从 而很难解决过时存储的问题 零售行业几乎不能度量促销贸易花费的 有效性。I 减少客户的流逝，增加企业的收入 在减少渠道库存的同时，还要保证供货的充足，确 保快消品企业通过提高货架有效性分析，实现降低 丢失销售机会的发生 了解促销的影响因素，度量促销贸易基金花费的有 效性解决方案
SAP BAA标准架构
大规模、可扩展的标准化的架构设计
多个离散数据源
分析应用架构
行业、部门数据模型 BusinessObjects 语义层 etc. Data Federator
Clean Master Data
Xcelsius, Explorer…
BPC, PCM & Strategy Mgmt…
SAP BAA产品营销策略
© 2010 SAP AG. All rights reserved. / Page 15
SAP BAA分析应用举例
快消品货架有效性分析应用
可视化与语义层
On-Shelf Availability Analysis
1 语义层 3 仪表盘 5 报告
数据 / 连接
72 QaaWS连接 15 界面表 47关系星型结构表 15 Data Federator虚拟表 1 演示数据库文件
虚拟数据源表结构 映射规则 虚拟目标结构 结构定义 SAP的界面文件 管理员手册 用户手册
评估 数据源和KPI映射 交付和实施 项目管理 培训
© 2010 SAP AG. All rights reserved. / Page 14
内容安排
商务智能应用的现状 什么是商务分析（BA）？ SAP BAA能解决哪些问题 SAP BAA产品介绍 SAP BAA产品演示
公共事业行业 SAP BusinessObjects 政府预算和合并报表
SAP BAA10个产品内容和解决问题
专注于行业和角色的解决方案
分析应用
银行企业风险管理和报告
业务问题
由于存在企业的信息孤岛，导致很难获 得企业的整体风险暴露 由于缺乏整合的数据和跨银行的预算流 程，导致预算复杂且时间周期太长 基于赔偿的绩效