SAP Business Warehouse

Recently added reviews + Add your review

SAP POINT-OF-SALE SOFTWARE
MULTICHANNEL RETAILING
WAREHOUSE MANAGEMENT SOFTWARE
WM module of SAP R/3
SAP Inventory and Warehouse Management
SAP CRM CUSTOMER-DRIVEN GROWTH
SAP Business Suite Software Applications for Every Business and Every Process
SAP - Enterprise Applications
SAP Solutions making your business A Best - run business
Benchmark SAP Business Information Warehouse (SAP BW)

SAP Business Warehouse

General information on SAP Business Warehouse
source: http://wiki.ittoolbox.com/index.php/SAP_Business_Warehouse

SAP BW is an Enterprise Data Warehouse system. The SAP Business Information Warehouse (SAP BW) not only provides the data warehousing functionality but also has a suite of business intelligence tools and therefore ,in effect, is a business intelligence platform. It provides the tools to perform the ETL (Extraction, Transformation, and Loading) of data from both R3 and other source systems, master data management, and data archiving. It has its own query and reporting tools, including an integrated version of Excel and a web based query tool. The web tools permit the construciotn of business cockpits with rich graphical content. SAP BW supports a variety of other access mechanisms through APIs that support XML, SOA, and MDX. It can distribute query results via e-mail and web pages using Information Broadcasting, and integrates with the NetWeaver Portal to support portal access and collaboration. All the relevant business information from productive SAP applications and all the external data sources can be integrated, transformed, and consolidated in SAP BW using the BI tools provided with the SAP BW and integrated in the Netweaver platform.

It supports multiple data structures, both conventional flat table structures, known as an ODS (or DataStore in the latest BW version) and InfoCubes to support OLAP analysis/reporting. It also provides a Data Mining toolset.

SAP BW can run on several different operating systems and databases. Several leading 3rd party tools integrate with SAP BW, including Ascential for ETL processing and Cognos, Business Objects, SAS, and others for query/reporting.

The business user can integrate content from SAP BW in SAP EP using the BEx Broadcaster, the BEx Web Application Designer, the BEx Query Designer, KM Content, the SAP Role Upload or the Portal Content Studio.

The current version is known as BI with SAP NetWeaver 2004s (aka BI 7.0) and entered general availability in May 2006. Earlier versions are still in wide use, e.g. BW 3.5, BW 3.0.

Purpose of a SAP BW
source: www.sap.com

"The reporting, analysis, and interpretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market. As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BW with the toolset provided. SAP BW provides flexible reporting and analysis tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis..."