BEx Analyzer Workbook in Microsoft Office

Encode Code39 in Microsoft Office BEx Analyzer Workbook

BEx Analyzer Workbook
Scanning Code-39 In None
Using Barcode Control SDK for Microsoft Office Control to generate, create, read, scan barcode image in Microsoft Office applications.
Painting Code-39 In None
Using Barcode generator for Microsoft Office Control to generate, create Code 39 Full ASCII image in Microsoft Office applications.
Once the BEx Query Designer work is complete, we can then use this basic query definition in the BEx Analyzer to finish our manual planning interface. A basic overview of the steps involved with this process are offered in Figure 17-23. Generally speaking, the process involves taking the query definition and using it as a basis for the BEx Analyzer workbook. Again, numerous options are available to use in these activities, and depending on the planners needs, you will use additional functionality. Here, our purpose is to show another use of the BEx Analyzer and the workbook. We ve worked with the BEx Analyzer for quite some time now, so we can move directly into the workbook and review the required settings that will help with this process. Accessing the BEx Design toolbar, shown next, we can look at the process involved.
Reading Code39 In None
Using Barcode recognizer for Microsoft Office Control to read, scan read, scan image in Microsoft Office applications.
Draw Code39 In C#
Using Barcode printer for .NET Control to generate, create Code-39 image in Visual Studio .NET applications.
NOTE Quite a few checkboxes and settings aren t covered here. Use the F1 function key to get
Code-39 Creation In .NET
Using Barcode creator for ASP.NET Control to generate, create Code 3 of 9 image in ASP.NET applications.
Code 3/9 Printer In Visual Studio .NET
Using Barcode encoder for .NET framework Control to generate, create Code 39 image in .NET framework applications.
additional details for some good comments and documentation.
Code39 Drawer In Visual Basic .NET
Using Barcode creator for .NET framework Control to generate, create Code-39 image in VS .NET applications.
Data Matrix ECC200 Generation In None
Using Barcode printer for Font Control to generate, create DataMatrix image in Font applications.
Designing a planning model
EAN13 Decoder In None
Using Barcode reader for Software Control to read, scan read, scan image in Software applications.
ANSI/AIM Code 128 Scanner In VB.NET
Using Barcode scanner for .NET Control to read, scan read, scan image in .NET applications.
(1) Select InfoProvider (2) Create aggregation level (3) Create filter (7) Test planning model
Data Matrix Decoder In Java
Using Barcode reader for Java Control to read, scan read, scan image in Java applications.
Data Matrix Printer In Java
Using Barcode generation for Java Control to generate, create DataMatrix image in Java applications.
Creating a planning function
Encoding UPC-A Supplement 2 In Visual Studio .NET
Using Barcode creation for VS .NET Control to generate, create UPC-A Supplement 2 image in Visual Studio .NET applications.
ANSI/AIM Code 39 Generator In None
Using Barcode creator for Font Control to generate, create Code 3/9 image in Font applications.
(4) Select InfoProvider (aggregation level) (5) Create planning function (6) Create planning sequence
Paint Bar Code In Objective-C
Using Barcode drawer for iPhone Control to generate, create barcode image in iPhone applications.
ECC200 Creator In .NET
Using Barcode generator for ASP.NET Control to generate, create ECC200 image in ASP.NET applications.
Designing a query
ECC200 Drawer In None
Using Barcode generation for Software Control to generate, create Data Matrix image in Software applications.
Print EAN13 In Java
Using Barcode generator for Java Control to generate, create EAN 13 image in Java applications.
Embedding queries into workbooks
Paint Bar Code In C#.NET
Using Barcode encoder for Visual Studio .NET Control to generate, create barcode image in Visual Studio .NET applications.
UCC-128 Generation In Java
Using Barcode creator for Java Control to generate, create GS1-128 image in Java applications.
Designing a workbook
Structuring a Web application
Executing a planning application*
(8) Select InfoProvider (aggregation level) (9) Design query
(10) Save query
BI JAVA
(11) Open query (12) Embed query (13) Save workbook
(14) Create workbook layout (15) Choose design items and data connection (16) Use Excel formats or forms (17) Save workbook (18) Execute
BI ABAP
*Processes are covered by Query, Reporting and Analysis (IT scenario) Copyright by SAP AG
FIGURE 17-23 Overview of the steps in the BEx Analyzer for creating an IP Manual Planning workbook
17:
Other Options with the Analyzer
Copyright by SAP AG
We will start by assigning a query to the workbook. There s very little extra introduced at this point. Much of what you will see was discussed earlier on. The result of assigning the Insert Analysis Grid icon to the worksheet is shown here.
Copyright by SAP AG
Once this is complete, click the Grid icon to open the following dialog box. This is where the query is assigned to the grid.
Copyright by SAP AG
SAP Business Information Warehouse Reporting
When you click the Create icon, a dialog box opens to access the queries. Here, you can find the Cost Center query to assign to the grid. The assignment of the query U_AMER_Q2 to the grid is shown here. For this example, we will not change any of the basic parameters, so from here, moving back into the worksheet and switching from the Analysis Design mode to the Display mode, we see the results of the assignment, as shown next. Notice that the only difference between what we did in a previous chapter and what we are doing here is that the Analysis Grid is now available to have data manually entered into it and then saved back into the InfoCube.
Copyright by SAP AG
Copyright by SAP AG
As one final item to check to confirm that the workbook is ready for data input, go to the Query Properties and look at the Display Options tab to make sure the option Allow Input of Plan Values is checked, as shown here. If this is not checked, the screen will not allow data entry. Once the workbook is saved, it is ready to be used for data entry. Several additional objects need to be added, such as a button for saving the data, but these activities were discussed in a previous chapter.
Copyright by SAP AG
17:
Other Options with the Analyzer
Our next task is to complete the discussion of the use of the Insert button option in Design mode. Again, other than working with this option within the context of IP, nothing different is used in this example versus what we did in the previous chapter on BEx Analyzer functions. The following illustration show a button assigned to the screen in the Design mode.
Copyright by SAP AG
Clicking the button accesses the dialog box for the different functions, as shown next. The function we are interested in is Planning Specific Command.
Copyright by SAP AG
This option has a series of commands available. Table 17-3 details the different options available.
SAP Business Information Warehouse Reporting
Wizard Option Save Transfer Values Execute Planning Function Execute Planning Sequence
Static Parameters: Name CMD CMD CMD CMD
Static Parameters: Value SAVE_AREA VALUE_CHECK EXECUTE_PLANNING_FUNCTION EXEC_PLANNING_SEQUENCE
TABLE 17-3 Planning Specific Command
These options are shown next and described in the following list: Using the Save option, you can persistently store changes to transaction data. If the check is successful, the changed data is written to the InfoCube or InfoCubes. Using the Transfer Values option, you can copy changed data from an Input Ready Query to the planning buffer. The entries are checked when this is done. If the check is successful, the data is copied across. Using the Execute Planning Function option, you can trigger the execution of a planning function. The dialog box that appears in the subsequent step allows you to select the planning function and data provider. You can either select the planning function or branch to the Planning Modeler, where you can create or edit a planning function. If the planning function contains variables, the system displays these variables in the lower area of the dialog box. Input help is available for selecting the values. By selecting a data provider, you specify from which data provider (with type filter or query view) the selection for all characteristics is to be made. When you choose Finish, the system copies the values for PLANNING_FUNCTION_ NAME and DATA_PROVIDER_FILTER to the button properties. Using the Execute Planning Sequence option, you can trigger the execution of a planning sequence. A dialog box for selecting the planning sequence then appears. You can either select the planning sequence or branch to the Planning Modeler, where you can create or edit a planning sequence. If the planning sequence contains variables, the system displays these variables in the lower area of the dialog box. Input help is available for selecting the values. When you choose Finish, the system copies the values for PLANNING_SEQUENZ_ NAME to the button properties. Using the Planning Function option, we access a dialog box where we can assign the specific planning function to the button. In this case, we will assign the planning function for COPY AMER_FNC1 Copy Actual to Plan. The following illustration shows this result.
Copyright © OnBarcode.com . All rights reserved.