SAP BusinessObjects Web Intelligenc…
Tuesday, December 21st, 2010 Uncategorized.
SAP BusinessObjects Web Intelligence (SAP BO WEBI) Report Design Creating a chart
You can create charts in one of three ways:
• You can select an existing table or cross tab and convert it to a chart using the right-click
• You can drag a chart type from the Templates tab and position it over an existing table to
convert it to a chart.
• You can create a blank chart by dragging a chart type from the Templates tab, then dragging
objects from the Data tab to fill the new chart with data values.
It is recommended you work in Structure View when you insert a new chart from the Templates
tab. This is because Results View is designed to display the data contained in reports. therefore,
you can only view charts in Results View after you have allocated dimensions and measures
to the empty chart template. To create a chart
1. Click View Structure on the Reporting toolbar.
2. Click the Templates tab.
3. Select the chart template and drag it onto an empty area of the report.
The empty template appears on the report.
4. Click the Data tab.
5. Drag and drop the required dimension or measure objects onto the axis when the “Place
dimension objects here” or the “place measure objects here” tooltip appears.
6. to allocate more dimension and measure objects to each chart axis, repeat the previous two
7. to display the results in the chart, click the View Results button on the Report toolbar.
The chart displays the results corresponding to the objects you allocated to the chart axes.
8. Save the document.
Creating a chart from a table
This section explains how to change the tables to different charts using the Templates tab.
To create a chart from a table
1. Click the Templates tab.
2. Drag a template onto the chart or table you want to modify. You must drop the template
3. to move the dimensions or measures to different axes, click the View Structure button on
the Reporting toolbar and drag the objects you want to move onto the Data tab. Then, drag
and drop the objects you want to display on the chart from the Data tab onto each chart
4. Save the document.
To change a chart into a table
1. in the Document zone, right-click the chart you want to turn change into a table.
A drop-down menu displays.
2. Select Turn To.
The Turn to dialog box opens, which allows you to choose which table or chart you would
like to convert this chart to. by default, this dialog box shows the type of the block you are
currently working in.
3. from the Turn to dialog box, click the Tables tab.
The tables you can choose from appear in the Tables tab.
4. Select the appropriate type of table from the list.
5. Click OK.
The chart displays in the selected format.
Activity: Designing Web Intelligence Reports
Objective
• Improve the presentation of a report to make information easier to understand.
Instructions
1. create a new document using the eFashion universe showing Year, Quarter, and Quantity
sold. Filter to see only results for Q1.
2. Duplicate the table and paste the copy to the right of the existing table.
3. Change the presentation of the second block to a Vertical Group Bar chart.
Your results should look like:
4. Select the chart, click the Properties tab, and check Yes next to the Legend zone in the
Appearance area.
Your results should look like:
5. to try a different presentation, drag and drop the Horizontal Stacked template, from the
Templates tab, Charts folder, Bar folder, over your chart.
Your results should look like:
6. to turn the chart back into a table, right-click the chart and select Turn to. Select the Tables
tab and then select the Horizontal table tab, and click OK.
Your results should look like:
7. from the Template tab, drag the Radar Line template into an empty spot on your report.
8. Click the Data tab of the Report Manager and drag the Year object over to Place dimension
objects here placeholder, at the bottom of the chart.
Note: Be careful not to position this object on the optional placeholder.
9. Drag the Quantity sold object to the Place measure objects here placeholder, in the lower
portion of the chart.
10.Refresh the report data.
Your results should look like:
11.Save the document as Activity Tables & Charts.
SAP BusinessObjects Web Intelligence (SAP BO WEBI) Report Design Creating a chart