In this chapter, we'll discuss the varied options of the BEx query Designer and understand its functions. we'll additionally learn the various query components thoroughly. additionally, we'll find out how to line up the query Properties and also the numerous Properties of the query components.
There are several objects within the query Designer which will be reused at a global level. once objects are outlined, it will be utilized in all the queries in a bw System. once these reusable objects are modified, these changes are applied altogether the queries wherever it's used
The resulting object types can be created for reuse −
To see the where the objects are used, you can select the Where Used List in the context menu.
To check the particulars of an object, go to the context menu and click on the Display button. It displays you the succeeding information −
As mentioned, varied objects are often reused in queries at global level.
In a query Designer, you'll outline Variables to pass the value at run time. they will be utilized in web applications and different queries as a placeholder. To outline Variables for any of the objects in query, you need to open the Variable Editor.
You can open the Variable editor by clicking on the below choice within the query Designer. this selection is available within the query Properties of all the parts wherever you'll pass constant values.
You can also click on the drop down button and can entree different options to create/edit variables.
The resulting fields are available −
When you select New Variable/Change Variable, the resulting dialog box opens –
A Restricted Key Figure is defined as a key figure which can be used to limit the values in a query based on the characteristics.
To define a new Restricted Key figure, navigate to Restricted Key figure folder → Context Menu and New Restricted Key Figure.
This will generate a New Restricted Key Figure and the properties for the restricted key figure are displayed in the Properties screen area.
Define the technical name and outline and click on on the save button to save lots of the key figure. To edit the restricted key figure, click on the Edit button or double click on the name within the hierarchical structure.
In the elaborated view, you'll be able to see the directory of all objects available within the InfoProvider and on the correct facet you've got an empty field to outline the key figure.
You can also calculate the key figures in InfoProvider by using some formulas. Calculated key figure may be based on other key figures, restricted key figures or pre-calculated key figures.
To define a new calculated key figure, right click on the Key figure folder → New.
This will add the Calculated Key figure within the hierarchical structure and properties for the calculated key figure are displayed within the Properties screen area.
To outline the calculation formula for the key figure, double click on the Calculate Key Figure. you've got an choice to outline the Calculated Key figures within the General Tab.
Drag the other key figure and Operator from the Operators section. you've got totally different Operators available underneath this section.
You can also outline Aggregation for new Calculated Key figures.
The resulting function types are existing under the General tab to define the calculation for the New Calculated Key Figures −
When you define the formula, click on the OK button as shown in resulting screenshot.
You can also navigate to the Properties tab of the Calculated Key figure. You can define different properties for a new key figure and can also edit an existing key figure −
You can access the query properties by selecting the icon as shown in the resulting screenshot.
The resulting tabs are obtainable under the Query Properties −
General Tab − You can enter the Description, Technical Name, InfoProvider and the Key Date along with the Last Changed By details under the General tab.
Variable Sequence Tab − This tab contains of variables listed in the query. You can also arrange the Variable sequence defined in the query.
Display Tab − You have Display choices and document links inside the Display tab. Under the Display Option, you can adjust formatting after Refreshing, Scaling Factor, or Hide Repeated Key Figures.
You can create a document link for Metadata, Master Data and InfoProvider for a query.
Rows/Column Tab − This is used to define where results are exhibited for a query.
Suppress Zeros − This choice can be used to specify whether columns or rows containing zeros are to be displayed or not.
Effect on − This field can be used to specify whether suppression of zeros should be applied to both rows/columns or only to rows or columns.
Value Display Tab − This tab is used to display the +/- value in the query and zero value display.
Planning Tab you'll be able to outline if a query should begin within the change mode or the display mode.
For the queries that are not input prepared, the beginning query within the change Mode checkbox is usually inactive and can't be modified. once there's input ready queries, the check box is active.
Calculate Inverse Formulas − Using this option, Inverse formulas are used to recalculate input-ready formulas in planning the applications.
In the Business Explorer, you can describe properties for each query component. Property dialog can be opened by clicking on the component in a hierarchical structure. You can describe custom settings for each field or can also use default values.
The resulting component properties can be set in the BEx Query Designer −
In the Query Designer, you can originate properties of each component from the other object or can also set its value. You can also see the object name and can derive properties from the resulting objects −
The selection can derive properties from −
The characteristics in the reusable filter can derive properties from the characteristics in the InfoProvider.
The restricted key figure can derive properties from −
With this, we accomplish the most commonly-used Properties of the Query Components.
Sap Bex Tutorial
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.