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

Generate ANSI/AIM 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
Code 3/9 Scanner In None
Using Barcode Control SDK for Microsoft Office Control to generate, create, read, scan barcode image in Microsoft Office applications.
Create Code 39 Extended In None
Using Barcode printer for Microsoft Office Control to generate, create Code 3 of 9 image in Microsoft Office applications.
We have already looked at the personalization for the history view in the Open dialog box for finding objects you have been working with. The one we are interested in is the user-specific variable values stored in the DataStore object 0PERS_VAR. The following illustration shows the view of the DataStore objects in the Administration Workbench.
Decode USS Code 39 In None
Using Barcode decoder for Microsoft Office Control to read, scan read, scan image in Microsoft Office applications.
Code 39 Extended Printer In Visual C#
Using Barcode drawer for Visual Studio .NET Control to generate, create Code 39 image in .NET applications.
Copyright by SAP AG
Create Code 39 Full ASCII In .NET
Using Barcode creator for ASP.NET Control to generate, create Code39 image in ASP.NET applications.
Code-39 Creation In Visual Studio .NET
Using Barcode creator for VS .NET Control to generate, create Code 39 image in .NET applications.
NOTE As mentioned before, you have to activate personalization in Customizing (the Implementation
Code 39 Full ASCII Creator In Visual Basic .NET
Using Barcode generator for VS .NET Control to generate, create Code 3/9 image in .NET framework applications.
UPC-A Creation In None
Using Barcode generator for Software Control to generate, create UPCA image in Software applications.
Guide) before you can use it. In the SAP Implementation Guide (IMG), see SAP Reference IMG | SAP NetWeaver | Business Intelligence | Settings for Reporting and Analysis | General Settings for Reporting and Analysis | Activate Personalization in BEx. Also, after you have activated personalization in the Business Intelligence IMG, you can no longer deactivate it. In many cases, the use of personalization is a bit restrictive. When personalizing variables, you assign a permanent user-specific value to them that cannot be changed in query navigation. You can personalize variables directly in the variable-creation screen or by loading files to the DataStore object with specific values for users. The user can personalize variables at runtime.
Code 128B Recognizer In Visual C#
Using Barcode reader for Visual Studio .NET Control to read, scan read, scan image in .NET framework applications.
Code128 Creation In Objective-C
Using Barcode encoder for iPhone Control to generate, create Code-128 image in iPhone applications.
SAP Business Information Warehouse Reporting
UPC Symbol Generator In VB.NET
Using Barcode generator for Visual Studio .NET Control to generate, create UPC A image in .NET framework applications.
Encode GS1 128 In .NET Framework
Using Barcode maker for ASP.NET Control to generate, create UCC.EAN - 128 image in ASP.NET applications.
The following illustration shows where in the variable-creation process you can identify either a specific value or a variable with personalization assigned to it to be used in the query process.
Recognize DataMatrix In VB.NET
Using Barcode recognizer for Visual Studio .NET Control to read, scan read, scan image in .NET framework applications.
Make Code39 In Java
Using Barcode creator for Java Control to generate, create USS Code 39 image in Java applications.
Copyright by SAP AG
Bar Code Creation In .NET
Using Barcode creation for ASP.NET Control to generate, create bar code image in ASP.NET applications.
Painting ANSI/AIM Code 39 In .NET
Using Barcode drawer for Reporting Service Control to generate, create Code 3 of 9 image in Reporting Service applications.
The next series of illustrations show the use and setup of personalization against a query. This is all from the business user side. If you are concerned with the business users assigning themselves personalization values, you will need to deactivate personalization or not turn it on in the first place. The first illustration shows the execution of personalization based on the variable screen that appears prior to query execution.
Making UPC - 13 In None
Using Barcode printer for Font Control to generate, create EAN 13 image in Font applications.
Data Matrix 2d Barcode Creator In VB.NET
Using Barcode generator for Visual Studio .NET Control to generate, create Data Matrix ECC200 image in Visual Studio .NET applications.
Copyright by SAP AG
Draw Bar Code In None
Using Barcode drawer for Software Control to generate, create barcode image in Software applications.
Drawing Barcode In .NET Framework
Using Barcode encoder for VS .NET Control to generate, create bar code image in VS .NET applications.
6:
Enhancing the Use of the Characteristics in the BEx Query Designer
The next illustration shows the initial screen after accessing the personalization button.
Copyright by SAP AG
This illustration shows the month/year variable moved to the selection side.
Copyright by SAP AG
SAP Business Information Warehouse Reporting
And the following illustration shows the assignment of the value for the month/year 200102.
Copyright by SAP AG
The next illustration shows the execution of the query with personalization turned on. As you can see, the variable field Month/Year doesn t appear on the screen because it has been filled with the personalization value. In the Personalization Selection dialog box, you must select the option Show Personalized Variables in Variable Screen. Otherwise, the variable will not show up on the screen and the business user might get confused with the process of trying to change variable values. If this selection is not chosen, you will have to reset your personalization settings in the Administration Workbench for the variable to be active again or you must create another variable as a replacement.
Copyright by SAP AG
6:
Enhancing the Use of the Characteristics in the BEx Query Designer
As shown here, the query is executed and is using the value 200102 to drive the columns values rather than having the variable show up with the default values of 200102 through 200103.
Copyright by SAP AG
Exceptions
In the process of identifying the uses of the queries and the information generated by the queries, you need to understand what information the business user really is interested in reviewing. Having all the information available is good to a certain point. If we can offer the business user specific information and identify some components that can be highlighted, the information becomes more useable and understandable. This moves the business user from a reviewer of information into a proactive position where they can act on the information quickly and effectively. If we use the exception functionality available in BW, we can move closer to developing this level of information and strategic analysis. Exception functionality allows us to pinpoint information, whether good or bad, and act on it quickly. It allows the business user to notice and make more responsible decisions and to identify events that deviate from expected values. This can be an initial warning system within a report. In exception reporting, you select and highlight objects that are in some way different or critical. Results that fall outside a set of predetermined threshold values (exceptions) are highlighted in color or designated with symbols. This enables you to identify immediately any results that deviate from the expected results. Exception reporting allows you to determine the objects that are critical for a query, both online and in background processing. The following illustration shows the view of a query with an exception assigned to the results rows for each of the key figure Sales Volume by customer and material. This allows the business user to identify the total sales at a glance of each of customers in each type of material and see if there are any variances. This can have numerous applications, such as discount agreements that either your company is assigned to or that you are tracking for your customers. If you know that ordering additional material you will need in the future generates a 10% discount for all the material purchased during the quarter, you might decide to post the order and get the additional discount. Perhaps you have a customer you have offered a discount to if they purchase a certain
Copyright © OnBarcode.com . All rights reserved.