BEX Query Designer and Query Elements- Shikshaglobe

Content Creator: Vijay Kumar

SAP NetWeaver 7.0 gives the accompanying instruments:

The way to going with informed choices is having the right information perfectly positioned brilliantly. Leaders and line administrators depend on business knowledge (BI) and detailing devices to convey convenient exact and applicable information for both functional and key choices. The Business Explorer (BEx) is a part of SAP BI that gives adaptable detailing and examination devices that we can use for key examination and supporting the dynamic cycle in an association. These instruments incorporate question, revealing, and investigation capabilities.

BEx Query Designer BEx Web Application DesignerBEx Broadcaster

Read More: Best FREE MP3 Song & Music Downloader Apps

BEx Analyzer

The BEx apparatus can be utilized to show over a significant time span information contrasting in the level of their subtleties and according to alternate point of view. It very well may be utilized to make arranging projections utilizing BI Integrated Planning. The BEx Information Broadcasting can be utilized to appropriate business knowledge content by email, either as pre-determined archives with authentic information, or as connections with live information.

Inquiry Designer:

As the name recommends, it is utilized to characterize questions to recover information from SAP BW. Inquiry Designer goes about as the extension between SAP BW Info Providers and the revealing front-end instruments (SAP BW/SAP BO). It restricts the field list showed, which depends on their necessities. It likewise characterizes the default position of these report objects inside a report Query Designer and adds esteem by permitting clients to characterize channels, choice screen factors (a.k.a. Prompts), Calculations, Unit Conversions, and so on that are not accessible in Info Providers.

Getting to Query Designer:

To get to BEx Query planner, follow the underneath steps: Explore to Start - > All Programs. Under the envelope "Business Explorer", the "Question Designer" is accessible. Click on "Question Designer".

Question Panel:

Info Provider Details are accessible here. Tabs to see different report parts. Properties Box which shows the properties of every part chosen in the question. Messages, for example, any mistake or advance notice messages during the Query check is shown here. Shows the Where-Used List of any part chosen inside the inquiry.

Inquiry Panel - Standard Toolbar:

The Standard device bar in the Query Designer has the accompanying buttons.

Make New Query

Open Query

Save Query

Save All

Distribute on Web

Actually look at Query

Inquiry Properties




Switch tabs for Filter and Rows/Columns

Know More: Intel i5 vs i7: Ultimate Showdown



Special cases




Where Used


Specialized names

Inquiry Elements:

Key Figures : Key Figures address the mathematical information or the KPIs(Key Performance Indicator). They are additionally separated into Calculated Key Figures (CKF) and Restricted Key Figures (RKF).Qualities : A trademark gives the measures as per which items are grouped. for example Material,Period, Location, and so on.Navigational traits show up as attributes in Query architect.

OTHER Query Elements:

Aspects : Similar qualities are gathered in an aspect. for example Time aspect consistsof Year, Month, Week, and so on. Credits : Attributes characterize the extra properties of a trademark. For example Material might have size, length or width. It is beyond the realm of possibilities to expect to add a presentation quality to an inquiry except if the connected qualities are likewise added to the question. Be that as it may, it is feasible to set the property of trademark as "No Display".

Question Properties:

Select the Tab "Variable Sequence". The tab "Variable Sequence" is utilized to control the request in which determination screen factors are shown to clients. List the factors utilized in the Query. There can be various factors present here. These factors can be sequenced according to our need. Select the "Show" tab. The Check box "Conceal Repeated Key Values" controls regardless of whether the trademark will rehash in each column. The choice "Show Scaling Factors for Key Figures" controls whether the scaling factor is accounted for at the highest point of comparing segment. Select the "High level" tab. The tab "Progressed" is generally significant according to BO viewpoint . It controls regardless of whether the inquiry is noticeable to BO. The choice should be checked to permit inquiry admittance to BO. The Check box "Permit External Access to this Query" ought to be checked in the event that this Query is to be utilized from BO

Select the "Lines/Columns" tab.

The choices under "Result position" segment choose the Location of sub-all out (a.k.a. brings about BW world) as beneath/above or right/left of the Characteristics. he choices under "Stifle Zeros" segment choose the utilization of Zero-Suppression on the question.


Channels are utilized to confine the information recovered by a question. Channels can be dynamic or static in nature. Values entered as static channels can't be overwritten by clients at runtime while dynamic channels or factors can be overwritten by client/framework during inquiry execution. Moves toward apply channels in the Query Select the "Channel" tab. Channels can be applied in the "Trademark Restrictions" area. Channels can be applied in the "Default values" area. Trademark Restrictions are applied before information get activity, while the default values will bring about whole information being brought by question. The limitation is applied exclusively in report front end. If "Clear all channels" choice is applied in WAD/Analyzer, the channels in Default Values will be deleted from front end, yet the channels applied by means of Characteristic Restriction will in any case stay in force. It is prescribed to have something like a couple of trademark limitations while utilizing a BW question for BO Universe.

Learn More: BEST CPU Temperature Monitor Software for Windows


Factors are question boundaries that we characterize in the Query Designer and are loaded up with values just when you execute the inquiry. Factors are reusable items. The factors characterized in the Query Designer are accessible in all Info Providers. They don't rely upon the Info Provider, but instead on the Info Object for which they were made. Kinds of Variables Trademark values Orders Order Nodes Texts

Equation components

Moves toward make a variable: To make a variable, peruse to the organizer called "Trademark Value Variables" under the comparing trademark. Right snap on the organizer and select the choice "New Variable". In the resulting window, enter the Description. Enter the Technical name. Variable Processing Types Under reference trademark, the variable can be relegated to either the particular Info Object or all Info-Objects in light of same reference trademark. Under the "Subtleties" tab, we can indicate whether the variable acknowledge: Single Value/Multiple Values/Range Determination Option (permits any of the above at runtime, isn't upheld in BW-BO)Click the "Default values" tab. We can determine the default channel applied to the report. This worth can be over-composed by client at run-time. Conditions and Exceptions: Conditions go about as channels on key figures. for example Top 10 clients, items with base 10% edge, and so forth. Exemptions are like "contingent featuring" in MS succeed. They are utilized to feature lines/segments/cells where the KPI esteem is above or under a specific limit. As these are not imported to a BO Universe, we won't examine them in subtleties in current instructional exercise.

Click Here

Must Know!

Featured Universities

Mahatma Gandhi University

Location: Soreng ,Sikkim , India
Approved: UGC
Course Offered: UG and PG

MATS University

Location: Raipur, Chhattisgarh, India
Approved: UGC
Course Offered: UG and PG

Kalinga University

Location: Raipur, Chhattisgarh,India
Approved: UGC
Course Offered: UG and PG

Vinayaka Missions Sikkim University

Location: Gangtok, Sikkim, India
Approved: UGC
Course Offered: UG and PG

Sabarmati University

Location: Ahmedabad, Gujarat, India
Approved: UGC
Course Offered: UG and PG

Arni University

Location: Tanda, Himachal Pradesh, India.
Approved: UGC
Course Offered: UG and PG

Capital University

Location: Jhumri Telaiya Jharkhand,India
Approved: UGC
Course Offered: UG and PG

Glocal University

Location: Saharanpur, UP, India.
Approved: UGC
Course Offered: UG and PG

Himalayan Garhwal University

Location: PG, Uttarakhand, India
Approved: UGC
Course Offered: UG and PG

Sikkim Professional University

Location: Sikkim, India
Approved: UGC
Course Offered: UG and PG

North East Frontier Technical University

Location: Aalo, AP ,India
Approved: UGC
Course Offered: UG and PG