Accommodate a Broader Range of BI Users

For many companies, business intelligence (BI) now goes well beyond strategic, long-term, centralized analyses dedicated to analysts’ intensive data crunching. Increasingly, users across the enterprise are looking to BI solutions to support day-to-day decision-making as well, and IT teams are faced with providing the infrastructure to support varying levels of detail and data freshness. Users of a BI solution do require different tools for reporting and analyses: analysts need sophisticated tools for advanced analysis and ad hoc data exploration, while executives require personalized information, an intuitive user interface, and options for in-depth analyses of summary data. General information consumers may have little interest in digging around in the raw data itself but want simple, accessible data “snapshots” to support their work.

End-to-end approach

To meet these wide-ranging demands, organizations often consider a patchwork of applications, tools, and interfaces. Of course, the greater the number of technologies in any infrastructure, the greater the complexity – resulting in higher implementation expenses up front and decreased adaptability over the long haul. There’s also the need to avoid business intelligence stovepipes, individual, isolated data structures, and technology silos across the system landscape.

Overview of SAP BW Key Functional Areas
Overview of SAP BW Key Functional Areas

SAP offers a single, end-to-end solution to address these challenges: mySAP Business Intelligence (mySAP BI). At its heart is SAP Business Information Warehouse (SAP BW), which covers the functional areas listed in the figure beside. From the start, SAP BW has followed an end-to-end approach to business intelligence and supports tight integration with the overall system landscape.
To take this concept of integrated and embedded business intelligence to the next level, SAP BW is now part of SAP NetWeaver, SAP’s integration and application platform. This article presents just a few of the benefits that SAP BW draws from the other components of SAP NetWeaver, reaching both into the areas of people and process integration.

People integration: access role-specific information

To deliver information in a personalized, targeted manner to a variety of end-users, SAP BW draws on the SAP Enterprise Portal (SAP EP). Here users find convenient access to tools and information through a single point of access, with a single sign-on.
SAP BW and SAP EP are both part of the overall SAP NetWeaver architecture. They are not just linked – they are seamlessly integrated on several levels, and share a number of concepts and technologies. The result? SAP BW users can take full advantage of the SAP Enterprise Portal’s efficiencies, for example:

  • Many end-users are already assigned a BI-related role. Now these same roles can be easily copied to Enterprise Portal roles, enabling one consistent role concept across both systems. For the user, this means a single point of access to all relevant information, and for the IT team, more efficient management of user roles throughout the enterprise.
  • SAP BW supports iViews – the very same programs used in the portal framework for retrieving data from content sources (refer to the figure opposite). iViews allow users to access information from sources inside the company and on the Internet for display in the SAP Enterprise Portal. SAP BW users can also easily create their own iViews for highly customized information gathering.
  • SAP BW is integrated with the unification features of SAP EP. Unification allows disparate applications and information sources to work together in the Enterprise Portal and is the basis for the Drag&Relate functionality for moving information and easily navigating across application boundaries.

The tight, multi-level integration of SAP BW and SAP EP offers users an unprecedented opportunity to combine business intelligence information (reports, charts, OLAP analyses, etc.) with unstructured information (Web sites, third-party market research, documents) and information from operational systems (such as the ability to directly enter transactions into an SAP R/3 system). So if data indicates reduced revenue from a key customer, users can now view attached documents or reports from colleagues and third parties to explain why they’re seeing this drop-off.
The collaboration and information-sharing features end-users experience with a combined SAP BW and SAP EP approach also include a comprehensive collection of technologies, including shared email, threaded discussion and document stores, and online chats.

Process integration: meet users’ need for up-to-the-minute data


For strategic or tactical decision support, the traditional batch-oriented extraction, transformation, and loading (ETL) approach to acquiring data serves a particular set of users quite well. But as organizations expand their support to operational users – who need up-to-date data – another set of technologies comes into play: Enterprise Application Integration (EAI), which typically involves a set of technologies that enable applications to communicate and share information in real time through adapters, middleware, and message brokers. The figure beside offers a side-by-side comparison of the two approaches.
SAP BW supports both ETL and EAI via the SAP Exchange Infrastructure (SAP XI), the component for application integration that forms the process integration layer of SAP NetWeaver. SAP XI provides the Integration Broker – which uses adapters to talk to different application components and ensures connectivity to business partners, exchanges, third-party systems, and SAP solutions – and Business Process Management – which provides modeling capabilities for business processes and allows companies to combine applications into adaptive end-to-end processes spanning the entire value chain. When using SAP XI’s process-integration capabilities, the data warehouse or operational data store is simply another subscriber to the real-time data being distributed by the Integration Broker.
With both batch and real-time data acquisition capabilities, companies can make better use of their data. And with the two technologies working together in a single environment using one metadata model, companies can easily combine historical information and real-time data to provide a richer user context with consistent data from a variety of sources.
SAP BW draws from and utilizes the capabilities of the other components in SAP NetWeaver for more efficient and targeted information access for the users, forming a platform that represents the next major step in the evolution of business intelligence. For more information on SAP BW and SAP NetWeaver, visit and

Source: SAP Insider

Gunther Rothermel
Gunther Rothermel