SAP System Setup Training Course
Reveals How To Setup A Free SAP Developer System.
Learn SAP & Practice For Certification. Developer Tips Included:

Category Archives: SAP BI / BW

Dive Into SAP BI & BW Articles And Training

  • Introduction To The SAP BW Bex Analyzer

    SAPBWBExAnalyzerCourseSaleDiscount The Business Explorer Analyzer (BEx Analyzer) is the analysis and reporting tool of the Business Explorer that is embedded in Microsoft Excel. You can call up the BEx Query Designer in the BEx Analyzer, in order to define queries.

    Full Course – Click Here
    Subsequently, you can analyze the selected Info Provider data by navigating to the query created in the Query Designer and create different query views of the data. You can add the different query views for a query or add multiple queries to a workbook and save them there.

    You can save the workbook in your favorites or in your role on the BW Server. You can also save the workbook locally on your computer. Beyond that you can distribute the workbook by e-mail to recipients.

    In this document we will learn how to access and run BEx queries in addition to introducing some reporting functionalities used within BEx.
    Access BEx Analyzer

    To start the BEx Analyzer, choose StartAll ProgramsBusiness ExplorerAnalyze. This will open Microsoft Excel with the SAP BEx plugins enabled.

    Click on the Add-ins tab

    Add-Ins Tab

    Add-Ins Tab

    Choose the Open Icon in the BEX Analysis toolbox

    Open Icon In The BEX Analysis Toolbox

    Open Icon In The BEX Analysis Toolbox

    In the Opened menu click on “Open Query

    Open Query

    Open Query


    A window will pop up asking you to log on to the BW system. Insert your SAP BW username and password?Note that the User for BW client is different from the user in ERP client.

  • What Is A SAP BW DSO And ODS?

    [quote]An SAP BW DSO stands for Data Store Object and was previously called an ODS which stands for Operational Data Store. Why has the name changed? Don’t ask me! SAP seem to change the names of there product names more often than I have hot dinners. I am sure they have their reasons 🙂 .[/quote]

    A DSO is a SAP BW object primarily used to store detailed transactional data at a granular (document) level. Unlike multidimensional data storage objects like InfoCubes, DSO’s are designed as a 2-dimensional flat database table that contains key figures and characteristics. Data can be aggregated as well be over-written.

    There are 3 types of DataStore Objects that are generally used in BW systems: Standard, Write Optimized, Direct Update. In this article by Roula Sawma she focuses mainly on the architecture of these three types of DSO’s and the main functions of the objects themselves.

  • How To Create Exceptions In The SAP BW Query Designer

    [quote style=”boxed”]How do you highlight unusual deviations of key figure values in a SAP BW BEx Query? This question is often asked by concerned managers, marketing and sales people who want to spot these deviations as early as possible so they can act fast to changes in their business. One technique is by creating Exceptions in the SAP BW Query Designer.[/quote]Exceptions are used to identify deviations from pre-defined threshold values or intervals. Any data in your BW query that varies from these thresholds are marked with different colors in the query result. That way you can spot any extraordinary variations from expected results straightaway.

    Step By Step – Creation Of Exceptions

    Log in to query designer and choose the query for which you want to create the exception and click on the Exceptions button clip_image001 followed by New Exception.

    SAP BW Query Designer

    SAP BW - Query Designer

    SAP BW New Exception

    SAP BW - New Exception

    Press the Edit button in the properties area on the right of the window. The properties screen of the exception will then appear.

  • SAP Business Intelligence Software Is On The Rise

    Medium to large size businesses and companies have most probably heard of Business Intelligence, but they often do not know what it is really for and how it can help them.

    First, let’s get into the basics; Business Intelligence (BI) is a term used to describe software that is used to help companies and businesses understand the data they collect within their own business.

    How does this software help? In simple terms using these tools is like having business analysts, marketing experts, economists, and IT experts all rolled up into a single software solution.

    The Benefit of SAP BI

    Generally, businesses make use of this technology to help them with improvements with decision-making, cost efficiency and probabilities on business venture opportunities. Imagine this; you hold gigabytes of information related to your business performance but can never find the data you require fast enough to help with your decision-making.

  • SAP BW Tip 1 – How to identify the R/3 source for a SAP BW Extractor

    To resolve problems and answer queries, it is often necessary to compare R/3 data with the data reported through BW. Just identifying the datasource for an extractor can sometimes be a challenge. Here is some help… For Master Data, Text and Hierarchies take a look at table ‘RODCHABAS‘. This table contains entries of InfoObject/Basic Characteristics […]