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

SAP BW BEx Query Designer Menus And Toolbar

SAPBWBExAnalyzerCourseSaleDiscount This article covers the BEx Query Designer Menus and Toolbar and their functions.

Full Course – Click Here
The BEx Query Designer contains the following Menu items: Query ~ Edit ~ View ~ Tools ~ Help

BEx Query Designer Menus

The Query Menu

The BEx Query Designer’s Query menu is like a File menu in MS Excel or Word. You can create New queries, Open queries, Check queries, Save queries and so on.

The Publish option in the lets you publish your queries to a specific role that has been set up for your users You also have the option to use the BEx broadcaster to distribute your reports either by email or other Broadcast mechanism that you have set up for publishing your reports.

BEx Query Designer Query Menu


The Edit Menu

The Edit menu is very simple. You have the option to Cut, Copy, Paste, or Remove your queries using the Edit menu options. You can also change or display your queries by the Display/Change option.

Query Designer Edit Menu

The View Menu

The View menu in the BEx Query Designer allows you to customize the look of your Query Designer’s interface. You can select the Standard View or SAP BW 3.5 View through the Predefined option. Technical Names opens up a sub menu to let you choose to show the technical names of characteristics and key figures in our queries. For example the characteristic “employee” has the same description as its characteristic name but by choosing the see the technical name “PERNR”, we can differentiate the field easily.

The View menu can also be used as way of turning window elements of the screen on or off.

Query Designer View Menu


The Tools Menu

The Tools menu is a small menu, it allows you save every object that you have added within your query by clicking Save All option.

Query Designer Tools Menu


The Help Menu

Through the help menu option you can learn everything that you may need to know about the BEx Query Designer. You can access SAP help articles there and online support as well.

BEx Query Designer Toolbar

The BEx Query Designer’s toolbar is an alternative way of selecting the various options from the Menus. It includes every function that the Menu has except the Cell Definitions option. You can perform the same menu functions with the toolbar options such as creating a new query, opening a query, saving the query, and all the other option that are described above.

Query Designer Toolbar



About the Author:

Pete has been working with SAP technologies for over 10 years. He started out as an ABAP consultant and then moved on to BW where he has worked many different clients covering a wide variety of industries. "I love introducing SAP technology (especially BI) to new clients and showing them how they can go from zero to hero within their business in super fast time". Contact me on twitter @PeterMoxon