SAP BW (Business Warehouse) Hints and Tips

The SAP Business Warehouse (SAP BW module) is an enterprise-wide information hub. It enables you to analyze data from R/3 applications or any other business application, including external data sources such as databases and the Internet. The SAP Business Information Warehouse also offers easy integration with other New Dimension products, such as the SAP Advanced Planner and Optimizer (SAP APO), the SAP Business to Business (SAP B2B), and the SAP Strategic Enterprise Management (SAP SEM). Additionally, the Business Information Warehouse is a core element of SAP’s MySAP.com’s reporting strategy. 

The Business Information Warehouse is a comprehensive end-to-end data warehouse solution with optimized structures for reporting and analysis. To help knowledge workers quickly “mine” the business data in an enterprise, BW is equipped with preconfigured information models and reports, as well as automatic data extraction and loading methods. With an easy-to-use Microsoft Excel based user interface, you can create, format, and analyze reports. Built for high performance, the Business Information Warehouse resides on its own dedicated server. Online Transaction Processing (OLTP) and reporting activities are therefore separated, and system performance is not compromised.

Table of Contents

SAP BW Forum
0coorder_0103_Hier-Missing-Hierarachy-node

SAP BW Certification Tips
SAP BW Certification Exam - My Experience

Transaction Codes
PDF: Important T-Codes for BW Consultant

Question
SAP BW Interview Questions
SAP BW Questions - Some Real Question
Self-Evaluation Questions With Answers in SAP BI
Job Interview Questions And Answers For SAP BW #1
Job Interview Questions And Answers For SAP BW #2
Job Interview Questions And Answers For SAP BW #3

SAP Business Information Warehouse
The benefits of SAP BW
SAP BW Cookbook
Examples of Characteristics
BW without SAP

BW Task
Responsibilities of BW Data Architect
Production Support Work In BW

Extractor
The Extractor Types

Imports
Import All Button on STMS

Comparison
Different Types of Delta Updates
Difference Between Info Cube and ODS
Explain Multiprovider and Infosets
Difference Between BW3.5 and BI7.0
Comparison of BW Reporting Over R/3 Reporting
Between ODS and Infocube and Multiprovider

Updates
Different Types in LO
Steps in LO Extraction
Start Transfer and Update Routines
Start Routine and Update Routine
Start Routine and Return Table Synchronization
Table That is Used in Start Routines
Start Routines in Your Project
System That Can Serve as Sources of Data
Delete BEX Query
Return Tables
Difference Between V1 V2 and V3 Updates

InfoStructures
Create a Connection with LIS Infostructures

Process Chains
The Process Chains
Process Types and Variant

SAP BW FAQ
Web Application Server - web site cannot be found
How to do performance tuning on InfoCube??
Suggestions for Automating Loads
Removing Excel Macros After Saving as Excel Workbook
Reporting capabilities of SAP BIW
Loading Transactional Data
Customizing for extraction
Standard Infocubes for SD
Invalid source system name entered
Details of infocubes 0UCSA_C01, 0UCTS_C15
Replacement Path in Variable Reporting
Regarding Repairful Request
Delta Update for Generic Data Sources
About The Use Of Setup Tables
Loading Data to Infocube using Flat file
Explain Queued Delta Update Method

SAP BW Issues/Problems
SAP BW Discussion Forum

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips

(c) www.gotothings.com All material on this site is Copyright. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
All product names are trademarks of their respective companies.  The site www.gotothings.com is in no way affiliated with SAP AG. 
Any unauthorised copying or mirroring is prohibited.