BI Suite: Business Explorer
Purpose
The SAP NetWeaver Business Intelligence Suite, the Business Explorer (BEx), provides flexible reporting and analysis tools for strategic analyses and decision-making support within a business. These tools include query, reporting, and analysis functions. As an employee with access authorization, you can evaluate historical or current data at various levels of detail and from different perspectives; both on the Web, in the portal and in Microsoft Excel.
You can also use the Business Explorer tools to create planning applications, and for planning and data entry in BI Integrated Planning. More information: BI Integrated Planning.
You can use BEx Information Broadcasting to distribute business intelligence content by e-mail, either as precalculated documents with historical data, or as links with live data. You can also publish this content to the portal (in Knowledge Management folders or collaboration rooms).
SAP NetWeaver 7.0 provides two versions of the following tools:
■ BEx Query Designer
■ BEx Web Application Designer
■ BEx Broadcaster
■ BEx Analyzer
This documentation describes the BEx tools in SAP NetWeaver 7.0. For more information about the SAP BW 3.5 BEx tools, see help.sap.com/nw04 → SAP NetWeaver → Information Integration → SAP Business Information Warehouse → BI Suite: Business Explorer.
Features
The following overview shows the functional areas of Business Explorer:
Query, Reporting and Analysis
The data in SAP NetWeaver BI is divided into self-contained business data areas (InfoProviders). You analyze the data of the BI system by defining queries for InfoProviders in BEx Query Designer. By selecting and combining InfoObjects (characteristics and key figures) or reusable structures in a query, you define how you will evaluate the data in the selected InfoProvider.
Analyzing data based on multidimensional data sources (OLAP reporting) makes it possible to analyze multiple dimensions simultaneously (like time, location, and product). You can implement any number of variance analyses (such as plan-actual comparison, fiscal year comparison). The data, which is displayed in a table, acts as the starting point for a detailed analysis, which can answer a variety of questions. A range of interaction options, such as sorting, filtering, swapping characteristics, and local calculations allow flexible navigation through the data at runtime. You can also display data graphically (such as bar charts or pie charts). You can also evaluate geographical data (for example, characteristics such as Customer, Sales Region, and Country) on a map. You can also use exception reporting to determine deviating and critical objects, to broadcast messages on deviating values by e-mail, or to distribute the messages to the universal worklist in the portal.
You can perform a detailed analysis of BI information on the Web and in Microsoft Excel.
BEx Web
Web Application Design
Web Application Design allows you to use the generic OLAP navigation in Web applications as well as Business Intelligence Cockpits for simple or highly individual scenarios. You can use standard markup languages and Web Design API to implement highly individual scenarios with user-defined interface elements. Web application design comprises a broad spectrum of interactive Web-based business intelligence scenarios that you can adjust to meet your requirements by using standard Web technologies.
BEx Web Application Designer
You can use BEx Web Application Designer, the desktop application used to create Web applications, to generate HTML pages that contain BI-specific content such as tables, charts, or maps. Web applications are based on Web templates that you create and edit in the Web Application Designer. You can save the Web templates and access them from the Web browser or the portal. Once they are executed on the Web, Web templates are referred to as Web applications.
BEx Web Analyzer
BEx Web Analyzer is a standalone, convenient Web application for data analysis that you can call using a URL or as an iView in the portal. In Web Analyzer, you can open a data provider (query, query view, InfoProvider, or external data source) and use ad hoc analysis to create views of BI data (query views) that you can then use as data providers for other BI applications. You can also distribute and save the results of your ad hoc analysis as required.
Report Designer
Report Designer is an easy-to-use design tool that you can use to create formatted reports that are optimized for presentation and printing. Report Designer provides extensive formatting and layout functions that you can use to create corporate balance sheets or HR master data sheets to suit your needs, for example.
PDF Generation
The integrated PDF generation function allows you to print Web applications and reports in various formats. More information: Creating Print Versions of BI Applications.
BI Patterns
BI patterns are Web applications that are tailored to the requirements of particular user groups. BI patterns are used to provide a uniform display of content from BI. You can configure BI patterns to a certain extent using the Pattern Wizard from the Web Application Designer.
BEx Analyzer
BEx Analyzer is an analysis, reporting, and design tool in Business Explorer, which is integrated into Microsoft Excel. In BEx Analyzer, you can analyze selected InfoProvider data and use it for planning by navigating in queries created in BEx Query Designer. You can use the context menu or drag and drop functions to do this.
You can design the interface for your queries by inserting design items such as dropdown boxes, radio button groups, and pushbuttons into your Excel workbook. A workbook thus becomes a complete query application.
See Analysis & Reporting: BEx Analyzer.
BEx Information Broadcasting
BEx Information Broadcasting allows you to make objects with content from business intelligence available to a wide spectrum of users, according to your requirements.
Using BEx Broadcaster, you can precalculate Web templates, queries, query views, reports, and workbooks and publish them to the portal, distribute them by e-mail, or print them. In addition to the precalculated documents that contain historical data, you can also generate online links to queries and Web applications.
The Business Explorer portal role illustrates the various options that are available when you are working with BI content in the portal.
More information: Information Broadcasting.
Integration in the Portal
You can integrate business content from BI seamlessly in the portal. Integration is carried out using BEx Broadcaster, KM content, SAP Role Upload, or the Portal Content Studio. Depending on the type of integration, you create objects with various display types in the portal. More information: Overview: Integration and Display Types for Content from BI.
The portal allows you to access applications from other systems and sources, such as the Internet or intranet. Using one single entry point, you can access both structured and unstructured information. In addition to content from Knowledge Management, business data from data analysis is available from the Internet and intranet.
More information: Integrating Content from BI into the Portal.
Integration with SAP BusinessObjects
Integration with SAP BusinessObjects broadens the scope of the reporting tools in Business Explorer. This integration comprises the following:
● Integration with Xcelsius Enterprise to visualize BI data in dashboards
● Integration with Crystal Reports to create form-based reports based on BI data
● More information: Integration with SAP BusinessObjectsapurl_link_0001_0015_0015.