Navigating Through the BEx Analyzer in Microsoft Office

Drawer Code 3/9 in Microsoft Office Navigating Through the BEx Analyzer

Navigating Through the BEx Analyzer
Read Code 3/9 In None
Using Barcode Control SDK for Microsoft Office Control to generate, create, read, scan barcode image in Microsoft Office applications.
Create Code-39 In None
Using Barcode creator for Microsoft Office Control to generate, create Code 39 Extended image in Microsoft Office applications.
Copyright by SAP AG
Code 39 Full ASCII Recognizer In None
Using Barcode decoder for Microsoft Office Control to read, scan read, scan image in Microsoft Office applications.
Code 39 Extended Drawer In Visual C#
Using Barcode generation for Visual Studio .NET Control to generate, create Code-39 image in .NET applications.
FIGURE 3-7
Code 39 Full ASCII Creator In .NET
Using Barcode drawer for ASP.NET Control to generate, create Code 39 Extended image in ASP.NET applications.
Code 3/9 Maker In Visual Studio .NET
Using Barcode encoder for VS .NET Control to generate, create USS Code 39 image in .NET applications.
The display of a query with the Filter and Information buttons executed
Making Code 39 In VB.NET
Using Barcode creator for .NET framework Control to generate, create Code 3/9 image in Visual Studio .NET applications.
Generating Bar Code In Visual Studio .NET
Using Barcode encoder for Reporting Service Control to generate, create barcode image in Reporting Service applications.
in the context menu has the options Back, Back to Start, and Query Properties, as detailed in Table 3-3.
Reading Code128 In Visual C#.NET
Using Barcode scanner for VS .NET Control to read, scan read, scan image in .NET framework applications.
Draw Bar Code In Objective-C
Using Barcode encoder for iPhone Control to generate, create barcode image in iPhone applications.
NOTE Context menus are accessed by right-clicking the mouse.
Bar Code Creator In Objective-C
Using Barcode generator for iPhone Control to generate, create barcode image in iPhone applications.
Code 128A Creator In None
Using Barcode drawer for Excel Control to generate, create Code 128B image in Office Excel applications.
Information Box Option Back Back to Start Query Properties
Print GS1 RSS In .NET
Using Barcode creation for VS .NET Control to generate, create DataBar image in Visual Studio .NET applications.
Creating DataMatrix In Java
Using Barcode creation for Java Control to generate, create Data Matrix 2d barcode image in Java applications.
Description of Functionality Moves you back one step Moves you back to the initial screen, based on the initial execution of the query Query properties are the same for the rows, columns, navigational filter, and information box. Therefore, we will break down this functionality later in the chapter.
Matrix 2D Barcode Encoder In Java
Using Barcode drawer for Java Control to generate, create 2D Barcode image in Java applications.
Barcode Encoder In VS .NET
Using Barcode printer for .NET framework Control to generate, create barcode image in .NET applications.
TABLE 3-3 Options in the Information Box of the BEx Analyzer
Paint Code 128C In .NET Framework
Using Barcode creator for ASP.NET Control to generate, create Code 128 Code Set A image in ASP.NET applications.
Create Code 128B In None
Using Barcode creation for Office Word Control to generate, create Code128 image in Microsoft Word applications.
SAP Business Information Warehouse Reporting
Scanning Bar Code In Java
Using Barcode Control SDK for Java Control to generate, create, read, scan barcode image in Java applications.
Painting Data Matrix 2d Barcode In Java
Using Barcode maker for Android Control to generate, create Data Matrix 2d barcode image in Android applications.
Navigational Filter Functionality
In the navigational filter are a number of functions available from the context menu. Some of these functions are similar to the ones you will find in the context menus of the body of the query. I will try not to duplicate some of this functionality because it has the same purpose whether you access it via the navigational filter or via the query itself. In the navigational filter, you can use the functionality of double-clicking with the primary mouse button to either add (drill down) a characteristic to your query or remove it from the query. Thus, if the characteristic is already in the query and you double-click it, you will remove it from the query. You can also double-click an empty cell to select a filter value for a key figure or a free characteristic. The options in the navigational filter are listed in Table 3-4, along with their description and functionality.
Navigational Filter Options from the Context Menu Back Back to Start Select Filter Value
Description and Functionality Undoes the last navigational step. Restores the query to the initial view of the data at the time of execution. A dialog box is displayed that allows you to identify a single value, range of values, or other combination to show specific information. Removes the filter value and shows all values in the query. Drills down on the characteristics or key figures of that specific item. If a filter was identified initially, the drilldown will only use the remaining values. Sorts the characteristic or key figure by either the key or text in either ascending or descending order.
Remove Filter Value Drill Characteristic/Key Figure Down or Across Sort Characteristic Sort Ascending by Text; Sort Ascending by Key; Sort Descending by Text; Sort Descending by Key Add Local Formula (Key Figures Only)
This function allows the business user to create a local formula directly in the executed query. A dialog box appears that has a limited list of functions that can be used for doing basic calculations with the key figures used in the query. This list of attributes is discussed in Table 3-5. This list of attributes is discussed in Table 3-5. This function allows the business user to drill across the query with the characteristics or key figures available in the query and create worksheets for each of the characteristics. The following illustration shows the results of this function used in the query against Division.
Properties (Characteristics Only) Query Properties (Both Key Figures and Characteristics) Drill Key Figure/Characteristic Across Sheets
TABLE 3-4 Navigational Options Within the BEx Analyzer
3:
Navigating Through the BEx Analyzer
NOTE As an additional option, you can change the naming convention in the navigational filter by
just typing in the change in the title of the characteristic. This can make the characteristics more recognizable to the business user. Remember, once you leave the query and come back, it will revert back to the original naming convention. To make sure this change is saved, you will need to convert the query to a workbook. We will discuss this in 8.
Copyright by SAP AG
As you can see, this function creates additional worksheets for each of the divisions involved.
SAP Business Information Warehouse Reporting
The following two illustrations show the context menus for the navigational filter for key figures and characteristics. These are examples of what you will see as you use the navigational filter functionality.
Copyright by SAP AG
Copyright by SAP AG
3:
Navigating Through the BEx Analyzer
In these context menus, you can also access Properties and Query Properties to change the display and help create new views of your data. If you access the option Properties, you are accessing functionality that will affect the specific characteristic you are prompting. If you are accessing the functionality of Query Properties, you are looking to change the format and display of the entire query and/or workbook (again, remember that any changes made here will be reverted back to the original format once you leave the query, unless you save it as a workbook). We will break down both of these options now because the same functionality is used in the rows and columns of the analysis grid (body of the query). Properties can be accessed via the context menu from the navigational panel (navigational filter) or from the analysis grid (body of the query). With your cursor on either the characteristic or the characteristic value, you can access this option. It has the same parameters from either of these areas. Listed in Table 3-5 are the fields, the options to fill those fields, and the results you would view in the query. The following illustration shows the initial screen for the Properties option. In addition to these parameters, you have an icon at the very bottom of the screen to turn on the technical names for the objects.
Copyright © OnBarcode.com . All rights reserved.