Enhancing the Use of the Characteristics in the BEx Query Designer in Microsoft Office

Print Code-39 in Microsoft Office Enhancing the Use of the Characteristics in the BEx Query Designer

Enhancing the Use of the Characteristics in the BEx Query Designer
Decoding Code-39 In None
Using Barcode Control SDK for Microsoft Office Control to generate, create, read, scan barcode image in Microsoft Office applications.
Code 3/9 Maker In None
Using Barcode generation for Microsoft Office Control to generate, create Code 3 of 9 image in Microsoft Office applications.
time dependent, you will see options for From and To dates. Otherwise, you will view just the options for the hierarchy or variable. The following illustration shows this information.
Code 3/9 Decoder In None
Using Barcode scanner for Microsoft Office Control to read, scan read, scan image in Microsoft Office applications.
Code 3 Of 9 Generator In C#.NET
Using Barcode encoder for .NET framework Control to generate, create Code 3 of 9 image in .NET framework applications.
Copyright by SAP AG
Code-39 Encoder In .NET
Using Barcode generation for ASP.NET Control to generate, create Code 3 of 9 image in ASP.NET applications.
Code 39 Printer In .NET Framework
Using Barcode generation for Visual Studio .NET Control to generate, create Code39 image in VS .NET applications.
Choosing the Hierarchy Variables option opens another dialog box for the creation of hierarchy variables. Notice the grayed out section confirming that we re in the right place to create hierarchy variables, as shown in the first of the following illustrations. The second illustration shows the initial Create New Variable option.
Generate Code 39 Extended In Visual Basic .NET
Using Barcode generator for .NET framework Control to generate, create USS Code 39 image in .NET framework applications.
Data Matrix Generation In None
Using Barcode encoder for Font Control to generate, create Data Matrix image in Font applications.
Copyright by SAP AG
Recognize Bar Code In Java
Using Barcode Control SDK for Java Control to generate, create, read, scan barcode image in Java applications.
Linear 1D Barcode Printer In C#.NET
Using Barcode drawer for VS .NET Control to generate, create Linear 1D Barcode image in .NET applications.
Copyright by SAP AG
Code 128 Code Set A Creator In .NET Framework
Using Barcode generation for Visual Studio .NET Control to generate, create Code-128 image in .NET framework applications.
EAN / UCC - 14 Creator In Java
Using Barcode maker for Android Control to generate, create EAN / UCC - 13 image in Android applications.
SAP Business Information Warehouse Reporting
Encoding Bar Code In .NET Framework
Using Barcode drawer for .NET Control to generate, create barcode image in Visual Studio .NET applications.
Encode USS Code 39 In C#
Using Barcode generation for .NET Control to generate, create Code 39 Full ASCII image in Visual Studio .NET applications.
The following illustration shows the configuration of the hierarchy variable. Again, notice the grayed out field indicating we re creating a hierarchy variable.
Bar Code Decoder In None
Using Barcode recognizer for Software Control to read, scan read, scan image in Software applications.
UPC-A Supplement 5 Reader In None
Using Barcode scanner for Software Control to read, scan read, scan image in Software applications.
Copyright by SAP AG
Code 39 Extended Scanner In C#.NET
Using Barcode reader for .NET Control to read, scan read, scan image in .NET applications.
Creating UPC-A In .NET
Using Barcode maker for .NET framework Control to generate, create UPC-A image in .NET applications.
Finally, after all settings are complete, we click OK and revert back to the initial screen with the variable defaulted, as shown here.
Creating Code39 In None
Using Barcode creation for Word Control to generate, create Code-39 image in Word applications.
GS1-128 Scanner In Visual Basic .NET
Using Barcode reader for .NET framework Control to read, scan read, scan image in .NET applications.
Copyright by SAP AG
The next illustration shows the final view from the Query Designer for the hierarchy variable for 0material. We are now ready to execute the query and display the variable s usage.
6:
Enhancing the Use of the Characteristics in the BEx Query Designer
Copyright by SAP AG
The next illustration shows the initial view of the variable pop-up.
Copyright by SAP AG
SAP Business Information Warehouse Reporting
The next illustration shows the list of hierarchies available for use by the InfoObject 0MATERIAL.
Copyright by SAP AG
Notice that the only values offered to the query for selection are the full hierarchies. After filling in the hierarchy we are interested in viewing, we can see that this hierarchy is displayed in the query, as shown next.
Copyright by SAP AG
In the case of the Hierarchy Node variable, there is only a minor difference in the process of creating the variable but the issue is with the starting point for the creation process and this is a large part of the issue with creating these variables. The key is that we start out in the Restrict screen for the characteristic. The next illustration shows this step. Once this screen has
6:
Enhancing the Use of the Characteristics in the BEx Query Designer
been accessed, you will be able to identify the hierarchy used to create a hierarchy node variable by choosing the correct hierarchy from this screen.
Copyright by SAP AG
The next illustration shows the dialog box you will see. Notice at the very bottom of the dialog box you have the ability to choose a hierarchy. If you change this setting, you will be creating a hierarchy node variable for that specific hierarchy. We have decided to stay with the Material Class hierarchy as the root for this variable. The process of creating this type of variable is not any different from creating the variable for a hierarchy. Therefore, we will not go through each step. The end result is that we have a hierarchy node variable that is tied to the Material Class hierarchy, and we can identify a node to report on from the execution of the query.
Copyright by SAP AG
SAP Business Information Warehouse Reporting
The next three illustrations show the steps for executing the query: Choosing the variable hierarchy node, identifying the actual node, and executing the query.
Copyright by SAP AG
Copyright by SAP AG
Copyright by SAP AG
6:
Enhancing the Use of the Characteristics in the BEx Query Designer
The results are that the query displays just that node of the hierarchy we are interested in viewing, as shown here:
Copyright by SAP AG
Process Types We have reviewed several of the process types, but we haven t used two of
them in a demo. Therefore, a bit more information on the Customer Exit and SAP Exit and Authorization process types is in order. The SAP Exit processing type is contained in variables delivered within the BI Content framework. You can find the delivered variables in the Metadata Repository if you search for variables using the search function.
NOTE The technical names of delivered SAP objects always begin with a number.
You must activate the delivered variables before you can use them. SAP delivers a number of variables. Some variables are processed via automatic replacement using a predefined replacement path (SAP Exit processing type). A large majority of these are in the area of time characteristics. In the Variables Editor, choose the processing type SAP Exit from the General tabbed page. Once you have identified the SAP Exit, you should not have to set up any further parameters in the variable screens. You have the option of using a Customer Exit to set up a processing type for variables that is tailored specifically to your needs. The Customer Exit processing type for variables enables you to determine values for variables by means of a function module exit. The standard function module used is EXIT_SAPLRRS0_001. You create a project in transaction CMOD by selecting the SAP enhancement RSR000001 and assign this to the enhancement project. Activate the project. Another processing type Authorization enables variables to be filled with values automatically from the authorization of a user. The processing type Authorization can be used with characteristic value variables and hierarchy node variables. You first must maintain the authorizations in transaction RSSM or the new Analysis Authorization. If you choose Process with Authorization when you create a variable, the variable is automatically filled with the values of the user s authorization. When the user opens a query, the data is selected automatically according to their authorizations.
Copyright © OnBarcode.com . All rights reserved.