SAP BW / BI

SAP BW/BI stands for Business Warehouse and Business Intelligence. Both BW and BI stands for the same purpose in SAP. It works as a Datawarehousing tool. SAP BW enables the companies to analyse the performance through reports etc which helps the companies to take crucial decisions in the presnet fierce competition. BW has been introduced by SAP in 1997. This provides consolidated data from external and internal sources of data into a single repository and provides data that can be used by enterprises for data management and archiving.

The following figure shows the SAP BW architecture

This graphic is explained in the accompanying text
Visit http://help.sap.com for further information.

Interview questions and training material in SAP BW / BI

SAP Transaction Codes by Module

SAP Transaction Codes List by Module

SAP BW Important Transaction Codes

Below are list important Transaction Codes in SAP BW by area. Datasources LO Cockpit Extractor related COPA Datasource Content Extractors Generic Datasource Bex Analyzer Tcodes BWA / BI Transaction Codes Transport Management Tcodes Delete Bex Quer...

SAP HANA Overview and Architecture

Hihg-Performance Analytic Appliance - Is an in memory appliance/database for SAP ERP systems. The data is stored in in memory instead of a regular database. The performance of HANA is much better than regular databases. For More Details Read : SAP...

Business Objects 4.0 - Overview

SAP Is going to release a new version of Business Objects Enterprise, the new version is BI 4.0. There is a lot of hype on this. There are some new products and many new features in existing products also. Below is the summary of important links, ...

How to automate flat file loads into SAP BW?

  Flat file uploads are pain in the neck in most cases. However, in many cases we do not have an option except to go with flat file uploads because of non SAP source systems or in cases where business users has to consolidate source file from diff...

How to change process chain (PC) status in SAP BW?

There are scenarios where you need to change status of a process chain or a particular step in process chain. It is easy to change the status of a step if it is data load, you can just change the status of request in the monitor and it will in tur...

SAP BW - Navigational Attributes - Importance, Usage, How to?

Navigational Attributes in SAP BW Navigational attribute is like any other master data attribute except that we can navigate (filter, drill down and selection) in reports on this characteristic. As you know we can navigate only based on characteri...

SAP BW : PSA and Changelog Deletion

  Best practice to have a strategy on PSA and changelog deletion. For PSA data below are the best practices in my view. PSA Deletion in SAP BW/BI(Business Intelligence) 1.    Transaction Data – Keep upto 45 days, delete the requests older than 45 ...

Tips and Tricks to improve SAP BW - BI performance

20 Technical tips and tricks to speed SAP Business Intelligence (BW - BI) query and report perforance by Dr. Bjarne Berg. This is wonderful presentation by Dr. Bajarne Berg whos is considered to be SAP BI guru. This presentationg gives 20 tips on ...

Information Broadcasting in SAP BI 7.0

This SAP document gives step by step instructions on troubleshooting information broadcasting in SAP BW/BI. Information broadcasting is used to send reports to users in email, publish reports to portal or for sending reports to printer. SAP has ad...

How to check SAP GUI front end ptach (FEP) version for BW or BI?

Many times strange problems with SAP GUI or bex reports relate to front end patch version. Problems like right clicking not working for some users, issue with decimal places etc. BI 7.0 added more confusion as we have now two front end patches (FE...

BI 7.0 Reporting Tools and New Features

  SAP BI 7.0 Reporting Tools Query Designer Analyzer Bex Web analyzer Report Designer Information broadcaster Query Designer   Bex Query designer has been completely rewritten in .Net VB with many new features. New features are highlighted below. ...

SAP BI Bex Reporting User Guide

This is complete reference document from SAP for Bex power users and administrators. It provides step-by-step instructions for Bex queries.

Technical Spec templates for infocube & multiprovider

Attached are templates for technical specs of infocube and multiprovider in SAP BW. It is always a good idea to have these specs ready before you start development. Download templates from attachments section below.  

Interview questions in SAP BW/BI

Interview questions in SAP BW/BI (Now Business Intelligence, formerly Business Warehouse). Good resource to test your knowledge and skills in SAP BW/BI.

Runtime error MESSAGE_TYPE_X when opening an infopackage in SAP BW

You sometimes run into error message 'Runtime error MESSAGE_TYPE_X' when you try to open an existing delta infopackage. It won't even let you create a new infopackage, it throws the same error. The error occurs in the FUNCTION-POOL FORM RSM1_CHECK...

How to trouble shoot poor performance of BO reporting tools?

In this blog post we will discuss on how to trouble shoot performance of business objects reporting tools like Voyager, Web Intelligence (Webi) etc. when running SAP BI reports on these tools. SAP has provided MDX interface for third party tools t...

SAP BW - How to migrate a 3.5 datasource to 7.0?

I am going to describe steps required to migrate a 3.5 datasource to 7.0 and restore it back 3.5 if the need arises or if there are any issues with 7.0 datasource. How to know if a datasource is in 3.5 or 7.0 version?Well, one way is to to look fo...

How and where to download SAP GUI and FEPS (Front End Patches) ?

You need to have access (should have S id) to SAP Service Marketplace to download SAP GUI and FEP (front end patches for SAP GUI). Follow below steps.1. Go to http://service.sap.com2. Click on SAP support portal and enter you user id and password....

BI 7.0 Reporting Tools - Migrating Bex Reports from 3.5 to 7.0

SAP has introduced new BI reporting tools and enhanced existing tools with BI 7.0 release. There is lot of confusion around these tools.  This blog post is an attempt to clear some of that confusion. 1.      Java Stack / ABAP stack – Do you ne...