You create a Web application in which you can analyze sales data for the year 2007 on the Web. The data for the analysis is available in query ZD_SALES_2007. The query data is displayed in a table in the Web application. To create a Web application, you integrate the Web item Analysis in the Web template. By simply pressing a button, you can create a PDF document in the Web application and send the analysis by e-mail; you use the Web item Button Group in the Web template to do this. To filter the data by month, you can use a dropdown box that can be inserted into the Web template as a Web item.
...
1. Start the BEx Web application by choosing Start → Programs → Business Explorer → Web Application Designer.
2. Log onto the BI system.
3. In the initial screen of the Web Application Designer, click on the link Create New Blank Web Template.
4. In the lower part of the layout view choose New Data Provider.
5. In the dialog box for the data provider type select Query and enter the name of the query ZD_SALES_2007 in the field following Query.
6. Choose OK.
7.
8. The data provider is displayed in the lower part of the layout view in the Web Application Designer.
...
1. Enter a meaningful text such as <SALES 2007> in the Web template area, and format it as required using the formatting functions (for example, font, font size, font color) in the toolbar.
2. Insert a new line at the end of the text.
3. In the toolbar, choose (Insert Table).
4. On the Custom tab in the next dialog box, define the table so that it has one row and two columns and choose OK.
Inserting an HTML table simplifies the arrangement of the Web items in the Web template and thus permits you to design your layout.
...
1. Insert the Web items Button Group and Dropdown Box in the table.
a. In the Web Items screen area, select the Web item group Standard.
b. Drag the Button Group Web item to the left column of the table with drag and drop.
c. Drag the Dropdown Box Web item to the right column of the table with drag and drop.
d. Bring the two columns closer together if required.
2. Drag the Analysis Web item to the area below the HTML table with drag and drop.
3.
To define the Web item parameters, click on the relevant Web item and go to the tab page Web Item Parameters in the screen area Properties.
...
1. Click on the first pushbutton in the parameter group Internal Display. The Edit Parameter dialog box appears.
a. Enter the text PDF for the caption.
b.
c. Click on the pushbutton to the right of the parameter Command below Action. The Command Wizard appears.
d. Choose All Commands → Commands for Web Templates.
e. Select the command Export Web Application and choose Continue with the mouse button.
If you precede the command with this indicator, the command is copied to the list of favorite commands.
f. From the command-specific parameters, select PDF as export format and choose OK.
g. Choose OK in the dialog box Edit Parameter.
h.
You created the first pushbutton, which permits conversion to a PDF document in the Web application by pressing a button. Now create the second pushbutton.
2. Click on the second pushbutton in the parameter group Internal Display. The Edit Parameter dialog box appears.
a. Enter the text Send for the caption.
b.
c. Select the pushbutton to the right of the parameter Command below Action. The Command Wizard appears.
d. Choose All Commands → Commands for Web Templates.
e. Select the command Start Broadcaster and choose Continue.
f. Select the command-specific parameter START_WIZARD.
g. Select E-MAIL as Distribution Type (DISTRIBUTION_TYPE) and choose OK.
h. Choose OK in the dialog box Edit Parameter.
i.
You created the second pushbutton, with which you can send the analysis in the Web application.
...
1. Select data connection type Char./Structure Member (CHARACTERISTIC_SELECTION) in Web item parameter group Data Binding.
2. Click on the pushbutton next to parameter Selection of Characteristic. The Edit Parameter dialog box appears.
3. Enter DP_1 as data provider.
4. Under Characteristic select CalYear/Month (0CALMONTH) and choose OK.
5. Select Label Visible.
6. Choose OK in the dialog box Processing Parameters.
7.
...
1. Select DP_1 as data provider in the Web item parameter group Data Binding.
2. Activate the parameter Document Symbols for Data (DOCUMENT_ICONS_DATA) in the Web item parameter group.
You can copy the other predefined parameters for the Web item Analysis.
...
1. In the menu bar choose Web Template → Save as.
2. Enter a meaningful name and a technical name for your Web template under Description and choose OK.
3. Choose (Execute…).
The Web template is displayed in the Web browser, where you can begin your analysis.
You created a Web template for analyzing your sales data and launched it in the Web browser as a Web application.
Analyzing Data in the Web Application