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

Tag Archives: bex

  • 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 […]

  • Business Analytics With The BEx Analyzer

    The term ‘Business Analytics‘ (BA) is used in many different contexts. Be it specific skills, software applications or business practices they all share a common theme which is being able to analyse and explore data in an iterative fashion by using drill down, filters and often measuring against specific key performance indicator (KPI’s).

    We are not just talking about static reporting here, BA is the process that we use to really dig deep into a datasets to find new trends by investigating historical information and in some cases applying statistical methods to drive out possible future projections.

    It is this type of reporting that help some of the best companies in the world to understand their own market trends and plan strategic goals for the future to enable them to stay ahead of their competitors.

    SAP has a rich software tool set that businesses use to carry out their business analytic processes of which the SAP BEx Analyzer is still the most popular.

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

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