Specifying Data Use

Use

Exactly which data is displayed in the business graphic depends primarily on whether and in which columns of the list you make calculations:

If you donotmake any calculations:
- The first column with an alphanumeric data type is used for the axis that contains the characteristics of the chart.
  
  In vertical bar charts, this is usually the X axis; in bar charts, this is usually the Y axis.
- The first column with a numeric data type is used for the axis that contains the key figures of the chart.
  
  In vertical bar charts, this is usually the Y axis; in bar charts, this is usually the X axis.
  
  Example
  
  For example, the first column with an alphanumeric data type is the Airlines column, which contains the names of the airlines. The first column with a numeric data type is the Occupied column, which contains the number of occupied seats for each flight.
  
  The business graphic is to be a vertical bar chart.
  
  A column containing the name of the airline is displayed for each data record. The value in the Occupied column determines the height of each column in the chart.
  
  Note
  
  The user may not want to display each data record as a separate column. In the above example, the user may want the business graphic to display one column for each airline. You can achieve this, for example, by generating an intermediate result for each airline in the Occupied column. This produces a figure for each airline that is displayed in a single column in the chart.
If you make calculations:
- The first column with an alphanumeric data type is used for the axis that contains the characteristics of the chart.
- Each column that involves a calculation is displayed in the axis that contains the key figures for the chart.
If you create intermediateresults :
- Each column that is a criterion for intermediate results is displayed in the axis that contains the characteristics for the chart. If you specified more than one criterion, the combination of the criteria is displayed.
- Each column that involves a calculation is displayed in the axis that contains the key figures for the chart.

Prerequisites

You display the data in the list as a business graphic (see Displaying Business Graphics ).
The list contains at least one column with an alphanumeric data type and one with a numeric data type.

Procedure

Move the columns that contain the data for the business graphic to the left.
Make any calculations required to display additional data in the business graphic.
If required, reduce the number of elements represented in the business graphic by generating intermediate results.