The following simple example shows how to create a Web application with a selection list (button group), table, and special pushbuttons for functions such as copy, revaluate (with a fixed percentage), and save.
You have a planning model that contains aggregation level Plan_Actual_Aggr (defined on the basis of MultiProvider Plan_Actual_MP), query Plan_Query02 (which is not input ready), a filter, and planning functions for copying PF_Copy and revaluating PF_Revaluate02.
You are familiar with the functions of the BEx Web Application Designer (see Creating a Web Application and Creating Web Applications with the BEx Web Application Designer).
...
1. Open the BEx Web Application Designer.
2. Choose Create New Web Template.
For more information about the Web template concept, see Web Templates.
3. Choose New Data Provider to create a new data provider of type Query View Data Provider. The Maintain Data Provider dialog box appears.
For more information about the data provider concept, see Data Providers in BI Applications.
4. In the Name field, the system displays the name it generated for the data provider. This is currently assigned to the data provider. You can retain this name.
5. In the Define Data Provider Type area, choose the Query option. Choose Select Query. The Open dialog box appears.
6. Select the query you require and choose Open. In the Query field, the system inserts the name of the query.
7. When you have defined your data provider in this way, choose OK.
8. Drag and drop the required Web items onto the Layout tab page of your Web template.
In this example, we insert the following Web items:
■ Dropdown box
■ Analysis
■ Button group
More information: Web Items
9. If you click a Web item or choose Properties in the context menu of a Web item, the system displays the Properties screen area.
10. On the Web Item Parameters tab page of the respective Web item, enter the required data in the highlighted fields.
For the Web items in this example, the following data is required:
For the dropdown box (see Dropdown Box) under parameter Data Binding → Data Binding Type → Selection of Characteristic:
■ Data provider: DP_01
■ Characteristic: Country
Set the indicator for the special Label parameter for the dropdown box so that the label is displayed for Country.
The system uses the data provider you create first for all additional Web items. If you have performed the activities in the order described here, the system inserts data provider DP_01 under the Data Bindingparameter for the Analysis Web item (see Analysis).
For the button group (see Button Group), under parameter Internal Display → List of Buttons → Caption in the Text Editing dialog box (with option Language-Independent Text), we enter a text for the required pushbuttons. We use the Command field to assign a suitable command to each button (see Commands). The Edit Command dialog box appears. On the All Commands tab page, select Commands for Planning Applications and choose the required functions in accordance with the following examples:
Special Function Buttons
Button Text |
Command |
Parameter |
Copy |
Execute planning function (simple binding) (EXEC_PLANNING_FUNCTION_SIMPLE) |
Data Binding → Reference to Data Provider of Type Filter: DP_01 |
Command-Specific Parameters → Planning Function: Select your copy planning function (PF_Copy in our example). |
||
Revaluate |
Execute planning function (simple binding) (EXEC_PLANNING_FUNCTION_SIMPLE) |
Data Binding → Reference to Data Provider of Type Filter: DP_01 |
Command-Specific Parameters → Planning Function: Select your revaluate planning function (PF_Revaluate02 in our example). |
||
Save |
[SAVE_DATA] |
Data Binding: No entry necessary. |
More information: Commands for Planning Applications
11. Choose to save your Web template (menu path Web Template → Save).
12. Choose to execute your Web template.
You can use the planning functions you have created to copy and calculate plan data. The data set is determined by the navigational state of data provider DP_01. You can save the entire Web application by choosing the Save pushbutton.
For additional examples of the creation of planning applications in the BEx Web Application Designer, see:
Copying Planning Functions (with Dropdown Box Web Item)
Revaluating Planning Functions (with Analysis Web Item)
Documentation (with Analysis Web Item)