Enterprise Reporting, Query, and
Analysis 
This scenario shows the ways in which business experts can use the reporting and analysis tools available in SAP NetWeaver Business Intelligence (BI) to provide BI information customized for the different categories of user within a company.
The tools in the BI Suite (subsequently referred to as Business Explorer (BEx)), allow business experts to create and distribute the necessary reports and analyses. These tools are fully integrated and have user-friendly, intuitive interfaces.
You can perform a detailed analysis of BI information both on the Web and in MS Excel. You can also define formatted reports that are print-optimized or optimized for presentations.
Web applications and formatted reports can be easily converted into PDF files and printed.
Users access BI information from the portal. Users can execute information broadcasting functions to send this information by e-mail, for example, or distribute it to KM folders and collaboration rooms.
Scenario Architecture
The following graphic provides an overview of the architecture:
The BI applications are created with the various tools of the Business Explorer Suite and can be published to the SAP NetWeaver Portal.
The BEx Query Designer is available to create queries. These can be used for Microsoft Excel-based analysis in BEx Analyzer or for Web-based analysis in BEx Web. The data analysis can also be based on InfoProviders from SAP NetWeaver BI or on multidimensionally stored data from third-party tools.
In BEx Web, the Web Application Designer is available to create Web applications, the Report Designer to create formatted reports, and the Web Analyzer for Web-based ad-hoc analysis. Using information broadcasting it is possible to distribute the generated BI content by e-mail or publish it to the portal.
Required Usage Types for SAP NetWeaver
In order to use this scenario, you require the following technical SAP NetWeaver usage types:
· BI Java components (BI Java)
· Business Intelligence (BI)
· Enterprise Portal (EP)
· Application server ABAP (AS ABAP): for Internet Graphics Server (IGS)
· Application server Java (AS Java): for Adobe server
Furthermore you require the standalone engine TREX.
Integration with Other IT Scenarios
Implementation of
the Enterprise Data Warehousing scenario is a prerequisite for the
Enterprise
Reporting, Query, and Analysisscenario. This scenario includes all data modeling,
data staging, transformation and metadata management processes; from
administration and performance management, to user management. For more
information, see 
Enterprise Data
Warehousing.
Scenario Variants
The scenario consists of the following components:
Variants |
Description |
The scenario variant Query, Reporting and Analysis shows how business experts can create BI applications with the Business Explorer tools and publish them to the portal. |
|
Using the BEx Web Analyzer, business experts can analyze ad-hoc queries and create query views for various data sources. |
|
With the Microsoft Excel Integration scenario variant, business experts can use the BEx Analyzer to create Microsoft Excel-based BI applications and workbooks and use these to analyze data. |
|
Information broadcasting allows you to make objects with BI content available to a wide spectrum of users, according to your own requirements. |
More Information
The following role-specific guides can help you in applying these scenarios:
User Roles and Tasks |
Guide |
Installation and upgrade |
For more information, see service.sap.com/instguides ® SAP NetWeaver ® Release 2004s ® Installation or Upgrade. |
Configuration |
For more information, see the SAP Solution Manager. |
Administration |
Technical
Operations Manual: |
Security |
Security Guide: Enterprise Reporting, Query, and Analysis |
Development |
Developers’
Guide: |
Power-User Activities |
Power User Guide:
|