Tag Archives: bw

  • Is ABAP Near The End Of Its Life?


    I receive quite a few emails from students asking for advice on what area of SAP is the most lucrative, what is the best module of SAP to learn and so on. They are all good questions and I always give my point of view. Today I received an email from a student, let’s call […]

  • Structuring SAP BW Queries for Re-Use


    Structures When dragging Characteristics from the InfoProviders into the Columns section of the Query Designer, new objects are created which are named Key Figures. The icon next to the Key Figures section represents a Structure. This is how basic structural components of a BEx Query are grouped together. Key Figure Structures allow the user to […]

  • Overview Of The SAP BW Reporting Tools Landscape


    The purpose of the overview of the SAP BW Reporting tools landscape is to look deep into the BEx Query Designer to help us understand how we create our reports and where they can be used. The SAP BW Reporting tools landscape consist of the following structure: InfoProvider, InfoCubes InfoObjetcs DSOs InfoSets Virtual InfoProviders MultiProviders […]

  • SAP Training Weekly Summary for 2012-06-23

    Nice list of iOS app review sites http://t.co/tWlcxIf2 # How To Change And Create SAP HR Infotype Screens http://t.co/C3EhW6rQ # Beginner Guide – SAP ABAP Training http://t.co/dDtPNe8K # 66,000,000: Number of Mac users … Who'd a thunk it! # 7,000,000,000: Number of push notifications sent daily 1,500,000,000,000: Number of push notifications sent to date # […]

  • What Are The Functions And Architecture Of A DSO

    DSO or Data Store Object is a SAP BW object primarily used to store detailed transactional data on an atomic level. Unlike multidimensional data storage InfoCubes, it’s designed as a 2-dimensional flat database table that contains key fields and data fields. Data is normally held in a DSO for several years. There are 3 types […]

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