SAP BW / BI

Download SAP BW Documents , tutorials, step by step instructions, how to documents, user guides and other SAP BW resources from downloads section.

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

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 turn c...

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 characteristi...

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 ...

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 imp...

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 added...

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 (FEP) ...

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. L...

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_FO...

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 to a...

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 for s...

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. So...

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 y...

SAP BW - Step by step guide Ebook by Fu and Fu

This is the first book I used to learn and practice SAP BW. This gives step by step instructions on how to create an infocube, infoobject, ODS, query etc. This is a very good hands on book for beginners who want to practice BW.

Migrating to BI Bex 7.0 tools

Very good SAP document on migrating to SAP bex 7.0 tools.

Bex web analyzer for ad-hoc queries

Bex web analyzer is a standard web template provided by SAP for ad-hoc query analysis. Users can access this web template via web and run their ad-hoc queries without saving them. There are some restrictions on web analyzer when compared to regular query designer. However, bex web analyzer is more than sufficient for ad-hoc query analysis.

 

Interview Questions on SAP

Set of sample interview questions on SAP

SAP BW all Important gathered FAQS t

The given FAQs are already posted and also posted in single document with BI Features also

SAP Categories

Popular Articles in SAP