Axis Labels¶

The axis labels can be configured for the X-Axis as well as for the Y-Axis and are either indicating a dimension member or the value for the data series. You have the option to configure elements such as a Prefix or Suffix as well as the option to stagger the axis labels in order to improve the readability.

Ticks¶

Ticks are the lines placed along an axis to show either the different values or to show the different dimension members. You can configure the details, such as the Tick Interval, Tick Placement, and Tick Position in the category for each of the axis in the Additional Properties. In addition you have the option to enable major and minor ticks for the chart.

Gridlines¶

In addition to the option to enable ticks for the axis, you can also enable gridlines for the X-Axis as well as the Y-Axis. You can configure elements, such as the gridline color, gridline style, and gridline width for each of the axis of the chart. Minor and major gridlines are available for the values axis, and major gridlines are available for the dimension axis.

Layout and Positioning¶

VBX Chart elements such as axis labels, data labels, legends, titles, and the export button can be positioned horizontally and vertically - relative to the top left corner - using the properties “Align” and “Vertical Align”. The “Align” option can have the values left, right, and center. The Vertical Align property can have the values top, bottom, and middle.

Plot Area, Margin, and Padding¶

The plot area of the chart is the area within the axis, where the data series are plotted. In Figure 4.4 the plot area is shown as an orange box. The margin options (Left Margin, Top Margin, etc) define the margin between the chart plot area and the chart borders. The padding options (Left Padding, Top Padding, etc) define the padding between the outer area of the chart and all elements inside the chart area, such as data labels and a legend.

Figure 4.4: Plot Area, Margin and Padding in VBX Charts

Borders¶

For chart elements, such as data labels, labels, and the legend it is possible to define border details as part of the Additional Properties. The properties Border Width and Border Color can be used to define the border details. In addition, the property Border Radius can be used to enable curved edges.

Fonts¶

All layout elements of the chart that include text have a Style option that allows setting text related properties such as Font Color, Font Style, Font Size, and Font Family. In addition there is an option to define a global override option and to select a global font for all elements of the chart.

Animation¶

The property Animation provides you the option to activate the chart animation for situations where something has changed in the chart. A change in the chart could be the change of a dimension, a drill down, or a scripted change of other chart properties. The default duration of the animation is 500 ms.

Conditional Formatting based on a Single Measures¶

The first option for the Conditional Formatting is the ability to define rules based on a Single Measure. For our example we will assume that we have a Data source which outlines measure Net Value along 12 months of a year and we will use a Column / Bar Chart for our example (see Figure 4.5). In addition our data source also contains the measure Cost and Profit.

Figure 4.5: Column / Bar Chart

You can follow the steps below to configure Conditional Formatting based on a Single Measure:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measure Revenue along 12 months of the dimension Calendar Month.
3. Add a Column / Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Column / Bar Chart.
5. Navigate to the Additional Properties of the Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Data and to the sub category Conditional Formatting (see Figure 4.6).

Figure 4.6: Category Data

8. Now click on Create Rule (see Figure 4.7).

Figure 4.7: Conditional Formatting

9. Enter a Rule Name for your Rule.
10. Set the Rule Type to the option Single Measure.
11. You can now define the other properties for the rule, following the details in Table 4.1:

Label	Details
Rule Name	Here you can enter a Name for the Alert.
Rule Type	You can choose between : Single Measure, Measure Calculation, Target Value and Dimension.
Highlighted Measure	Here you can select the measure from the chart where the rule will be applied upon.
Comparison Measure	Here you can select the measure which will be compared against the Comparison Value.
Operator	Here you can choose the operator that is used to compare the Comparison Measure with the Comparison Value.
Comparison Value Type	Depending on the configured options, the property Comparison Value will allow to enter a static value, or setup a dynamic cell selection, or select a dynamic measure.
Dynamic Selection Value	In case you choose to setup a Dynamic Comparison Value, then you can choose between a Cell Selection and a Measure Selection. A Cell Selection allows you to select a single cell. A Measure Selection allows you to leverage a second measure as comparison and values will then be compared row by row.
Color	Here you can define the color for the Rule.

Table 4.1: Conditional Formatting – Single Measure

12. In our example we are setting up an alert based on the Rule Type Single Measure: (see Figure 4.8)
    • Highlighted Measure Net Value
    • Comparison Measure Profit
    • Operator Greater Than
    • Comparison Value Type Dynamic
    • Dynamic Selection Value Measure Selection
    • Comparison Value Cost
    • Color Green

Figure 4.8: Conditional Formatting

13. After configuring the details, please click Save. The rule will be added to the list and if required you can edit the details.

The configured Rule is now being applied to our chart and those values in the chart, which meet the requirement of our defined rule, will be color using colored green (see Figure 4.9).

Figure 4.9: Chart with Conditional Formatting

Conditional Formatting for Measures

Please note, that you can configure a conditional formatting based on all measures in the underlying data source from the chart itself and not just based on measures that are used in the chart itself.

Conditional Formatting based on a Measure Calculation¶

The second option for the Conditional Formatting is the ability to define rules based on a Measure Calculation. For our example we will assume that we have a Data source which outlines measure Net Value along 12 months of a year and we will use a Column / Bar Chart for our example. In addition our data source also contains the measure Cost and Profit.

You can follow the steps below to configure the Conditional Formatting based on a Measure Calculation:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measure Revenue along 12 months of the dimension Calendar Month.
3. Add a Column / Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Column / Bar Chart.
5. Navigate to the Additional Properties of the Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Data and to the sub category Conditional Formatting (see Figure 4.10).
8. Now click on Create Rule.
9. Enter a Rule Name for your Rule.
10. Set the Rule Type to the option Measure Calculation (see Figure 4.10).

Figure 4.10: Measure Calculation

11. You can now define the other properties for the rule, following the details in Table 4.2:

Label	Details
Rule Name	Here you can enter a Name for the Alert.
Rule Type	You can choose between : Single Measure, Measure Calculation, Target Value and Dimension.
Highlighted Measure	Here you can select the measure from the chart where the rule will be applied upon.
Comparison Measure	Here you can select the measure which will be compared against the outcome of the calculation.
Operator	Here you can choose the operator that is used to compare the Comparison Measure with the outcome of the measure calculation.
Measure 1	This property allows you to select the Measure 1 value for the Calculation.
Calculation Operator	Here you can choose the type of calculation. Available options are: Add, Subtract, Divide, Multiply.
Measure 2	This property allows you to select the Measure 2 value for the Calculation.
Color	Here you can define the color for the Rule.

Table 4.2: Conditional Formatting – Measure Calculation

12. In our example we are setting up an alert based on the Rule Type Measure Calculation:
    • Highlighted Measure Net Value
    • Comparison Measure Profit
    • Operator Greater Than
    • Measure 1 Net Value
    • Calculation Operator Subtract
    • Measure 2 Cost
    • Color Green

Figure 4.11: Conditional Formatting

13. After configuring the details, please click Save. The rule will be added to the list and if required you can edit the details.

The configured Rule is now being applied to our chart and those values in the chart, which meet the requirement of our defined rule, will be color using colored green.

Conditional Formatting based on a Target Value¶

The third option for the Conditional Formatting is the ability to define rules based on a Target Value achievement. For our example we will assume that we have a Data source which outlines measure Net Value along 12 months of a year and we will use a Column / Bar Chart for our example. In addition our data source also contains the measure Profit.

You can follow the steps below to configure the Conditional Formatting based on a Target Value:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measure Revenue along 12 months of the dimension Calendar Month.
3. Add a Column / Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Column / Bar Chart.
5. Navigate to the Additional Properties of the Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Data and to the sub category Conditional Formatting (see Figure 4.12).
8. Now click on Create Rule.
9. Enter a Rule Name for your Rule.
10. Set the Rule Type to the option Target Value (see Figure 4.12).

Figure 4.12: Measure Calculation

11. You can now define the other properties for the rule, following the details in Table 4.3:

Label	Details
Rule Name	Here you can enter a Name for the Alert.
Rule Type	You can choose between : Single Measure, Measure Calculation, Target Value and Dimension.
Highlighted Measure	Here you can select the measure from the chart where the rule will be applied upon.
Comparison Measure	Here you can select the measure which will be compared against the Target Value.
Target Value Type	Here you can choose between a Static and a Dynamic Target Value.
Target Value	Depending on the configured options, the property Target Value will allow to enter a static value, or setup a dynamic cell selection, or select a dynamic measure.
Dynamic Selection Value	In case you choose to setup a Dynamic Comparison Value, then you can choose between a Cell Selection and a Measure Selection. A Cell Selection allows you to select a single cell. A Measure Selection allows you to leverage a second measure as comparison and values will then be compared row by row.

Table 4.3: Conditional Formatting – Target Value

12. In our example we are setting up an alert based on the Rule Type Target Value:
    • Highlighted Measure Net Value
    • Comparison Measure Profit
    • Target Value Type Dynamic
    • Dynamic Selection Type Measure Selection
    • Target Value Net Value
13. After configuring the basic items, please click on Create in the Rules area to add the first rule for the Target Value achievement (see Figure 4.13).

Figure 4.13: Target Value Achievement

14. You can now enter the rules and per rule you can define the color.
15. After you finished the details, please click on Save to add the rule to the chart.

The configured Rule is now being applied to our chart and those values in the chart, which meet the requirement of our defined rule, will be colored following the detailed rules.

Conditional Formatting based on a Dimension Member¶

The fourth option for the Conditional Formatting is the ability to define rules based on specific dimension member. For our example we will assume that we have a Data source which outlines measure Net Value along a set of Products and we will use a Column / Bar Chart for our example.

You can follow the steps below to configure the Conditional Formatting based on a Target Value:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measure Revenue along a set of Products.
3. Add a Column / Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Column / Bar Chart.
5. Navigate to the Additional Properties of the Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Data and to the sub category Conditional Formatting (see Figure 4.14).
8. Now click on Create Rule.
9. Enter a Rule Name for your Rule.
10. Set the Rule Type to the option Dimension (see Figure 4.14).

Figure 4.14: Dimension

11. You can now define the other properties for the rule, following the details in Table 4.4:

Label	Details
Rule Name	Here you can enter a Name for the Alert.
Rule Type	You can choose between : Single Measure, Measure Calculation, Target Value and Dimension.
Dimension	Here you can select the dimension which you would like to choose a member from.
Dimension Member	Here you can select the dimension member you would like to highlight in the chart.
Color	Here you can set the color.

Table 4.4: Conditional Formatting – Dimension

12. After you finished the details, please click on Save to add the rule to the chart.

In this scenario the selected dimension members will be highlighted with the defined color.

Lasso Selection¶

As part of the standard menu of the Visual BI Extension Charts you have the option to select the Lasso option (see Figure 4.32). The Lasso option will select those elements in the chart that are inside the selected area. For our example, we will use a Column Chart with two measures – Forecast Amount and Sales Amount – and several dimension members.

Figure 4.32: Lasso – Chart Menu

1. After you have activated the Lasso option from the chart menu, you can then select the elements in the chart (see Figure 4.33)– in our example the measures for dimension member Round Rugs and Curtains.

Figure 4.33: Item Selection in chart

2. After you selected the items, the selected items will follow the color assignment for the selected items (see Figure 4.34) and the selected members can also be retrieved using the scripting functions for the chart.

Figure 4.34: Lasso

Reverse Lasso Selection¶

As part of the standard menu of the Visual BI Extension Charts you have the option to select the Reverse Lasso option (see Figure 4.35). The Reverse Lasso option will select those elements in the chart that are outside the selected area. For our example, we will use a Column Chart with two measures – Forecast Amount and Sales Amount – and several dimension members.

Figure 4.35: Reverse Lasso – Chart Menu

1. After you have activated the Reverse Lasso option from the chart menu, you can then select the elements in the chart (see Figure 4.36) – in our example the measures for dimension member Round Rugs and Curtains.

Figure 4.36: Item Selection in chart

2. After you have selected the items, the items outside the selected area will follow the color assignment for the unselected items (see Figure 4.37) and the unselected members can also be retrieved using the scripting functions for the chart.

Figure 4.37: Reverse Lasso

In the last section we have outlined the steps on you can leverage the Lasso and Reverse Lasso selection with the Visual BI Extension charts. In the next section, we will outline on the steps on you can enable / disable a Loading message for the Visual BI Extension chart.

Show Loading¶

As part of the chart functionality you have the option to enable / disable a Loading message for situations, for example, where the chart is loading a larger dataset. You can use scripting functions to trigger the showing and hiding of the loading message.

You can follow the steps below for an example:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows two measures - Forecast Amount and Sales Amount – and one dimension Product.
3. Add a Column Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Make sure the Name of your Column Bar Chart in the Standard Properties is shown as CHART1.
5. Assign the data source to the Column Bar Chart.
6. Navigate to the Additional Properties of the Column Bar Chart.
7. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
8. Navigate to the category Scripting in the Additional Properties of the Column Bar Chart.
9. Open the script editor for the event After Chart Load.
10. Add the following scripting:

CHART1.DSXShowLoading();

11. Click OK to close the script editor.
12. Navigate to the menu Application • Save.
13. Select the menu Application • Execute Locally.
14. You will be able to view the loading message for the chart (see Figure 4.38).

Figure 4.38: Loading Message

Hide Loading¶

In the previous steps we enabled the loading message and in the next steps we will incorporate the hiding of the message.

You can follow the steps below for an example:

1. Use the project we created in the previous steps with the loading message being shown when the chart is being loaded.
2. We will now add a button to the dashboard that will allow you to hide the loading message.
3. Ensure you have the previous project open in SAP BusinessObjects Design Studio/SAP Lumira Designer.
4. Add a Button from the Basic Components to the canvas.
5. Ensure that the Button is being placed outside of the chart area, so that the button will not overlap with the loading message for the chart.
6. Navigate to the Standard Properties of the Button.
7. In case the Standard Properties are not shown, please use the menu View • Properties to activate the display of the Standard Properties.
8. Open the script editor for the onClick.
9. Add the following scripting:

CHART2.DSXHideLoading();

10. Click OK to close the script editor.
11. Navigate to the menu Application • Save.
12. Select the menu Application • Execute Locally.

You will be able to view the chart and initially the loading message will be shown and you have the option to click on the button to hide the loading message (see Figure 4.39).

Figure 4.39: Hiding Message

Enabling the Context and Actions Menu¶

As part of the category Context Menu you can enable / disable the Context Menu using the property Activate Context Menu and the Actions Menu using the Enable Actions Menu option (see Figure 4.45). After you have enabled the Context Menu, you can open the context menu as part of the dashboard at runtime using a right-click and you can open the Actions Menu in the top right corner of the chart (see Figure 4.46).

Please also keep in mind, that when the Actions Menu is enabled, the typical Export menu is disabled and the Export options are being integrated into the Actions Menu.

Figure 4.46: Enabled Context Menu

Enable Maximize Option¶

The property Enable Maximize Option allows you to maximize the chart. When you maximize the chart, the chart will leverage the full screen space that is available, and when minimized again, the chart will leverage the configured space as part of the overall dashboard. Figure 4.47 shows the full screen space for the chart when maximize option is enabled.

Figure 4.47: Enable Maximize Option

Figure 4.48 shows the configured space for the chart as part of the overall dashboard when minimize option is enabled.

Figure 4.48: Restore Option

Enable Display Data Option¶

The property Enable Display Data Option allows you to display the chart data in a separate window that shows the data in form of a table. In case no element of the chart is selected, then the table will display the complete data source. In case elements of the chart have been selected, then the data for the selected elements will be shown in the table. You need to click the grid icon and view the Table format for the selected element (see Figure 4.49).

Figure 4.49: Element selection for Data Display

Figure 4.50 represents the chart data in a separate window that shows the data in form of a table when you click the grid icon.

Figure 4.50: Data Display in Table format

Enable Actions Menu¶

The property Enable Actions Menu is enabling all the selected Menu options. You can then open the Actions Menu and choose the menu option from the symbol in the top right corner of the chart (see Figure 4.51).

Figure 4.51: Actions Menu Option

Figure 4.52 shows the selected list of Menu options when you click the symbol in the top right corner of the chart.

Figure 4.52: Context Menu Display

Context Menu Options¶

In the area Context Menu Options (see Figure 4.53), you have the option to select, which menu options will be available as part of the overall Context Menu and Actions Menu.

Figure 4.53: Context Menu Options

Sort¶

The Context Menu Sort allows you to sort the information displayed in the chart based on Dimension values or based on Measure values (see Figure 4.54).

Figure 4.54: Sort Option for the Dimension

Ranking¶

The Context Menu Ranking allows you to rank the information in the chart based on predefined conditions, such as Top 5, Top 10, Bottom 5, Bottom 10, or to use the option Top N or Bottom N to define a custom ranking based on the available measures.

Figure 4.55: Top 5 Ranking

Swap With¶

The Context Menu Swap With allows you to exchange the current dimension used by the chart with another dimension from the assigned data source (see Figure 4.56) and in that way quickly change the dimension used by the chart.

Figure 4.56: Swap from Continent to Region

Dimension Display¶

The Context Menu Dimension Display allows you to choose, which elements of a dimension will be displayed. You can choose between Key, Text, or a combination of Key and Text values, as well as the option Default. The option Default will leverage the configuration from the Initial View of the data source (see Figure 4.57).

Figure 4.57: Dimension Display

Select Measure¶

The Context Menu Select Measure (see Figure 4.58) allows you to choose which measure(s) will be displayed as part of the chart. By default, the chart will display those measure which have been configured for the chart as part of the initial design, but by using the Context Menu you have the option to choose other or additional measures.

Figure 4.58: Select Measure

Show / Hide Chart Elements¶

The Context Menu Show / Hide allows you to configure a set of chart elements to be displayed or to be hidden (see Figure 4.59).

Figure 4.59: Show / Hide option

Totals¶

The Context Menu Totals allows you to switch on / off the usage of Totals and Subtotals (see Figure 4.60).

Figure 4.60: Totals Option

Export As¶

The Context Menu Export As allows you to export the content of the chart into different formats (see Figure 4.61). The available export formats are PDF, PNG, JPEG and SVG.

Figure 4.61: Export As

Lasso / Zoom¶

The Context Menu Lasso / Zoom allows you to choose between a Lasso, Reverse Lasso, or Zoom functionality. You can enable one of those options, which then will become the action that is being performed when you interact with the chart (see Figure 4.62).

Figure 4.62: Lasso/Zoom

Conditional Formatting¶

The Context Menu Conditional Formatting provides you with the ability to enable / disable previously configured Conditional Formatting rules.

Figure 4.63: Conditional Formatting

Context Menu Filter¶

In case you have selected a single item or multiple items as part of the chart, you also have the option to use the menu option Filter via the Context Menu (see Figure 4.64). As part of the Filter menu you will be allowed to perform three different filter functions:

• Include – The selected items will be included into the chart.
• Exclude – The selected items will be excluded from the chart.
• Clear Filter – Any configured filter values will be removed.

Figure 4.64: Context Menu Filter

Drill Down¶

In case you select a single or multiple items in the chart, you can also leverage the Drill Down menu as part of the Context Menu (see Figure 4.65). As part of the Drill Down menu, you will be shown the list of dimensions from the assigned data source and can choose to which dimension you would like to drill.

Figure 4.65: Drill down

After a successful Drill Down, you will be able to leverage the Drill Up (see Figure 4.66) menu option and can choose to which level you would like to navigate back.

Figure 4.66: Drill Up

Mobile Device Navigation¶

The property Mobile Device Navigation allows you to configure, which navigation option should be configured to be used on a mobile device for opening the Context Menu. The options are Long Press and Double Tap.

Figure 4.67: Mobile Device Navigation

Data Source Definition¶

As part of the Data Utility tool, you have the option to configure the property “Data Source Definition” to be based on the Technical ID or to be based on the Index.

• The option Technical ID allows you to specify the dimensions and measures based on their technical names.
• The option Index Based allows you to specify an index value (zero based index), and the index will specify the position of the dimension or measure in the assigned data source. For example a index of 2 for the measure will then use the third measure (0, 1, 2) of the assigned data source. By using the option Index based, you can keep the dimension and measure assignment dynamic, as the Data Utility will then always leverage the dimensions and measures based on the assigned index, even when there are changes in the underlying structure of the data source.

For our example we will select the option “Technical ID” as shown in Figure 4.105. The dimension Region is selected, along with the measures Profit and Net Value.

Figure 4.105: Data Utility

You also have the option to set the following properties for the Data Utility (see Figure 4.105).

• Include Result from Data Source: This property allows you to include Totals and Subtotals from the Initial View of the Data source.
• Include Result: When this property is activated, you have the option to include totals / subtotals for the selected dimension / measures and choose the aggregation function in the next property.
• Measure Aggregation: Using this property, you can configure the aggregation function for the totals / subtotals. The available options are: Min, Max, Average, Count, Distinct Count, Sum, Percentage Share, and Running Total.
• Suppression Type – This property allows you to configure a Zero and Null suppression for the Rows and Columns. The Zero / Null Suppression will be performed on the configured element of the Data Utility Tool.

Category General¶

The following section outlines the available Additional Properties for the category General.

Sub category	Area	Property	Description
Chart Titles	Title	Enable Chart Title	This property allows to enable / disable the chart title.
		Chart Title Text	Here you can enter the chart title text.
		Font Family	Set the Font Family for the chart Title.
		Font Size	Set the Font Size for the chart Title.
		Font Color	Set the Font Color for the chart Title.
		Font Style	Set the Font Style for the chart Title.
		Horizontal Alignment	Here you can specify the horizontal alignment.
		Vertical Alignment	Here you can specify the vertical alignment.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Title relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Title relative to its default alignment.
		Enable Floating	When enabled, the plot area will not assign specific space for the title.
		Margin	Here you can specify the space between the title and the chart plot area or the chart subtitle (if enabled).
	Subtitle	Enable Chart Subtitle	This property allows to enable / disable the chart subtitle.
		Chart Subtitle Text	Here you can enter the chart subtitle text.
		Font Family	Set the Font Family for the chart Subtitle.
		Font Size	Set the Font Size for the chart Subtitle.
		Font Color	Set the Font Color for the chart Subtitle.
		Font Style	Set the Font Style for the chart Subtitle.
		Horizontal Alignment	Here you can specify the horizontal alignment.
		Vertical Alignment	Here you can specify the vertical alignment.
		Enable Floating	When enabled, the plot area will not assign specific space for the subtitle.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Subtitle relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Subtitle relative to its default alignment.
		Enable Floating	When enabled, the plot area will not assign specific space for the title.
X-Axis	General Settings	Enable Decimals	When enabled, the values on the X-Axis can contain decimals.
		Axis Ceiling	Here you can set the highest allowed value for the automatically scaled X-Axis. The upper limit displayed in the chart may be lower if the values are smaller. To manually enforce the display of a specific upper limit in the chart, use Maximum property instead.
		Axis Floor	Here you can set the lowest allowed value for the automatically scaled X-Axis. The lower limit displayed in the chart may be higher if the values are larger. To manually enforce the display of a specific lower limit in the chart, use Minimum property instead.
		Axis Minimum Value	Minimum value of the X-Axis. When this property is set to the value null then the minimum value is calculated automatically.
		Axis Maximum Value	Maximum value of the X-Axis. When this property is set to the value null then the maximum value is calculated automatically.
		Show Axis To Top	By activating this property, the X-Axis will be displayed at the Top of the chart.
		Enable Reverse Axis	By activating this property, the X-Axis will be reversed, so that the highest number is closer to the origin.
		Minimum Padding	Here you can enter a percentage value by which the X-Axis has to be padded to avoid the minimum value appearing closer to the edge of the plot area. This property works only when the Minimum is not set as a fixed value.
		Maximum Padding	Here you can enter a percentage value by which the X-Axis has to be padded to avoid the maximum value appearing closer to the edge of the plot area. This property works only when the Maximum is not set as a fixed value.
		Vertical Axis Offset	This property allows to specify the Vertical Offset of the X-Axis relative to its default alignment.
	Axis Title	Enable X-Axis Title	This property enables / disables the X-Axis Title.
		Axis Title Text	Set the title text for the axis.
		Font Family	Sets the Font Family for the X-Axis Title.
		Font Size	Sets the Font Size for the X-Axis Title.
		Font Color	Sets the Font Color for the X-Axis Title.
		Font Style	Sets the Font Style for the X-Axis Title.
		Horizontal Alignment	This property allows to configure the horizontal alignment of the X-Axis Title.
		Vertical Alignment	This property allows to configure the vertical alignment of the X-Axis Title.
		Vertical Offset	This property allows to specify the Vertical Offset of the X-Axis Title relative to its default alignment.
		Rotation	Here you can specify a degree value by which the X-Axis Text will be rotated.
		Title Margin	Here you can specify the distance between the X-Axis Title and the X-Axis Labels and X-Axis Line.
	Axis Label	Enable Axis Label	This property allows to enable / disable the Labels for the X-Axis.
		Enable Auto Scale	When activated, the X-Axis will automatically be scaled based on the assigned data. When disabled, the X-Axis will use the values configured in the Additional Properties for a manual scale.
		Label Prefix	This property allows to specify a Prefix for the X-Axis Labels.
		Label Suffix	This property allows to specify a Suffix for the X-Axis Labels.
		Show Empty Values	When enabled, the X-Axis Label as well as the X-Axis line will be displayed for empty values.
		Show First Label	When activated, the first label will be shown on the axis.
		Show Last Label	When activated, the last label will be shown on the axis.
		Show N’th Label	This property allows you to specify a value to display every N th label on the X-Axis. When set to 1, every label for the X-Axis will be shown. Set it to blank to have the component automatically calculate a value that will avoid overlapping.
		No of Stagger Lines	Here you can specify the number of rows which can be used to stagger the X-Axis labels. The property Stagger Lines will force the X-Axis labels to be staggered across the number of rows.
		Maximum No of Stagger Lines	This property allows you to specify a maximum number of rows for staggering X-Axis labels. This property is only applicable when the property Stagger Lines is not defined. The property Max Stagger Lines will stagger the X-Axis labels on when space is required.
		Font Family	Sets the Font Family for the X-Axis Label.
		Font Size	Sets the Font Size for the X-Axis Label.
		Font Color	Sets the Font Color for the X-Axis Label.
		Font Style	Sets the Font Style for the X-Axis Label.
		Horizontal Alignment	This property allows to configure the horizontal alignment of the X-Axis Labels.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the X-Axis Label relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the X-Axis Label relative to its default alignment.
		Send Forward/Backwar d	This property allows you to specify a number, by which the X-Axis Label for the X-Axis will be moved forward or backwards.
		Rotation	Here you can specify a degree value by which the X-Axis Labels will be rotated.
	Axis Line	Axis Line Color	Sets the Color for the X-Axis Line.
		Axis Line Width	Sets the Width for the X-Axis Line.
		Alternate Grid Color	Here you can configure the color for the space between alternate grid lines in the plot area.
	Axis Grid Line	Major Grid Line Color	Set the Color for the Major Grid Lines.
		Major Grid Line Style	Set the style for the Major Grid Lines.
		Major Grid Line Width	Set the Width for the Major Grid Lines.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Grid Lines for the X-Axis will be moved forward or backwards.
	Ticks	Major Tick Interval	Sets the Interval for the Major Ticks on the X-Axis.
		Major Tick Mark Placement	Defines the Major Ticks Placement. The available options are On and Between.
		Major Tick Position	Defines the Major Ticks Position. The available options are Inside and Outside.
		Major Tick Color	Defines the Major Ticks Color.
		Major Tick Length	Defines the Major Ticks Length.
		Major Tick Width	Defines the Major Ticks Width.
		Minor Tick Interval	Sets the Interval for the Minor Ticks on the X-Axis.
	Plot Band	Enable Plot Band	This property enables / disables the Plot Band option.
		Start Value	Here you specify the start position for the Plot Band. The value is index based and refers to the index position of the values in the chart.
		End Value	Here you specify the end position for the Plot Band. The value is index based and refers to the index position of the values in the chart.
		Plot Band Color	Sets the Color for the Plot Band.
		Border Color	Sets the Border Color for the Plot Band.
		Border Width	Sets the Border Width for the Plot Band.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Plot Band for the X-Axis will be moved forward or backwards.
		Enable Plot Band Label	This property enables / disables the Plot Band Label option.
		Label Text	Here you can specify the Plot Band Label Text.
		Label Font Family	Sets the Font Family for the Plot Band Label.
		Label Font Size	Sets the Font Size for the Plot Band Label.
		Label Font Color	Sets the Font Color for the Plot Band Label.
		Label Font Style	Sets the Font Style for the Plot Band Label.
		Label Horizontal Alignment	This property allows to configure the horizontal alignment of the Plot Band Label.
		Label Vertical Alignment	This property allows to configure the vertical alignment of the Plot Band Label.
		Label Text Horizontal Alignment	This property allows to configure the horizontal alignment of the Label Text within the Plot Band Label.
		Label Horizontal Offset	This property allows to specify the Horizontal Offset of the Plot Band Label relative to its default alignment.
		Label Vertical Offset	This property allows to specify the Vertical Offset of the Plot Band Label relative to its default alignment.
		Label Rotation	Here you can specify a degree value by which the Plot Band Label will be rotated.
	Plot Line	Enable Plot Line	This property enables / disables the Plot Line option.
		Plot Line Value	Here you specify the position for the Plot Line. The value is index based and refers to the index position of the values in the chart.
		Plot Line Style	Sets the Dashstyle for the Plot Line.
		Plot Line Color	Sets the Color for the Plot Line.
		Plot Line Width	Sets the Width for the Plot Line.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Plot Line for the X-Axis will be moved forward or backwards.
		Enable Plot Line Label	This property enables / disables the Plot Line Label option.
		Plot Line Label Text	Here you can specify the Plot Line Label Text.
		Label Font Family	Sets the Font Family for the Plot Line Label.
		Label Font Size	Sets the Font Size for the Plot Line Label.
		Label Font Color	Sets the Font Color for the Plot Line Label.
		Label Font Style	Sets the Font Style for the Plot Line Label.
		Label Vertical Alignment	Vertical alignment of the label within the text box.
		Label Text Alignment	This property allows to configure the horizontal alignment of the Plot Line Label Text within the Label.
		Label Horizontal Offset	This property allows to specify the Horizontal Offset of the Plot Line Label relative to its default alignment.
		Label Vertical Offset	This property allows to specify the Vertical Offset of the Plot Line Label relative to its default alignment.
		Label Rotation	Here you can specify a degree value by which the Plot Line Label will be rotated.
Y-Axis	General Settings	Enable Decimals	When enabled, the values on the Y-Axis can contain decimals.
		Axis Ceiling	Here you can set the highest allowed value for the automatically scaled Y-Axis. The upper limit displayed in the chart may be lower if the values are smaller. To manually enforce the display of a specific upper limit in the chart, use Maximum property instead.
		Axis Floor	Here you can set the lowest allowed value for the automatically scaled Y-Axis. The lower limit displayed in the chart may be higher if the values are larger. To manually enforce the display of a specific lower limit in the chart, use Minimum property instead.
		Axis Maximum	Maximum value of the Y-Axis. When this property is set to the value null then the maximum value is calculated automatically.
		Axis Minimum	Minimum value of the Y-Axis. When this property is set to the value null then the minimum value is calculated automatically.
		Show Axis on opposite side	By activating this property, the Y-Axis will be displayed at the opposite side of the chart.
		Enable Reverse Axis	By activating this property, the Y-Axis will be reversed, so that the highest number is closer to the origin.
		Minimum Padding	Here you can enter a percentage value by which the Y-Axis has to be padded to avoid the minimum value appearing closer to the edge of the plot area. This property works only when the Minimum is not set as a fixed value.
		Maximum Padding	Here you can enter a percentage value by which the Y-Axis has to be padded to avoid the maximum value appearing closer to the edge of the plot area. This property works only when the Maximum is not set as a fixed value.
		Horizontal Axis Offset	This property allows to specify the Horizontal Offset of the Y-Axis relative to its default alignment.
	Axis Title	Enable Y-Axis Title	This property enables / disables the Y-Axis Title.
		Title Text	Set the title text for the axis.
		Font Family	Sets the Font Family for the Y-Axis Title.
		Font Size	Sets the Font Size for the Y-Axis Title.
		Font Style	Sets the Font Style for the Y-Axis Title.
		Font Color	Sets the Font Color for the Y-Axis Title.
		Vertical Alignment	This property allows to configure the vertical alignment of the Y-Axis Title.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Y-Axis Title relative to its default alignment.
		Rotation	Here you can specify a degree value by which the Y-Axis Text will be rotated.
		Margin	Here you can specify the distance between the Y-Axis Title and the Y-Axis Labels and Y-Axis Line.
	Identical Scaling	Select Group	Here you can select a Axis Group from a list of already existing groups.
		Identical Scaling Group Name	Here you can specify a Axis Group Name which will be used to identify all charts which will use an identical scaling.
	Axis Label	Enable Axis Label	This property allows to enable / disable the Labels for the Y-Axis.
		Enable Auto Scale	When activated, the Y-Axis will automatically be scaled based on the assigned data. When disabled, the Y-Axis will use the values configured in the Additional Properties for a manual scale.
		Label Prefix	This property allows to specify a Prefix for the Y-Axis Labels.
		Label Suffix	This property allows to specify a Suffix for the Y-Axis Labels.
		Show Empty Values	When enabled, the Y-Axis Label as well as the Y-Axis line will be displayed for empty values.
		Show First Label	When activated, the first label will be shown on the axis.
		Show Last Label	When activated, the last label will be shown on the axis.
		Show N’th Label	This property allows you to specify a value to display every N th label on the Y-Axis. When set to 1, every label for the Y-Axis will be shown. Set it to blank to have the component automatically calculate a value that will avoid overlapping.
		No of Stagger Lines	Here you can specify the number of rows which can be used to stagger the Y-Axis labels. The property Stagger Lines will force the Y-Axis labels to be staggered across the number of rows.
		Maximum No of Stagger Lines	This property allows you to specify a maximum number of rows for staggering Y-Axis labels. This property is only applicable when the property Stagger Lines is not defined. The property Max Stagger Lines will stagger the Y-Axis labels on when space is required.
		Font Family	Sets the Font Family for the Y-Axis Label.
		Font Size	Sets the Font Size for the Y-Axis Label.
		Font Color	Sets the Font Color for the Y-Axis Label.
		Font Style	Sets the Font Style for the Y-Axis Label.
		Label Alignment	This property allows to configure the Vertical alignment of the Y-Axis Labels.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Y-Axis Label relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Y-Axis Label relative to its default alignment.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Y-Axis Label for the Y-Axis will be moved forward or backwards.
		Rotation	Here you can specify a degree value by which the Y-Axis Label will be rotated.
	Axis Line	Axis Line Color	Sets the Color for the X-Axis Line.
		Axis Line Width	Sets the Width for the X-Axis Line.
		Alternate Grid Color	Here you can configure the color for the space between alternate grid lines in the plot area.
	Axis Grid Lines Ticks	Major Grid Line Color	Set the Color for the Major Grid Lines.
		Minor Grid Line Style	Set the Dashstyle for the Minor Grid Lines.
		Major Grid Line Width	Set the Width for the Major Grid Lines.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Grid Lines for the Y-Axis will be moved forward or backwards.
		Minor Grid Line Color	Set the Color for the Minor Grid Lines.
		Major Grid Line Style	Set the Dashstyle for the Major Grid Lines.
		Minor Grid Line Width	Set the Width for the Minor Grid Lines.
		Major Tick Interval	Sets the Interval for the Major Ticks on the Y-Axis.
		Major Tick Position	Defines the Major Ticks Position. The available options are Inside and Outside.
		Major Tick Color	Defines the Major Ticks Color.
		Major Tick Length	Defines the Major Ticks Length.
		Major Tick Width	Defines the Major Ticks Width.
		Minor Tick Interval	Sets the Interval for the Minor Ticks on the Y-Axis.
		Minor Tick Position	Defines the Minor Ticks Position. The available options are Inside and Outside.
		Minor Tick Color	Defines the Minor Ticks Color.
		Minor Tick Length	Defines the Minor Ticks Length.
		Minor Tick Width	Defines the Minor Ticks Width.
	Plot Band	Enable Plot Band	This property enables / disables the Plot Band option.
		Start Value	Here you specify the start position for the Plot Band. The value is index based and refers to the index position of the values in the chart.
		End Value	Here you specify the end position for the Plot Band. The value is index based and refers to the index position of the values in the chart.
		Plot Band Color	Sets the Color for the Plot Band.
		Border Color	Sets the Border Color for the Plot Band.
		Border Width	Sets the Border Width for the Plot Band.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Plot Band for the Y-Axis will be moved forward or backwards.
		Enable Plot Band Label	This property enables / disables the Plot Band Label option.
		Label Text	Here you can specify the Plot Band Label Text.
		Label Font Family	Sets the Font Family for the Plot Band Label.
		Label Font Size	Sets the Font Size for the Plot Band Label.
		Label Font Color	Sets the Font Color for the Plot Band Label.
		Label Font Style	Sets the Font Style for the Plot Band Label.
		Label Horizontal Alignment	This property allows to configure the horizontal alignment of the Plot Band Label.
		Label Vertical Alignment	This property allows to configure the vertical alignment of the Plot Band Label.
		Label Text Alignment	This property allows to configure the horizontal alignment of the Label Text.
		Label Horizontal Offset	This property allows to specify the Horizontal Offset of the Plot Band Label relative to its default alignment.
		Label Vertical Offset	This property allows to specify the Vertical Offset of the Plot Band Label relative to its default alignment.
		Label Rotation	Here you can specify a degree value by which the Plot Band Label will be rotated.
	Plot Line	Enable Plot Line	This property enables / disables the Plot Line option.
		Plot Line Value	Here you specify the position for the Plot Line. The value is index based and refers to the index position of the values in the chart.
		Plot Line Color	Sets the Color for the Plot Line.
		Plot Line Width	Sets the Width for the Plot Line.
		Plot Line Style	Sets the Dashstyle for the Plot Line.
		Send Forward/Backwar d	This property allows you to specify a number, by which the Plot Line for the Y-Axis will be moved forward or backwards.
		Enable Plot Line Label	This property enables / disables the Plot Line Label option.
		Plot Line Label Text	Here you can specify the Plot Line Label Text.
		Font Family	Sets the Font Family for the Plot Line Label.
		Font Size	Sets the Font Size for the Plot Line Label.
		Font Color	Sets the Font Color for the Plot Line Label.
		Font Style	Sets the Font Style for the Plot Line Label.
		Label Horizontal Alignment	This property allows to configure the horizontal alignment of the Plot Line Label.
		Label Vertical Alignment	This property allows to configure the vertical alignment of the Plot Line Label.
		Label Text Alignment	This property allows to configure the horizontal alignment of the Plot Line Label Text within the Label.
		Label Horizontal Offset	This property allows to specify the Horizontal Offset of the Plot Line Label relative to its default alignment.
		Label Vertical Offset	This property allows to specify the Vertical Offset of the Plot Line Label relative to its default alignment.
		Label Rotation	Here you can specify a degree value by which the Plot Line Label will be rotated.
Pan & Zoom	Panning	Enable Panning	This property allows you to enable / disable the Panning functionality.
		Panning Key	With this setting you can define the key that you need to hold down to pan the chart when zoomed in. The available options are Shift and Ctrl.
	Zoom	Chart Zoom Type	Decide along which dimension a user can zoom by dragging the mouse - along x, y or both.
		Chart Pinch Type	Decide along which dimension a user can zoom by using multi-touch gestures - along x, y or both axis.
		Minimum Range X-Axis	Minimum Range on the X-Axis corresponds to the range shown when zoom on this axis is at its maximum. In other words, you will be unable to zoom to a scale lower than this minimum range.
		Minimum Range Y-Axis	Minimum Range on the Y-Axis corresponds to the range shown when zoom on this axis is at its maximum. In other words, you will be unable to zoom to a scale lower than this minimum range.
		Minimum Tick Interval Y-Axis	Set the smallest division to which the chart can be zoomed on the Y-axis.
	Reset Button	Horizontal Alignment	Set the Horizontal Alignment for the Reset Zoom button.
		Vertical Alignment	Set the Vertical Alignment for the Reset Zoom button.
		Background Color	Set the Background Color for the Zoom Button.
		Hover Background Color	Set the Background color for the Zoom Button on mouse over.
		Zoom Area Fill Color	Here you can set the Fill Color for the Zoom area being dragged by the cursor.
		Font Color	Set the Text Color for the display text on the button.
		Hover Font Color	Set the Text color for the Zoom Button on mouse over.
		Button Radius	Set the Radius for the Zoom Button.
Export	General Settings	Enable Export	This property allows you to enable / disable the Export option.
	Export File	Export File Name	Here you can define the file name for the Export. Please specify the file name without the extension.
		Chart Width	This property defines the Width of the exported chart in pixels. If unassigned, this will be determined automatically.
		Chart Height	This property defines the Height of the exported chart in pixels. If unassigned, this will be determined automatically.
		Chart Scale	This property defines the scale / zoom factor for the exported image compared to the on-screen display.
	Export Button	Button Type	Using this property, you can specify the Export Button type. Available options are: Menu, Circle, Diamond, and Square.
		Button Height	Height of the Export Button in pixels.
		Button Width	Width of the Export Button in pixels.
		Horizontal Alignment	Horizontal alignment for the Export Button.
		Vertical Alignment	Vertical alignment for the Export Button.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Export Button relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Export Button relative to its default alignment.
		Button Radius	This property sets the Radius for the Export Button.
		Background Fill Color	This property sets the Background Fill Color for the Export Button.
		Background Hover Fill Color	This property sets the Background Hover Fill Color for the Export Button.
	Export Icon	Icon Fill Color	This property configures the Fill Color for the Icon inside the Export Button.
		Icon Size	This property configures the Size for the Icon inside the Export Button.
		Icon Stroke Color	This property sets the Stroke Color for the Icon inside the Export Button.
		Icon Stroke Width	This property sets the Stroke Width for the Icon inside the Export Button.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Export Icon relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Export Icon relative to its default alignment.
	Dropdown Menu	Background Hover Fill Color	This property sets the Background Color for the Export Menu Items for mouse over.
		Background Fill Color	This property sets the Background Fill Color for the Export Menu.
		Item Font Color	This property sets the Font Color for the Export Menu Items.
		Item Font Style	This property sets the Font Style for the Export Menu Items.
		Item Hover Font Color	This property sets the Font Color for the Export Menu Items for mouse over.
		Item Hover Font Style	This property sets the Font Style for the Export Menu Items for mouse over.
Chart Credits	General Settings	Enable	This property allows to enable / disable the Metadata.
		URL	Here you can specify a hyperlink, which will be opened when the metadata text is clicked.
		Text	Here you can specify the Text that will be displayed.
	Appearance	Font Family	Sets the Font Family for the metadata text.
		Font Size	Sets the Font Size for the metadata text.
		Font Color	Sets the Font Color for the metadata text.
		Font Style	Set the Font Style for the metadata text.
		Credits Cursor	Here you can choose from either a Normal or a Pointer Cursor type.
		Horizontal Alignment	Horizontal alignment for the Text.
		Vertical Alignment	Vertical alignment for the Text.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Text relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Text relative to its default alignment.
Context Menu		Activate Context Menu	This property enables /disables the right click option for the Context Menu.
		Enable Maximize Option	This property enables /disables the Maximize Button for the Context Menu.
		Enable Display Data Option	This property enables /disables the Display Data option for the Context Menu.
		Enable Actions Menu	This property enables /disables the More Actions Button for the Context Menu.
		Context Menu Options	This property allows to include /exclude the following options for the Context Menu. Display Data Sort Filter Ranking Drill Down Drill Up Swap With Dimension Display Select Measure Show / Hide Totals Export As Lasso / Zoom Conditional Formatting
		Mobile Device Navigation	This property allows to configure, which navigation option should be configured to be used on a mobile device for opening the Context Menu. The options are Double Tap and Long Press.

Table 4.6: General

Category Data¶

The category Data contains properties and attributes related to the data for the chart. For charts such as the line or area chart, the Data category contains attributes that allow changing the layout of the markers displayed in the chart.

Sub category	Area	Property	Description
Data Utility		Enable Data Utility Tool	This property enables /disables the Data Utility Tool.
		Data Source Definition	Here you can select the option for the property Data Source Definition and the two different options are Technical ID Index based
		Select Dimension(s)	Here you can customize the Dimensions used in the Chart.
		Measure	Select a Measure from the Data Source for the chart.
		Include Result from Data Source	This property enables/disable s the Include Result from Data Source option.
		Include Result	When this property is activated, you have the option to include totals / subtotals for the selected dimension / measures and choose the aggregation function in the next property.
		Measure Aggregation	Using this property, you can configure the aggregation function for the totals / subtotals. The available options are: Min, Max, Average, Count, Distinct Count, Sum, Percentage Share, and Running Total.
		Suppression Type	This property allows you to configure if rows or columns (or both) with null and zero values should be suppressed from the result set.
Data Series	Ranking	Rank Top N	This property allows you to rank the information in the chart . For example, you can provide the values for the property Rank Top N based on your choice and visualize the ranking in the chart.
		Ranking Measure	This property allows you to select the Measure for the Ranking.
	Totals	Show Total	Enables the option to show the Total for the chart.
	Series Options	Color	Here you can configure the color for each data series.
		Enable/Disable	This property allows you to enable/disable the data series in the chart.
	Series Name Change	Series Name Change	Using this property you can change the labels for the measures from the assigned data source for this particular chart.
	Chart Settings	Select Measure for Volume	This property allows you to select the Measure value for volume of the slice for Spie Chart.
		Select Measure for Radius	This property allows you to select the Measure value for radius of the slice for Spie Chart.
Hierarchies	General Settings	Activate Hierarchical Labeling	This property enables/disable s the Hierarchical Labels for the X-Axis.
Conditional Formatting		Rule Name	Here you can enter a Name for the Alert.
		Rule Type	You can choose between : Single Measure, Measure Calculation, Target Value and Dimension.
		Highlighted Measure	Here you can select the measure from the chart where the rule will be applied upon.
		Comparison Measure	Here you can select the measure which will be compared against the Comparison Value.
		Operator	Here you can choose the operator that is used to compare the Comparison Measure with the Comparison Value.
		Comparison Value Type	Depending on the configured options, the property Comparison Value will allow to enter a static value, or setup a dynamic cell selection, or select a dynamic measure.
		Dynamic Selection Value	In case you choose to setup a Dynamic Comparison Value, then you can choose between a Cell Selection and a Measure Selection. A Cell Selection allows you to select a single cell. A Measure Selection allows you to leverage a second measure as comparison and values will then be compared row by row.
		Measure 1	This property allows you to select the Measure 1 value for the Calculation.
		Calculation Operator	Here you can choose the type of calculation. Available options are: Add, Subtract, Divide, Multiply.
		Measure 2	This property allows you to select the Measure 2 value for the Calculation.
		Target Value Type	Here you can choose between a Static and a Dynamic Target Value.
		Target Value	Depending on the configured options, the property Target Value will allow to enter a static value, or setup a dynamic cell selection, or select a dynamic measure.
		Dimension	Here you can select the dimension which you would like to choose a member from.
		Dimension Member	Here you can select the dimension member you would like to highlight in the chart.
		Color	Here you can define the color for the Rule.
Number Format		Apply Identical Number Format in all areas	This property allows to enable / disable the Identical Number Format in all areas.
		Component Area	This property sets the Component Area. The options are Data Label and Tooltip.
		Number Format Definition	This property allows you to select the options for Number Format Definition. The options are Initial View and Custom Number Format.
		Number of Decimals	This property allows to the define the Number of decimals for the Data Label/Tooltip.
		Thousand Separator	This property allows to the define the Thousand Separator for the Data Label/Tooltip.
		Decimal Separator	This property allows to the define the Decimal Separator for the Data Label/Tooltip.
		Show Scaling Unit	This property allows to enable / disable the Scaling Unit for the Data Label/Tooltip.
		Scaling Unit Placement	This property allows you to set the Scaling Unit Placement for the Data Label/Tooltip.
		Scaling Unit	This property allows you to set the Scaling Unit for the Data Label/Tooltip.
		Show Unit / Currency	This property allows to enable / disable the display of the configured Unit / Currency for the Data Label/Tooltip.
		Currency/Unit Placement	This property allows you to set the Currency/Unit Placement for the Data Label/Tooltip.
		Show Scaling Factor	This property allows to enable / disable the display of the configured Scaling Factor for the Data Label/Tooltip.
		Scaling Factor	The property allows you to specify a Scaling Factor, which then can be displayed together with the data value for the Data Label/Tooltip.
		Prefix	This property allows to configure the Prefix for the Data Label/Tooltip.
		Suffix	This property allows to configure the Suffix for the Data Label/Tooltip.
		Enable Semantic Formatting	This property activates the option for Semantic Formatting for the Data Label/Tooltip.
		Format for Negative Values	This property sets the Format for Negative Values for the Data Label/Tooltip.
		Color for Negative Values	This property sets the Color for Negative Values for the Data Label/Tooltip.
		Format for Positive Values	This property sets the Format for Positive Values for the Data Label/Tooltip.
		Color for Positive Values	This property sets the Color for Positive Values for the Data Label/Tooltip.
Trendline		Enable Trendline	This property enables/disable s the Trendline for the Charts.
		Trendline Color Identical to Data Series	This property enables/disable s the color identical to the Data Series for the Chart.
		Show Trendline Equation	This property enables/disable s the Trendline Equation for the Chart.
Error Bar		Enable Error Bar	This property enables/disable s the Error Bar for the Chart.
		Error Amount	This property sets the Error Amount type for the Chart. The options are Fixed Value, Percentage Value, Standard Deviation, or Custom.
		Error Amount Value	This property sets the Error Amount value for the Chart.
		Stem Color	This property allows you to specify the color for the Stem Line.
		Stem Style	This property allows you to specify the style for the Stem Line.
		Stem Width	This property allows you to specify the width for the Stem Line.
		Whisker Color	This property allows you to specify the color for the Whisker Line.
		Whisker Length	This property allows you to specify the length for the Whisker Line.
		Whisker Width	This property allows you to specify the width for the Whisker Line.

Table 4.7: Data

Category Appearance¶

The category Appearance provides access to properties that allow you to configure the look and feel of the chart, such as background color, border, data label, and plot options.

Sub category	Area	Property	Description
Chart	General Settings	Chart Type	Sets the chart type.
		Dimension Value Display	Select whether the dimension members should be displayed using the key, text, or key and text values.
		Allow Data Point Selection	This property allows the Series points to be selected.
		Ignore Hidden Series	When enabled, the axis scaling will only be based on the displayed series.
		Connect Null values	This property enables/disable s the option to connect the graph line across the null points.
		Enable Redraw	Resizes the chart to fit the container when the window is resized at runtime.
		Enable Master Detail	Enables/Disable s the Master Details Chart.
		Master Detail Chart Type	Select whether the type of charts should be displayed using Area, Column and Line charts.
		Enable Master Detail Axis	Enables/Disable s Master Detail Axis.
		Minimum Point Size	This property sets the maximum point size for the slice in Spie Chart.
		Minimum Point Size	This property sets the minimum point size for the slice in Spie Chart.
	Chart Area	Border Color	Here you can configure the Border Color for the chart.
		Border Width	Here you can configure the Border Width for the chart.
		Border Radius	Here you can configure the Border Radius for the chart.
		Enable Shadow	Applies a drop shadow on the outer chart area.
		Background Color	Here you can configure the Background Color for the chart.
	Chart Theme	Enable Custom Theme	Activates the Custom Theme option.
		Custom Theme Editor	Click on the link to navigate to the Custom Theme Editor.
		Custom Theme Code	Here you can insert the custom theme code.
	Plot Area	Enable Transparency	When enabled, the plot area becomes transparent.
		Background Color	Here you can set the Background Color for the plot area.
		Background Image	Here you can specify a background image, by specifying an Image URL, for example: http://www.samp le.com/images/b gImage.png.
		Border Color	Here you can set the Border Color for the plot area.
		Border Width	Here you can set the Border Width for the plot area.
		Enable Plot Area Shadow	Applies a drop shadow on the outer plot area.
		Margin Top	The Margin Bottom defines the margin between the chart plot area and the top chart border (see Figure 4.4).
		Margin Bottom	The Margin Bottom defines the margin between the chart plot area and the bottom chart border (see Figure 4.4).
		Margin Left	The Margin Left defines the margin between the chart plot area and the left chart border (see Figure 4.4).
		Margin Right	The Margin Right defines the margin between the chart plot area and the right chart border (see Figure 4.4).
		Padding Top	The padding options define the padding between the outer area of the chart and all elements inside the chart area, such as data labels and a legend. This property is for the Top area (see Figure 4.4).
		Padding Bottom	The padding options define the padding between the outer area of the chart and all elements inside the chart area, such as data labels and a legend. This property is for the Bottom area (see Figure 4.4).
		Padding Left	The padding options define the padding between the outer area of the chart and all elements inside the chart area, such as data labels and a legend. This property is for the Left area (see Figure 4.4).
		Padding Right	The padding options define the padding between the outer area of the chart and all elements inside the chart area, such as data labels and a legend. This property is for the Right area (see Figure 4.4).
	Chart Font	Enable Google Font	Here you can enable / disable the option for Google Font.
		Google Font Category	This property allows you to set the Font Category. The options are Serif, Sans serif, Display, Handwriting and Monospace.
		Google Font Family	Here you can select the Global Google Font Type. This option will be enabled only when Enable Google Font is activated.
Data Label		Enable Data Labels	This property allows you to enable / disable the display of the data labels.
		Font Style	Here you can set the Font Style for the Data Labels.
		Horizontal Alignment	This property allows you to set the horizontal alignment for the Data Label.
		Vertical Alignment	This property allows you to set the vertical alignment for the Data Label.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Data Label box relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Data Label box relative to its default alignment.
		Background Color	Here you can set the Background Color for the Data Label.
		Border Color	Here you can set the Border Color for the Data Label.
		Border Radius	Here you can set the Border Radius for the Data Label.
		Border Width	Here you can set the Border Width for the Data Label.
		Enable Crop	When activated, Data Labels outside the plot area will be cropped.
		Defer Display	When activated, the showing of the Data Labels will be delayed until the data series animation is complete.
		Allow Overlap	Allow Data Labels to be overlapped. By default, overlapping Data Labels are hidden.
		Label Padding	This property defined the Padding between the Data Label text and the borders.
		Label Rotation	Set the Text Rotation in degrees. Note: The Border and Background will be lost when the Data Label is rotated.
		Enable Shadow	This property allows you to enable / disable a Shadow for the Data Label box.
		Font Family	Sets the Font Family for the Data Labels.
		Font Size	Sets the Font Size for the Data Labels.
		Font Color	Sets the Font Color for the Data Labels.
Tooltip		Enable Tooltip	This property enables / disables the display of the Tooltip.
		Font Style	Set the Font Style for the Tooltip.
		Border Color	Define the Border Color for the Tooltip.
		Border Radius	Define the Border Radius for the Tooltip.
		Border Width	Define the Border Width for the Tooltip.
		Shape	The property allows you to specify the shape of the Tooltip. The available options are Callout, Oval, Rectangle.
		Hide delay	This is the amount of milliseconds by which the hiding of the tooltip is delayed, after you have moved the focus away from the particular data point.
		Enable Cross Hair	The Cross Hair property enables an additional visual help which follows the Tooltip to help locating the exact data value.
		Enable Shadow	Applies a drop shadow to the tooltip.
		Enable Animation	Enables the animation for the tooltip.
		Follow Mouse Pointer	Enables the Tooltip’s ability to follow the mouse pointer.
		Follow Touch Move	Enables the Tooltip’s ability to follow the pointer for touch devices.
		Shared Tooltip	When enabled, the entire plot area (all columns / data points) capture mouse movements or touch events.
		Snap to data	Proximity within which the Tooltip snaps to the data point in pixels.
		Font Family	Set the Font Family for the Tooltip.
		Font Size	Set the Font Size for the Tooltip.
		Font Color	Set the Font Color for the Tooltip.
		Background Color	Define the Background Color for the Tooltip.
Legend	Appearance	Enable Legend	This property allows you to enable / disable the Legend.
		Legend Layout	You can choose to list the legend items horizontally or vertically.
		Font Family	Set the Font Family for the navigation text.
		Font Size	Set the Font Size for the navigation text.
		Font Color	Set the Font Color for the navigation text.
		Font Style	Set the Font Style for the navigation text.
		Horizontal Alignment	This property allows to configure the Horizontal Alignment.
		Vertical Alignment	This property allows to configure the Vertical Alignment.
		Horizontal Offset	This property allows to specify the Horizontal Offset of the Legend relative to its default alignment.
		Vertical Offset	This property allows to specify the Vertical Offset of the Legend relative to its default alignment.
		Background Color	Set the Background Color for the legend area.
		Border Color	Set the Border Color for the legend area.
		Border Radius	Define the Border Radius for the legend area.
		Border Width	Define the Border Width for the legend area.
		Box Width	This property allows to specify the Legend Box Width.
		Margin	This property allows to define the distance between the Legend and the Axis Labels / Plot Area. The property is only applicable when the property Floating is disabled for the Legend.
		Padding	Inner padding of the Legend box.
		Enable Floating	When enabled, the plot area will not assign specific space for the legend.
		Enable Shadow	This property allows to enable / disable a drop shadow for the legend area.
	Legend Title	Title Text	Here you can define a Legend Title.
		Font Family	Set the Font Family for the Legend Title.
		Font Size	Set the Font Size for the Legend Title.
		Font Color	Set the Font Color for the Legend Title.
		Font Style	Set the Font Style for the Legend Title.
	Legend Item	Enable Reverse Order	Reverse the order of the legend items.
		RTL Support	Right to Left Support - for Arabic and Hebraic languages.
		Item Width	This property allows you to specify the Width for each Legend item.
		Item Distance	This property allows you to specify the distance between each Legend item. This property is only applicable for Legends with a horizontal layout.
		Item Margin Top	Here you can configure the Top Margin for each Legend Item.
		Item Margin Bottom	Here you can configure the Bottom Margin for each Legend Item.
		Hidden Item Color	Here you can define the color for Hidden Items in the Legend.
		Hovering Item Color	Here you can define the color for Mouse Over items in the Legend.
	Legend Symbol	Symbol Height	Here you can define the Symbol Height for each legend item in pixels.
		Symbol Radius	Here you can define the Symbol border Radius.
		Symbol Padding	Here you can define the distance between the legend items text and legend item symbol.
		Symbol Width	Here you can define the Symbol Width for each legend item in pixels.
	Legend Navigation	Enable Animation	This property allows you to enable the animation of legend items upon navigation. Navigation is applicable only when the legend space is too small for the number of entries.
		Font Family	Set the Font Family for the Legend.
		Font Size	Set the Font Size for the Legend.
		Font Color	Set the Font Color for the Legend.
		Font Style	Set the Font Style for the Legend.
		Active Color	Set the Active Color for the up and down arrows.
		In-Active Color	Set the In-active Color for the up and down arrows.
		Arrow Size	Set the navigation Arrow Size.
Context Menu	Menu Items	Enable Theme Code for Export	This property enables you to set the Theme options available on the Context Menu.
		Font Family	Sets the Font Family for the Context Menu Item.
		Font Size	Sets the Font Size for the Context Menu Item.
		Font Color	Sets the Font Color for the Context Menu Item.
		Font Style	Sets the Font Style for the Context Menu Item.
		Background Color	Sets the Background Color for the Context Menu Item.
		Hover Background Color	Here you can configure the Background Color of the Context Menu Item on hover.
		Hover Text Color	Sets the Text color for the Context Menu Item on mouse over.
		Icon Color	Sets the Icon color for the Context Menu Item.
		Hover Icon Color	Here you can configure the Icon color of the Context Menu Item on hover.
	Buttons	Button Size	Sets the Font size for the Action buttons in pixels.
		Button Color	Sets the Font color for the Action buttons.
		Background Color	Sets the Background color for the Action buttons.
		Horizontal Alignment	This property allows to configure the horizontal alignment of the Action buttons.
		Vertical Alignment	This property allows to configure the vertical alignment of the Action buttons.

Table 4.8: Appearance

Category Scripting¶

The category Scripting provides access to the events of the chart and specific scripting can be added to these events using the script editor.

Property	Description
On Axis Click	This event will be triggered based on the selection of the Axis Name in the Chart.
On Plot Background Click	This event will be triggered when the plot background is clicked.
After Chart Load	This event will be triggered immediately after the chart completes loading.
On Zoom	This event will be triggered upon zooming into the data series.
On Drilldown	This event will be triggered on the Drill Down and is only available for the Drill Down charts.
On Select	This event will be triggered upon selection elements of the data series in the chart.
On Expand	This event will be triggered on an in place expand and is only available for the Drill Down charts.
On Collapse	This event will be triggered on an in place collapse and is only available for the Drill Down charts.

Table 4.9: Scripting

Data Source Requirements for a Line Chart¶

The minimum data source requirement for a Line Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Line Chart or you can decide to plot the complete data set onto the chart.

How to use the Line Chart?¶

In the following steps we will outline how you can setup a new Line Chart in your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Line Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measures Revenue and Cost along 12 months of the dimension Calendar Month.
3. Add a Line Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Line Chart.
5. The Line Chart will plot the information from the assigned data source (see Figure 4.108).

Figure 4.108: Line Chart

Figure 4.108 shows the basic Line Chart for two measures. You can use now the Additional Properties to customize the layout and look and feel.

Option for Runtime Deviation Bar in Column Bar Chart¶

In the Additional Properties of the Column Bar Chart in the category Appearance and the sub category Chart, you have the option to activate the property Enable Deviation Bar to display the Deviation Value between one Column Bar and the other Column Bar. The deviation will be represented through a thin line bar showing the positive deviation in green color and the negative deviation in red color.

For our example, you can follow the steps below to configure the Deviation Bar in the Column Bar Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measure Order Quantity along the dimension Item Category.
3. Add a Column Bar Chart from the VBX Charts to your SAP BusinessObjects/SAP Lumira Designer.
4. Assign the data source to the Column Bar Chart.
5. Navigate to the Additional Properties of the Column Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Appearance and to the sub category Chart (see Figure 4.110).
8. Activate the option Enable Deviation Bar (see Figure 4.110).

Figure 4.110: Enable Deviation Bar

9. Based on the above configured settings, you will be able to visualize the Column Bar Chart enabled with Deviation Bar (see Figure 4.111). In our example, you can observe that a positive Deviation Order Quantity value of 93104 occurs for the dimension Movies in comparison with the dimension Books. The deviation will be calculated as Mouse Hover Column Bar Value Minus (-) Selected Column Bar Value. In our example, the Mouse Hover Column Bar takes the Dimension “Movies” and the Selected Column Bar takes the Dimension “Books”.

Figure 4.111: Column Bar Chart with Runtime Deviation Bar

10. Now navigate to the category Appearance and to the sub category Chart (see Figure 4.112).
11. Activate the option Deviation as % (see Figure 4.112).

Figure 4.112: Enable Deviation as %

12. Based on the above configured settings, you will be able to visualize the Column Bar Chart enabled with the option Deviation as % (see Figure 4.113). In our example, you can observe that a positive Deviation Order Quantity value of 48.74% occurs for the dimension Movies in comparison with the dimension Books. The deviation will be calculated as Mouse Hover Column Bar Value Minus (-) Selected Column Bar Value Divide (/) by Selected Column Bar Value x 100. In our example, the Mouse Hover Column Bar takes the Dimension “Movies” and the Selected Column Bar takes the Dimension “Books”.

Figure 4.113: Column Bar Chart with Runtime Deviation Bar in %

Deviation as %

The option Deviation as % will be only functional when the option Enable Deviation Bar is enabled in the Additional Properties of the Column Bar Chart.

Option to enable Pareto Series in Column Bar Chart¶

In the Additional Properties of the Column Bar Chart in the category Appearance and the sub category Chart, you have the option to activate the property Enable Pareto Series to display both Column bars and a Line where individual values are represented in descending order by column bars, and the cumulative total is represented by the line.

The Column Bar Chart with Pareto Series is useful for figuring out the most significant factors in your data and how they contribute to the entire set. Also, you can discover the areas for improvement from the Pareto Series. For our example, you can follow the steps below to configure the Pareto Series in the Column Bar Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measure Number of Mobile Phone Returns along the dimension Return Reasons.
3. Add a Column Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Column Bar Chart.
5. Navigate to the Additional Properties of the Column Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Appearance and to the sub category Chart (see Figure 4.114).
8. Activate the option Enable Pareto Series (see Figure 4.114).

Figure 4.114: Enable Pareto Series

Based on the above configured settings, you will be able to visualize the Column Bar Chart enabled with Pareto Series (see Figure 4.115). In our example, you can observe the following:

• The Pareto line starts at the center of the Defect category and intersects the right vertical axis at 40 percent, meaning Defects account for 40 percent of all Mobile Phone returns.
• Moving along the Pareto line, the next stop is the center of Incorrect Pricing. The Pareto line at Incorrect Pricing intersects the contributing percentage axis at 70 percent, which means that the combination of Defects and Incorrect Pricing account for 70 percent of all Mobile Phone returns.
• One more category over, Wrong Product intersects the Pareto axis a little bit above 80 percent, which means 80 percent of all Mobile Phone returns are a result of Defects, Incorrect Pricing and Wrong Product.

Figure 4.115: Column Bar Chart with Pareto Series

Now you can discover the areas for improvement where the Mobile Phone Store should allocate its efforts. Targeting improvements to Defects and Incorrect Pricing are more worthwhile than adjusting the prices (Expensive) or Quality of Mobile Phones (Poor Quality).

Data Source Requirements for a Column / Bar Chart¶

The minimum data source requirement for a Column / Bar Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Column / Bar Chart or you can decide to plot the complete data set onto the chart.

How to use the Column / Bar Chart?¶

In the following steps we will outline how you can setup a new Bar Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Column / Bar Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measures Revenue and Cost along a set of members of dimension Product.
3. Add a Column / Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Column / Bar Chart.
5. Navigate to the Additional Properties of the Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Appearance and to the sub category Chart (see Figure 4.116).

Figure 4.116: Additional Properties

8. In the area General Settings set the property Select Chart Type to the option Bar.
9. The Column / Bar Chart will plot the information from the assigned data source (see Figure 4.117).

Figure 4.117: Sample Bar Chart

You can now customize the display of the chart using the available settings in the Additional Properties.

Data Source Requirements for a Combination Chart¶

The minimum data source requirement for a Combination Chart are at least one dimension and two measures. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Combination Chart or you can decide to plot the complete data set onto the chart.

How to use the Combination Chart?¶

In the following steps we will outline how you can setup a new Combination Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Combination Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows three measures: Revenue, Cost, and Profit along a set of members of dimension Product.
3. Add a Combination Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Combination Chart.
5. Navigate to the Additional Properties of the Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Data and to the sub category Data Series (see Figure 4.123).

Figure 4.123: Category Data

8. In the area Series Type you are presented with the option to choose the Series Type for each of the data series from the assigned data source. You can choose between the following options:
   • Column
   • Column Stacked
   • Line
   • Spline
   • Area
   • Area Stacked
   • Area Spline
   • Area Spline Stacked
9. For our example we will configure measure Revenue as Column, measure Cost as Column, and measure Profit as a Line (see Figure 4.124).

Figure 4.124: Combination Chart

Number of Axis

Please note, that the Combination Chart is using a single Axis to plot the different data series values. In case you prefer to use two or more Axis we recommend to use the Dual Axis or the Multiple Axis chart.

Data Source Requirements for an Area Chart¶

The minimum data source requirement for an Area Chart are at least one dimension and one measure. In case the data source does contain more information, you can leverage the Data Utility tool to specify which information is to be used by the Area chart or you can decide to plot the complete data set onto the chart. In case the data source contains more than a single measure, the order of the measures in the initial view of the data source then decides the order of plotting the measure onto the chart.

How to use the Area Chart?¶

In the following steps we will outline how you can setup a new Area Chart in your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Area Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measures Revenue and Cost along 12 months of dimension Calendar Month.
3. Add an Area Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the chart.
5. After the data source has been assigned, the chart plots the members of the dimension for the X-Axis and the measure values are plotted as area (see Figure 4.126).

Figure 4.126: Sample Area Chart

6. The area between the axis and the line is filled with the selected color based on the configuration in the category Data for each of the Data Series.
7. Navigate to the category Appearance and to the sub category Chart in the Additional Properties of the chart.
8. Using the property Select Chart Type you can choose between:
   • Area: This is a classic vertical Area chart with the value axis (Y-Axis) being on the vertical axis.
   • Area Horizontal: This is a horizontal Area chart with the value axis (X-Axis) being on the horizontal axis.
   • Area Spline: The Area Spline chart uses a smoothed line (spline) with the values axis (Y-Axis) on the vertical axis.
   • Area Spline Horizontal: The Area Spline Horizontal chart uses a smoothed line (spline) with the values axis (X-Axis) on the horizontal axis.
9. You can enable Markers and customize the display of the Markers in the area Marker of the category Data. You can customize the Marker Symbol, Size, and Color.

Order of Display

In case you are planning to visualize multiple measures in an Area Chart, please note that the first measure in the data source will be the measure being displayed first and any additional measure will be displayed in front of the first measure. The display order of the measures is (assuming measures are organized in columns) from left to right.

Data Source Requirements for an Column / Bar Drilldown Chart¶

The minimum data source requirement for a Column / Bar Drilldown Chart are at least two dimensions and one measure or an active hierarchy and one measure. In case the data source does contain more information, you can leverage the Data Utility tool to specify which information is to be used by the Column / Bar Drilldown chart or you can decide to plot the complete data set onto the chart.

How to use the Column / Bar Drilldown Chart?¶

In the following steps we will outline how you can setup a new Column / Bar Drilldown Chart in your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Area Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source has a dimension Year and a dimension Month as well as a set of measures.
3. Add a Column / Bar Drilldown Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the chart.
5. After the data source has been assigned, the chart will use the first dimension for the initial view and second dimension for the first drill down.

Figure 4.129: Sample Drill Down Chart

6. Navigate to the Additional Properties of the chart.
7. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
8. Navigate to the category Data and to the sub category Drill Down.
9. In the area General Settings and in the area Hierarchy Drill Down you have several options to configure the Drill Down behavior. You can find the details in Table 4.5.
10. For our example we will activate the following options
    • Show Parent Nodes on Drill Down
    • Show all Measures
    • Activate Hierarchical Labeling
11. For all other options we will use the default values, which means that you will be able to use a drill down with a double-click and the inplace Expand / Collapse option with a single-click.
12. Now use the menu Application • Execute Locally to see the chart and use the Drilldown.
13. Your initial view of the chart should look similar to Figure 4.129 and you should be able to use a double-click for a Drilldown and a single click for an inplace Expand / Collapse.

Hierarchical Drill Down

Please note, that there is no need to expand the hierarchy in the initial view of the data source and that there is no limit in number of levels that can be used as part of a hierarchical drill down.

Data Source Requirements for a Radar Chart¶

The minimum data source requirement for a Radar Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Radar Chart.

You can use the following set of rules for the data structure for a Radar Chart:

• Each Dimension or Measure placed into the Rows of the Initial View of the Data Source will be used for the outer Axis of the Radar chart.
• Each Dimension or Measure placed into the Columns of the Initial View of the Data source will be used as a data series represented in form of a line in the Radar Chart.

How to use the Radar Chart?¶

In the following steps we will outline how you can setup a new Radar Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Radar Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measures Net Value, Cost, and Profit in the Rows of the Initial View and dimension Product in the Columns of the Initial View.
3. Add a Radar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Radar Chart.
5. Navigate to the Additional Properties of the Radar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Appearance and to the sub category Chart (see Figure 4.134).

Figure 4.134: Category Appearance

8. In the area General Settings set the property Select Chart Type to the value Radar.

Figure 4.135: Radar Chart

9. Your Radar Chart should now look similar to Figure 4.135.

Data Source Requirements for a Polar Chart¶

The minimum data source requirement for a Polar Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Radar Chart.

You can use the following set of rules for the data structure for a Polar Chart:

• Each Dimension or Measure placed into the Rows of the Initial View of the Data Source will be used for the outer Axis of the Polar chart.
• Each Dimension or Measure placed into the Columns of the Initial View of the Data source will be used as a data series represented in form of a line in the Polar Chart.

How to use the Polar Chart?¶

In the following steps we will outline how you can setup a new Polar Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Radar Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measures Net Value, Cost, and Profit in the Rows of the Initial View and dimension Product in the Columns of the Initial View.
3. Add a Polar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Polar Chart.
5. Navigate to the Additional Properties of the Polar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Appearance and to the sub category Chart.
8. In the area General Settings set the property Select Chart Type to the value Polar and you can visualize the Polar Chart in circular shape instead of a typical radar style shape (see Figure 4.136).

Data Source Requirements for a Slope Chart¶

The mandatory data source requirement for a Slope Chart are two dimensions and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Slope Chart.

How to use the Slope Chart?¶

In the following steps we will outline how you can setup a new Slope Chart in your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows one measure – Order Quantity and two Dimensions – Calendar Year and Item Category.
3. Add a Slope Chart from the VBX Charts to your SAP BusinessObjects Design Studio /SAP Lumira Designer project.
4. Assign the data source to the Slope Chart.
5. The Slope Chart will plot the information from the assigned data source (see Figure 4.138).

Figure 4.138: Slope Chart

Figure 4.138 shows the basic Slope Chart for one measure and two dimensions. Here you can observe that the measure Order Quantity for the dimension members Electronics, Music and Movies gets decreased from the calendar year 2007 to 2009 and at the same time, the measure Order Quantity for the dimension member Books gets increased from the calendar year 2007 to 2009.

Data Source Requirements for a Advanced Column / Bar Chart¶

The minimum data source requirement for a Advanced Column / Bar Chart are at least one dimension and two measures to form a minimum of two Data Series where the Chart can be configured only for two series. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Advanced Column / Bar Chart.

How to use the Advanced Column / Bar Chart?¶

In the following steps we will outline how you can setup a new Advanced Column Bar Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Advanced Column / Bar Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows the measures Order Cost, Order Amount and Order Quantity along a set of members of dimension Item Category.
3. Add a Advanced Column / Bar Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Advanced Column / Bar Chart.
5. Navigate to the Additional Properties of the Advanced Column / Bar Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Data and to the sub category Data Series (see Figure 4.140).

Figure 4.140: Category Data – Series Options

8. In the area Series Options, you can change the color for the series. For our example, set the Series Order Cost to the color Orange.
9. Set the Series Order Amount to the color Blue.
10. Since the Chart considers only the first two data series in the Columns of the Initial View you will be able to set the colors for the first two data series Order Cost and Order Amount.
11. By default, the Series Positive and Negative will have Green and Red colors. You can also change their colors based on your choice.
12. Now navigate to the area Series Name Change (see Figure 4.141)

Figure 4.141: Category Data – Series Name Change

13. Set the Series Order Cost to the name Order Cost.
14. Set the Series Order Amount to the name Order Amount.
15. Set the property ∆PY to the name Var (restricted to 5 characters).
16. Set the property ∆PY% to the name Var% (restricted to 5 characters).
17. Now navigate to the area Shape Options (see Figure 4.142).

Figure 4.142: Category Data – Shape Options

18. Set the property Deviation Shape to the option Square. The other options are Diamond and Circle.
19. Set the property Deviation Shape Color to the color Black.
20. Navigate to the category Appearance and to the subcategory Chart (see Figure 4.143).

Figure 4.143: Category Appearance

21. Set the property Set the Chart Type to the option Column.
22. Based on the above configuration, you will be able to view the Advanced Column Bar Chart (see Figure 4.144). Here you can observe that there are three layers where the bottom layer 1 represents the Column Bar Chart for the first two data series Order Cost and Order Amount against the dimension Item Category. In this case, you can observe that the column bar chart gets displayed based on the comparison of the two data series taken as measures. Also, the data label gets displayed for the data series having higher value. The middle layer 2 shows the vertical column bars representing the Variance value for the first two data series Order Cost and Order Amount calculated as Series 2 value (Order Amount) – Series 1 value (Order Cost). The positive variance value will be denoted in green color vertical bars and the negative variance value will be denoted in red color vertical bars (see Figure 4.144). The top layer 3 shows the thin vertical column bars with deviation shapes at its top. Here the Variance % value for the first two data series Order Cost and Order Amount is calculated as Series 2 value (Order Amount) – Series 1 value (Order Cost) /Series 1 value (Order Cost) X 100. The positive variance percentage value will be denoted in green color vertical bars and the negative variance percentage value will be denoted in red color vertical bars (see Figure 4.144).

Figure 4.144: Advanced Column Bar Chart

Chart Type Selections for Advanced Column Bar Chart¶

In the additional properties of the Advanced Column Bar Chart in the category Appearance and the subcategory Chart, you have different Chart Type options that can be configured for the Advanced Column Bar Chart. The options are Column, Column-Pin, Column-Stacked, Column-Deviation, Bar, Bar-Pin, Bar-Stacked, Bar-Deviation and Line.

For our first example, set the property Set the Chart Type to the option Column-Pin (see Figure 4.145).

Figure 4.145: Category Appearance

Based on the above configuration, you will be able to view the Advanced Column Bar Chart configured as Column-Pin chart type (see Figure 4.146). You can observe that bottom layer is configured with Column-Pin chart type having the Primary Measure as Order Cost and Secondary Measure as Order Amount.

Figure 4.146: Column-Pin Chart Type

Here you can also change the Primary and Secondary Measure shapes for the Column Pin chart type by navigating to the category Data and to the subcategory Data Series (see Figure 4.147).

Figure 4.147: Category Data – Shape Options

For our second example, navigate to the category Appearance and to the subcategory Chart and set the property Set the Chart Type to the option Column-Deviation (see Figure 4.148).

Figure 4.148: Category Appearance

Based on the above configuration, you will be able to view the Advanced Column Bar Chart configured as Column-Deviation chart type (see Figure 4.149). You can observe that bottom layer is configured with Column-Deviation chart type. Here the secondary measure Order Amount is viewed as Column Bar Charts and the primary measure Order Cost will be represented as the positive deviation bar in green color that occurs inside the Column Bar Chart and the negative deviation bar in red color that occurs on the top of the Column Bar Chart. You can also configure with different chart types to view the Advanced Column Bar Chart.

Figure 4.149: Column-Deviation Chart Type

Category Data¶

The category Data in the Additional Properties allows you to customize settings in regard to topics such as Data Labels, Error Bar, Markers, and other data relevant configurations.

Sub category	Area	Property	Description
Data Series	Marker	Apply Marker Customization	This property allows you to enable / disable the Marker Customization for the Chart.
		Marker Color identical to Data Series	This property sets the same color to the Markers as the Data Series
		Marker Symbol	Enables you to choose a Marker Symbol. The available types of symbols are Circle, Diamond, Square, Triangle, Triangle Down and Custom Marker.
		Marker Size	Allows you to set a size for the marker.
		Marker Color	Allows you to choose a color for the marker.
		Show On Hover	Allows you to enable the hover option on the marker.
	Series Options	Positive	This property allows you to select the color for the data series which represents the positive variance value. By default the color will be green. This property is applicable for Advanced Column Bar Chart.
		Negative	This property allows you to select the color for the data series which represents the neagative variance value. By default the color will be red. This property is applicable for Advanced Column Bar Chart.
	Series Name Change	∆PY	This property allows you to change the Series Name for the Variance value and it is restricted to five letters. This property is applicable for Advanced Column Bar Chart.
		∆PY%	This property allows you to change the Series Name for the Variance Percentage value and it is restricted to five letters. This property is applicable for Advanced Column Bar Chart.
	Shape Options	Deviation Shape	This property allows you to set the Deviation shape on the top of the thin vertical bars in the top most layer representing the Variance Percentage value. The options are Square, Circle and Diamond. This property is applicable for Advanced Column Bar Chart.
		Deviation Shape Color	This property allows you to set the color for the Deviation Shape. This property is applicable for Advanced Column Bar Chart.
		Primary Measure Shape	This property allows you to set the shape for the Primary Measure when the chart type is selected as Column-Pin or Bar-Pin. The options are Square, Circle and Diamond. This property is applicable for Advanced Column Bar Chart.
		Secondary Measure Shape	This property allows you to set the shape for the Secondary Measure when the chart type is selected as Column-Pin or Bar-Pin. The options are Square, Circle and Diamond. This property is applicable for Advanced Column Bar Chart.
		Number of Decimals	This property allows you to set the number of decimals for the Varaiance Series. This property is applicable for Advanced Column Bar Chart.
Drill Down	General Settings	Show all Measures	You can use this property to enable / disable the showing of all measures in a Drilldown. In case this option is disabled, then the drill down will only show the measure that was clicked.
		Show Totals	This property allows you to show / hide totals for the chart itself. The totals will only be shown on the first view of the charts, but will not be shown on the next drill down levels.
		Total Node Placement	This property allows you to decide if the Total node should be placed before or after the members of the drill down.
		Show Parent Nodes on Drilldown	In case this property is activated, then the parent node will be included in the Drill Down chart in addition to the members from the next level.
		Parent Node Placement	This property allows you to decide if the parent node totals should be placed before or after the members of the drill down.
		Enable Scroll Bar	This option allows you to enable / disable the scroll bar.
		Scrollable Chart Width/Height	Sets the Width/Height of the Chart greater than the Container Width/Height.
		On Click	Using the On Click property you can specify which functionality should be used when you click on an element of the data series in the chart. The available options are: Drilldown, Expand / Collapse, Select, None.
		On Double Click	Using the On Double-Click property you can specify which functionality should be used when you double-click on an element of the data series in the chart. The available options are: Drilldown, Expand / Collapse, Select, None.
		On CTRL	Using the On CTRL-Click property you can specify which functionality should be used when you press the CTRL Key and clicks on an element of the data series in the chart. The available options are: Drilldown, Expand / Collapse, Select, None.
	Hierarchy Drill Down	Enable Hierarchy Drill Down	This option allows you to enable / disable a Drill Down based on an active hierarchy in the data source.
		Include Root Level Nodes	Using this property you can include or exclude the root level nodes of an active hierarchy into the Drill Down chart. This option only impacts Drill Down charts using a hierarchy.
		Max. no. of Hierarchy Levels	Using this option you can define a maximum for a Drilldown chart using hierarchies. By specifying the maximum number of hierarchy levels you can limit the data volume, which you will be able to retrieve using the drilldown chart.
		Activate Hierarchical Labeling	Using this property you can activate a specific labeling which will visualize the hierarchical nature of the data and keep the labels on the X-Axis (for example with a column chart) grouped together based on the drill down.

Table 4.12: Data

Category Appearance¶

Sub category	Area	Property	Description
Chart	General Settings	Set the Chart Type	This property allows you to set the Chart Type for the Advanced Column Bar Chart. The options are Column, Column-Pin, Column-Stacked, Column-Deviatio n, Bar, Bar-Pin, Bar-Stacked, Bar-Deviation and Line. This property is applicable for Advanced Column Bar Chart.
		Enable Pareto Series	This property sets the Pareto Series in the Column Bar Chart to display both Column bars and a Line where individual values are represented in descending order by column bars, and the cumulative total is represented by the line.
	Drill Down	Drill Down Data Label Cursor	This property sets the type of the cursor. The options are Default, Pointer, Crosshair and Cell.
		Drill Down Button Horizontal Alignment	This property allows to configure the horizontal alignment of the Drilldown button.
		Drill Down Button Vertical Alignment	This property allows to configure the vertical alignment of the Drilldown button.
		Drilldown button Horizontal Offset	This property allows to specify the Horizontal Offset of the Drilldown button relative to its default alignment.
		Drilldown button Vertical Offset	This property allows to specify the Vertical Offset of the Drilldown button relative to its default alignment.

Table 4.13: Appearance

Data Source Requirements for a Pie Chart¶

The minimum data source requirement for a Pie Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Pie Chart.

How to use the Pie Chart?¶

In the following steps we will outline how you can setup a new Pie Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Pie Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measure Revenue along a set of members of dimension Product.
3. Add a Pie Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Pie Chart.

Figure 4.152: Pie Chart with Data Labels

5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Data Label.
8. Activate the option Enable Data Labels.
9. In the sub category Data Label set the property Display Format to the option Percentage and Value.

Data Source Requirements for a Donut Chart¶

The minimum data source requirement for a Donut Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Donut Chart.

How to use the Donut Chart?¶

In the following steps we will outline how you can setup a new Donut Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Donut Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measure Revenue along a set of members of dimension Product.
3. Add a Donut Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Donut Chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Data Label.
8. Activate the option Enable Data Labels.
9. In the sub category Data Label set the property Display Format to the option Percentage.
10. In the Additional Properties navigate to the category Appearance and to the sub category Chart.
11. In the area General Settings set the option Chart Inner Size to the value 100.

Figure 4.154: Donut Chart

Data Source Requirements for a Semicircle Donut Chart¶

The minimum data source requirement for a Semicircle Donut Chart are at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Semicircle Donut Chart.

How to use the Semicircle Donut Chart?¶

In the following steps we will outline how you can setup a new Semicircle Donut Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Semicircle Donut Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measure Revenue along a set of members of dimension Product.
3. Add a Semicircle Donut Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Semicircle Donut Chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Data Label.
8. Activate the option Enable Data Labels.
9. In the sub category Data Label set the property Display Format to the option Percentage and you will be able to visualize the Semicircle Donut Chart (see Figure 4.156).

Figure 4.156: Semicircle Donut Chart

Data Source Requirements for a Pie Drilldown Chart¶

The minimum data source requirement for a Pie Drilldown Chart are at least two dimensions and one measure. In case the data source does contain additional dimensions or additional measures, you can leverage the Data Utility tool to specify which information is to be used or leverage the complete data set. The Pie Drilldown Chart can only visualize a single measure at a time.

How to use the Pie Drilldown Chart?¶

In the following steps we will outline how you can setup a new Pie Drilldown Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project. We will assume that our data set consists of dimension Product Category, dimension Product, and measure Revenue.

You can follow the steps below to configure the Semicircle Donut Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project.
3. Add a Semicircle Donut Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Semicircle Donut Chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Data Label.
8. Activate the option Enable Data Labels.
9. In the sub category Data Label set the property Display Format to the option Percentage and you will be able to visualize the Pie Drilldown Chart (see Figure 4.157).

Figure 4.157: Pie Drilldown Chart

10. Now use a double-click on any of the slides, and the Pie Chart will get updated with the next level (see Figure 4.158).

Figure 4.158: Pie Drilldown Chart

Figure 4.158 shows the Pie Chart with the next level Drill Down after you have clicked on a slice in the initial view. In regards to the number of Drill Down levels, there is no actual limit on the number of drill downs.

Data Source Requirements for a Spie Chart¶

The minimum data source requirement for a Spie Chart is at least one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Spie Chart.

How to use the Spie Chart?¶

In the following steps we will outline how you can setup a new Spie Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Spie Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows two measures - Order Quantity and Order Cost and two dimensions - Item Category and Item Subcategory.
3. Add a Spie Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Spie Chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Data and to the sub category Data Series (see Figure 4.160).

Figure 4.160: Category Data

8. In the area Chart Settings, set the property Select Measure for Volume to the option Order Quantity.
9. Set the property Select Measure for Radius to the option Order Cost.
10. Navigate to the category Appearance and to the sub category Chart (see Figure 4.161).

Figure 4.161:  Category Appearance

11. In the area General Settings, select Chart Type to the option Pie. The other option is Donut.
12. Based on the above configuration you will be able to view the Spie Chart with the Measure Order Quantity representing the volume of the slice and the Measure Order Cost representing the radius of the slice (see Figure 4.162). You can use now the Additional Properties of the Spie Chart to customize the layout and look and feel.

Figure 4.162: Spie Chart with two dimensions and two measures

Category Data¶

The category Data provides additional properties for the Pie Drilldown Charts as outlined below.

Sub category	Area	Property	Description
Drill Down	General Settings	Show Totals	This property allows you to show / hide totals for the chart itself. The totals will only be shown on the first view of the charts, but will not be shown on the next drill down levels.
		Total Node Placement	This property allows you to decide if the Total node should be placed before or after the members of the drill down.
		Show Parent Nodes on Drilldown	In case this property is activated, then the parent node will be included in the Drill Down chart in addition to the members from the next level.
		Parent Node Placement	This property allows you to decide if the parent node totals should be placed before or after the members of the drill down.
		On Click	Using the On Click property you can specify which functionality should be used when you click on an element of the data series in the chart. The available options are: Drilldown, Expand / Collapse, Select, None.
		On Double Click	Using the On Double-Click property you can specify which functionality should be used when you double-click on an element of the data series in the chart. The available options are: Drilldown, Expand / Collapse, Select, None.
		On CTRL	Using the On CTRL-Click property you can specify which functionality should be used when you press the CTRL Key and clicks on an element of the data series in the chart. The available options are: Drilldown, Expand / Collapse, Select, None.
	Hierarchy Drill Down	Enable Hierarchy Drill Down	This option allows you to enable / disable a Drill Down based on an active hierarchy in the data source.
		Include Root Level Nodes	Using this property you can include or exclude the root level nodes of an active hierarchy into the Drill Down chart. This option only impacts Drill Down charts using a hierarchy.
		Max. no. of Hierarchy Levels	Using this option you can define a maximum for a Drilldown chart using hierarchies. By specifying the maximum number of hierarchy levels you can limit the data volume, which you will be able to retrieve using the drilldown chart.

Table 4.15: Data

Category Appearance¶

Sub category	Area	Property	Description
Chart	General Settings	Chart Outer Size	This property allows you to set the outer diameter of the chart.
		Slice Offset	This property allows you to configure the Offset by which a selected slice moves out from the center of the chart.
		Start Angle	This property allows you to define the angle in the pie chart for the first value.
	Drill Down	Drill Down Data Label Cursor	This property sets the type of the cursor. The options are Default, Pointer, Crosshair and Cell.
		Drill Down Button Horizontal Alignment	This property allows to configure the horizontal alignment of the Drilldown button.
		Drill Down Button Vertical Alignment	This property allows to configure the vertical alignment of the Drilldown button.
		Drilldown button Horizontal Offset	This property allows to specify the Horizontal Offset of the Drilldown button relative to its default alignment.
		Drilldown button Vertical Offset	This property allows to specify the Vertical Offset of the Drilldown button relative to its default alignment.
	3D	Depth	This property allows you the set the Depth for the chart.
		Y-Rotation	Set the angle of rotation of the chart with reference to the Y-Axis.
		X-Rotation	Set the angle of rotation of the chart with reference to the X-Axis.
Data Label		Distance	This property allows you to configure the Distance between the Data Label and the chart.
		Display Format	Here you can configure the Display Format for the value as part of the Data Label. The available options are: Percentage, Value, Value and Percentage.

Table 4.16: Appearance

Data Source Requirements for a Stacked Column Chart¶

The minimum data source requirement for a Stacked Column Chart are at least one dimensions and one measure. In case the data source does contain additional dimensions or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the chart or use the complete data set as part of the visualization. A Stacked Column Chart can stack either the values by a dimension or stack measure values, which depends on the data source assigned to the chart.

Figure 4.165: Simple Stacked Chart

Figure 4.165 shows a Stacked Column Chart with one dimension and two measures. In this scenario the dimension is being used for the X-Axis of the chart and the two measures are being stacked.

Figure 4.166: Stacked Chart

Figure 4.166 shows another Stacked Column Chart, in this example we have one dimension Month in the Rows, one Dimension Product in the Columns, and a measure Costs in the Columns.

You can use the following set of rules for the data structure for a Stacked Column Chart:

• Each Dimension placed into the Rows of the Initial View of the Data Source will be used for the X-Axis of the chart.
• Each Dimension placed into the Columns of the Initial View of the Data source will be used for the stacking of the chart.

How to use the Stacked Column Chart?¶

In the following steps we will outline how you can setup a new Stacked Column Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project. For our example we will assume that we have a data source with two dimensions – dimension Month and dimension Product – as well as one measures – Revenue. In the initial View of the data source we placed the dimension Month into the Rows, dimension Product is placed into the columns, and measure Revenue is placed into the Columns.

You can follow the steps below to configure the Stacked Column Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measures Revenue and along dimension Month and Product.
3. Add a Stacked Column Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart.
8. In the area General Settings set the Select Chart Type to the value Stacked Column (see Figure 4.167).

Figure 4.167: Category Appearance

9. Navigate to the category Appearance and to the sub category Data Label.
10. Activate the option Enable Data Labels.
11. In the sub category Data Label activate the property Data Labels in Percent and you will be able to visualize the Stacked Column Chart (see Figure 4.168).

Figure 4.168: Stacked Column Chart

Figure 4.168 shows the result of our example with the values of dimension Month showing on the X-Axis and the members of dimension Product are used to stack up the values of the measure.

Data Source Requirements for a Stacked Percentage Column Chart¶

The minimum data source requirement for a Stacked Percentage Column Chart are at least one dimension and one measure. In case the data source does contain additional dimensions or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the chart or use the complete data set as part of the visualization. A Stacked Percentage Column Chart can stack either the values by a dimension or stack measure values, which depends on the data source assigned to the chart.

You can use the following set of rules for the data structure for a Stacked Percentage Column Chart:

• Each Dimension placed into the Rows of the Initial View of the Data Source will be used for the X-Axis of the chart.
• Each Dimension placed into the Columns of the Initial View of the Data source will be used for the stacking of the chart.

How to use the Stacked Percentage Column Chart?¶

In the following steps we will outline how you can setup a new Stacked Column Percentage Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project. For our example we will assume that we have a data source with two dimensions – dimension Month and dimension Product – as well as one measure – Revenue. In the initial View of the data source we placed the dimension Month into the Rows, dimension Product is placed into the columns, and measure Revenue is placed into the Columns.

You can follow the steps below to configure the Stacked Percentage Column Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measures Revenue along dimension Month and Product.
3. Add a Stacked Column Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart.
8. In the area General Settings set the Select Chart Type to the value Stacked Percentage Column and you will be able to visualize the Stacked Percentage Column Chart (see Figure 4.169).

Data Source Requirements for a Stacked and Grouped Colum Chart¶

The minimum data source requirement for a Stacked and Grouped Colum Chart are at least one dimension in the Rows, one dimension in the Columns, and one measure in the initial view of the data source. In case the data source does contain additional dimensions or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the chart or use the complete data set as part of the visualization.

You can use the following set of rules for the data structure for a Stacked and Grouped Column Chart:

• Each Dimension placed into the Rows of the Initial View of the Data Source will be used for the X-Axis of the chart.
• Each dimension placed into the Columns of the Initial View of the Data Source will be used to stack items inside each group.
• Measures will be used to group items together.

How to use the Stacked and Grouped Colum Chart?¶

In the following steps we will outline how you can setup a new Stacked and Grouped Colum Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project. For our example we will assume that we have a data source with dimension Month in the Rows, dimension Product Category in the Columns, and dimension Product Group as second dimension in the Columns as well as measure Net Value in the Columns.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project.
3. Add a Stacked and Grouped Column Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the chart.
5. Navigate to the Additional Properties of the chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart.
8. In the area General Settings set the Select Chart Type to the value Stacked Grouped Column and you will be able to visualize the Stacked and Grouped Column Chart (see Figure 4.171).

Figure 4.171: Stacked and Grouped Column Chart

Figure 4.171 shows dimension Month along the X-Axis, dimensions Item Category and Item Sub category are being used to stack items inside each group and measure Order Cost is being used to group items together.

Data Source Requirements for a Stream Graph¶

The minimum data source requirement for a Stream Graph is one dimension and one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Stream Graph.

How to use the Stream Graph?¶

In the following steps we will outline how you can setup a new Stream Graph in your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Stream Graph:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows four measures – Order Cost, Discount Amount, Order Quantity and Order Amount and two Dimensions – Item Category and Item Subcategory.
3. Add a Stream Graph from the VBX Charts to your SAP BusinessObjects Design Studio /SAP Lumira Designer project.
4. Assign the data source to the Stream Graph.
5. The Stream Graph will plot the information from the assigned data source (see Figure 4.173).

Figure 4.173: Stream Graph

Figure 4.173 shows the basic Stream Graph for four measures and two dimensions. Here you can observe that the Measure Order Cost for the Dimension Item Subcategory Computers is 1,585,319 where the value is shown through the central baseline instead of plotting values against the axes. You can use now the Additional Properties to customize the layout and look and feel.

Data Source Requirements for a Solid Gauge¶

The minimum data source requirement for a Solid Gauge is to define a Data Cell Selection, meaning to assign a single cell value to the Solid Gauge.

How to use the Solid Gauge?¶

In the following steps we will outline how you can setup a new Solid Gauge as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Solid Gauge:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measure Revenue along dimension Product.
3. Add a Solid Gauge from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Solid Gauge.
5. Navigate to the Standard Properties of the Solid Gauge.
6. In case the Standard Properties are not shown, use the menu View • Standard Properties to activate the display of the Standard Properties (see Figure 4.176).

Figure 4.176: Standard Properties

7. Select the property Data Selection.
8. Use the button on the right hand side to open the Data Selection dialog.
9. In the next dialog you have the option to select a single cell from the overall data set (see Figure 4.177).

Figure 4.177: Data Selection

10. Select a single cell.
11. Click OK to close the dialog.

Your Gauge should now show the assigned value as part of the value axis.

Data Source Requirements for a Angular Gauge¶

The minimum data source requirement for an Angular Gauge is to define a Data Cell Selection, meaning to assign a single cell value to the Angular Gauge.

How to use the Angular Gauge?¶

In the following steps we will outline how you can setup a new Angular Gauge as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Solid Gauge:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measure Revenue along dimension Product.
3. Add an Angular Gauge from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Angular Gauge.
5. Navigate to the Standard Properties of the Angular Gauge.
6. In case the Standard Properties are not shown, use the menu View • Standard Properties to activate the display of the Standard Properties (see Figure 4.176).
7. Select the property Data Selection.
8. Use the button on the right hand side to open the Data Selection dialog.
9. In the next dialog you have the option to select a single cell from the overall data set (see Figure 4.177).
10. Select a single cell.
11. Click OK to close the dialog.
12. After assigning the single cell to the Gauge you should now be able to see the assigned value on the value axis.

Data Source Requirements for an Advanced Gauge¶

The minimum data source requirement for an Advanced Gauge is to define a Data Cell Selection, meaning to assign a single cell value to the Advanced Gauge for each value you would like to display as part of the gauge.

How to use the Advanced Gauge?¶

In the following steps we will outline how you can setup a new Advanced Gauge as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Advanced Gauge:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows one measure - Sales Amount - and one dimension Product.
3. Add an Advanced Gauge from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Advanced Gauge.
5. Navigate to the Additional Properties of the Advanced Gauge.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Data and to the sub category Data Series and to the area Data Value in the Additional Properties of the Advanced Gauge. For our example, set the property Number of Data Values to the option Double, so that we can assign two values to the gauge (see Figure 4.179).
8. Now for Data Value 1, enter the name for the property Data Series Name (see Figure 4.179) which would be displayed along with the selected data value in the form of a tool tip for the dial.
9. The property Data Value Type has two types Static and Dynamic. For our example, set the property Data Value type to the option Dynamic.
10. When the property Data Value Type is selected as “dynamic”, you have the option to select a single cell for each data value from the overall data set. Click the button to set the value for Data Value 1.

Figure 4.179: Category Data – Data Value 1

11. Once clicked, the Select Data dialog opens and you can select the measure for Data Value 1 (see Figure 4.180)

Figure 4.180: Data Selection for Data Value 1

12. Click OK to close the Select Data dialog.
13. Now the dynamic data value is selected for Data Value 1 (see Figure 4.181).

Figure 4.181: Category Data – Data Value 1

14. Now for Data Value 2, enter the name for the property Data Series Name (see Figure 4.182).
15. The property Data Value Type has two types Static and Dynamic. For our example, set the property Data Value type to the option Dynamic.
16. When the property Data Value Type is selected as “dynamic”, you have the option to select a single cell for each data value from the overall data set. Click the button to set the value for Data Value 2.

Figure 4.182: Category Data – Data Value 2

17. Once clicked, the Select Data dialog opens and you can select the measure for Data Value 2 (see Figure 4.183)

Figure 4.183: Data Selection for Data Value 2

18. Click OK to close the Select Data dialog.
19. Now the dynamic data value is selected for Data Value 2 (see Figure 4.184).

Figure 4.184: Category Data – Data Value 2

20. Navigate to the category Data and to the sub category Data Series in the Additional Properties of the Advanced Gauge. In the area Maximum and Minimum you can configure the Maximum and Minimum values for the scale displaying Data Value 1 (see Figure 4.185)

Figure 4.185: Category Data – Min and Max Values for Data Value 1

21. For Maximum Value 1, set the property Value Type to the option Static (see Figure 4.186).
22. Set the property Maximum Value to 100.
23. For Minimum Value 1, set the property Value Type to the option Static.
24. Set the property Minimum Value to 0.
25. Similarly, you can configure the Maximum and Minimum values for Data Value 2.

Figure 4.186: Category Data – Min and Max Values for Data Value 2

26. For Maximum Value 2, set the property Value Type to the option Static.
27. Set the property Maximum Value to 100.
28. For Minimum Value 2, set the property Value Type to the option Static.
29. Set the property Minimum Value to 0.
30. Navigate to the category Data and to the sub category Data Series in the Additional Properties of the Advanced Gauge. In the area Trend Point, you can also configure the Trend Point option. In addition to visualizing the value for Data Value 1 and Data Value 2 you have the option to show a third value as an indication of a Trend. Trend point is an element that is used to show a target value on the gauge (see Figure 4.187).

Figure 4.187: Category Data – Trend Point

31. Ensure the option Enable Trend Point is activated.
32. Set the property Data Value Type to the option Static.
33. Set the property Trend Point Value to 25.
34. Set the property Trend Point Color.
35. Navigate to the category General and to the sub category Value Axis 1 in the Additional Properties of the Advanced Gauge. In the area Ticks you can configure the values for the Tick (see Figure 4.188).

Figure 4.188: Category General  – Ticks

36. Set the property Major Tick Interval to the value 5.
37. Set the property Major Tick Position to the option Inside.
38. Set the property Major Tick Color to black.
39. Set the property Major Tick Length to the value 10.
40. Set the property Major Tick Width to the value 1.
41. Set the property Minor Tick Interval to the value 2.
42. Set the property Minor Tick Position to the option Inside.
43. Set the property Minor Tick Color to blue.
44. Set the property Minor Tick Length to the value 2.
45. Set the property Minor Tick Width to the value 2.
46. Navigate to the category Appearance and to the sub category Chart in the Additional Properties of the Advanced Gauge (see Figure 4.189).

Figure 4.189: Category Appearance  – Ranges and Colors

47. In the area Plot Area, the property plot bands provide the option to define the value type, range and color for the Plot Bands. The options for the value types are Static, Dynamic and Percentage. For our example, for Plot Band 1, set the property Type to the option Percentage for Range 1.
48. Set the property From to the value 0 for Range 1.
49. Set the property To to the value 40 for Range 1.
50. Set the property Color to Red for Range 1.
51. Set the property Type to the option Percentage for Range 2.
52. Set the property From to the value 40 for Range 2.
53. Set the property To to the value 80 for Range 2.
54. Set the property Color to Yellow for Range 2.
55. Set the property Type to the option Percentage for Range 3.
56. Set the property From to the value 80 for Range 3.
57. Set the property To to the value 100 for Range 3.
58. Set the property Color to Green for Range 3.
59. For the Plot Band 2, set the property Type to the option Percentage for Range 1.
60. Set the property From to the value 0 for Range 1.
61. Set the property “To” to the value 40 for Range 1.
62. Set the property Color to Red for Range 1.
63. Set the property Type to the option Percentage for Range 2.
64. Set the property From to the value 40 for Range 2.
65. Set the property “To” to the value 80 for Range 2.
66. Set the property Color to Yellow for Range 2.
67. Set the property Type to the option Percentage for Range 3.
68. Set the property From to the value 80 for Range 3.
69. Set the property “To” to the value 100 for Range 3.
70. Set the property Color to Green for Range 3.
71. Click the save button to save the properties for the two Plot Bands.
72. Navigate to the category Data and to the sub category Conditional Formatting in the Additional Properties of the Advanced Gauge. You can configure the conditional formatting for the advanced gauge (see Figure 4.190). Now click on Create Rule.

Figure 4.190: Category Data  – Conditional Formatting

73. Enter a Name for your rule into the field Rule Name.
74. Set the property Rule Type to the option Target Value.
75. Set the property Target Selection to the option Data Value.
76. Set the property Target Data Value to the option Primary.
77. Set the property Comparison Value Type to the option Static.
78. Set the property Comparison Value to 100.
79. Based on the Comparison Value 100, set the color to Red for the range having percentage value from 10 to 20.
80. Based on the Comparison Value 100, set the color to Orange for the range having percentage value from 20 to 40.
81. Based on the Comparison Value 100, set the color to Green for the range having percentage value from 40 to 60.
82. Save the Rule 1 settings for the Conditional Formatting.
83. In our example, since the measure for Data Value 1 points to 59.14, the range with Green color having percentage value from 40 to 60 will be applicable and the dial pointing the value 59.14 will be represented in a Green color.
84. Similarly, you can configure the different properties from the different categories in the Additional Properties of Advanced Gauge.
85. You will be able to view the Advanced Gauge based on the configured properties (see Figure 4.191).

Figure 4.191: Advanced Gauge

In the last section, we have outlined on how you can setup a new Advanced Gauge as part of your SAP BusinessObjects Design Studio/SAP Lumira Designer project. In the next section, we will outline on how you can setup a new Linear Gauge as part of your SAP BusinessObjects Design Studio/SAP Lumira Designer project.

Data Source Requirements for a Linear Gauge¶

The minimum data source requirement for an Linear Gauge is to define a Data Cell Selection, meaning to assign a single cell value to the Linear Gauge for each value you would like to display as part of the gauge.

How to use the Linear Gauge?¶

In the following steps we will outline how you can setup a new Linear Gauge as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Linear Gauge:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows one measure - Sales Amount - and one dimension Product.
3. Add a Linear Gauge from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Linear Gauge.
5. Navigate to the Additional Properties of the Linear Gauge.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Data and to the sub category Data Series and to the area Data Value in the Additional Properties of the Linear Gauge. For our example, set the property Number of Data Values to the option Double, so that we can assign two values to the gauge (see Figure 4.192).
8. Now for Data Value 1, enter the name for the property Data Series Name which would be displayed along with the selected data value in the form of a tool tip for the dial.
9. The property Data Value Type has two types Static and Dynamic. For our example, set the property Data Value type to the option Dynamic.
10. When the property Data Value Type is selected as “dynamic”, you have the option to select a single cell for each data value from the overall data set. Click the button for the property Dynamic Data Value to select the value for Data Value 1.

Figure 4.192: Category Data – Data Value 1

11. Once clicked, the Select Data dialog opens and you can select the measure for Data Value 1 (see Figure 4.193)

Figure 4.193: Data Selection for Data Value 1

12. Click OK to close the Select Data dialog.
13. Now the dynamic data value is selected for Data Value 1 (see Figure 4.194).

Figure 4.194: Category Data – Data Value 1

14. Now for Data Value 2, enter the name for the property Data Series Name (see Figure 4.195)
15. The property Data Value Type has two types Static and Dynamic. For our example, set the property Data Value type to the option Dynamic.
16. When the property Data Value Type is selected as “dynamic”, you have the option to select a single cell for each data value from the overall data set. Click the button for the property Dynamic Data Value to select the Data Value 2.

Figure 4.195: Category Data – Data Value 2

17. Once clicked, the Select Data dialog opens and you can select the measure for Data Value 2 (see Figure 4.196)

Figure 4.196: Data Selection for Data Value 2

18. Click OK to close the Select Data dialog.
19. Now the dynamic data value is selected for Data Value 2 (see Figure 4.197).

Figure 4.197: Category Data – Data Value 2

20. Navigate to the category Data and to the sub category Data Series in the Additional Properties of the Linear Gauge. In the area Maximum and Minimum you can configure the Maximum and Minimum values for the scale displaying Data Value 1 (see Figure 4.198).

Figure 4.198: Category Data – Min and Max Values for Data Value 1

21. For Maximum Value 1, set the property Value Type to the option Static.
22. Set the property Maximum Value to 100.
23. For Minimum Value 1, set the property Value Type to the option Static.
24. Set the property Minimum Value to 0.
25. Navigate to the category Data and to the sub category Data Series in the Additional Properties of the Linear Gauge. In the area Trend Point, you can also configure the Trend Point option. In addition to visualizing the value for Data Value 1 and Data Value 2 you have the option to show a third value as an indication of a Trend. Trend point is an element that is used to show a target value on the gauge (see Figure 4.199).

Figure 4.199: Category Data – Trend Point

26. Ensure the option Enable Trend Point is activated.
27. Set the property Data Value Type to the option Static.
28. Set the property Trend Point Value to 25.
29. Set the property Trend Point Color.
30. Navigate to the category General and to the sub category Value Axis 1 in the Additional Properties of the Linear Gauge. In the area Ticks you can configure the values for the Tick (see Figure 4.200).

Figure 4.200: Category General – Ticks

31. Set the property Major Tick Interval to the value 5.
32. Set the property Major Tick Position to the option Inside.
33. Set the property Major Tick Color to black.
34. Set the property Major Tick Length to the value 10.
35. Set the property Major Tick Width to the value 1.
36. Set the property Minor Tick Interval to the value 2.
37. Set the property Minor Tick Position to the option Inside
38. Set the property Minor Tick Color to blue.
39. Set the property Minor Tick Length to the value 2.
40. Set the property Minor Tick Width to the value 2.
41. Navigate to the category Appearance and to the sub category Chart in the Additional Properties of the Linear Gauge (see Figure 4.201).

Figure 4.201: Category Appearance  – Ranges and Colors

42. The property Plot Band provide the option to define the value type, range and color for the Plot Band. The options for the value types are Static, Dynamic and Percentage. For our example, for Plot Band 1, set the property Type to the option Percentage for Range 1.
43. Set the property From to the value 0 for Range 1.
44. Set the property “To” to the value 40 for Range 1.
45. Set the property Color to Red for Range 1.
46. Set the property Type to the option Percentage for Range 2.
47. Set the property From to the value 40 for Range 2.
48. Set the property “To” to the value 80 for Range 2.
49. Set the property Color to Yellow for Range 2.
50. Set the property Type to the option Percentage for Range 3.
51. Set the property From to the value 80 for Range 3.
52. Set the property “To” to the value 100 for Range 3.
53. Set the property Color to Green for Range 3.
54. Click the save button to save the properties for the Plot Band.
55. Navigate to the category Data and to the sub category Conditional Formatting in the Additional Properties for the Linear Gauge. You can configure the conditional formatting for the Linear gauge (see Figure 4.202). Now click on Create Rule.

Figure 4.202: Category Data  – Conditional Formatting

56. Enter a Name for your rule into the field Rule Name.
57. Set the property Rule Type to the option Target Value.
58. Set the property Target Selection to the option Data Value.
59. Set the property Target Data Value to the option Primary.
60. Set the property Comparison Value Type to the option Static.
61. Set the property Comparison Value to 100.
62. Based on the Comparison Value 100, set the color to Red for the range having percentage value from 10 to 20.
63. Based on the Comparison Value 100, set the color to Orange for the range having percentage value from 20 to 40.
64. Based on the Comparison Value 100, set the color to Green for the range having percentage value from 40 to 60.
65. Save the Rule 1 settings for the Conditional Formatting.
66. In our example, since the measure for Data Value 1 points to 59.14, the range with Green color having percentage value from 40 to 60 will be applicable and the dial pointing the value 59.14 will be represented in Green color.
67. Similarly, you can configure the different properties from the different categories in the additional properties of Linear Gauge.
68. You will be able to view the Linear Gauge based on the configured properties (see Figure 4.203).

Figure 4.203: Linear Gauge

Category General¶

Sub category	Area	Property	Description
Value Axis 1	Axis Title	Enable Value Axis Title	This property enables / disables the display of the value Axis Title.
		Title Text	Sets the Title Text for the axis.
		Font Family	Sets the Font Family for the axis title.
		Font Size	Sets the Font Size for the axis title.
		Font Style	Sets the Font Style for the axis title.
		Font Color	Sets the Font Color for the axis title.
		Horizontal Alignment	This property allows you to configure the horizontal alignment for the axis title.
		Vertical Alignment	This property allows you to configure the vertical alignment for the axis title.
		Horizontal Offset	This property allows you to set the horizontal offset of the axis title relative to its default alignment.
		Vertical Offset	This property allows you to set the vertical offset of the axis title relative to its default alignment.
		Label Distance	Sets the Label Distance for the Y-Axis.
		Rotation	Here you can specify a degree value by which the Label will be rotated.
	Axis Label	Enable Axis Label	This property enables / disables the display of the Axis Labels.
		Label Prefix	This property allows to specify a Prefix for the Axis Labels.
		Label Suffix	This property allows to specify a Suffix for the Axis Labels.
		Font Family	Sets the Font Family for the Label.
		Font Size	Sets the Font Size for the Label.
		Font Color	Sets the Font Color for the Label.
		Font Style	Sets the Font Style for the Label.
	Ticks	Major Tick Interval	Sets the Interval for the Major Ticks.
		Major Tick Position	Defines the Major Ticks Position. The available options are Inside and Outside.
		Major Tick Color	Defines the Major Ticks Color.
		Major Tick Length	Defines the Major Ticks Length.
		Major Tick Width	Defines the Major Ticks Width.
		Minor Tick Interval	Sets the Interval for the Minor Ticks.
		Minor Tick Position	Defines the Minor Ticks Position. The available options are Inside and Outside.
		Minor Tick Color	Defines the Minor Ticks Color.
		Minor Tick Length	Defines the Minor Ticks Length.
		Minor Tick Width	Defines the Minor Ticks Width.

Table 4.17: General

Category Data¶

Sub category	Area	Property	Description
Data Series	Data Value	Number of Data Values	Here you can set the number of data values. The options are Single and Double.
		Data Series Name	Here you can set the name for the data series.
		Data Value Type	Here you can set the data value type. The options are Static and Dynamic.
		Static Value	Here you can set the static data value.
		Dynamic Data Value	Here you can set the dynamic data value.
	Maximum and Minimum	Value Type	Here you can set the maximum value type. The types are Static, Dynamic and Measure Aggregation.
		Maximum Value	Here you can enter the Maximum Value for the gauge.
		Minimum Value	Here you can enter the Minimum Value for the gauge.
	Trend Point	Enable Trend Point	Here you can Enable/Disable the Trend Point.
		Data Value Type	Here you can set the data value type. The types are Static and Dynamic.
		Trend Point Value	Here you can set the Trend Point value.
		Trend Point Color	Here you can set the Trend Point color.
Conditional Formatting		Rule Name	Here you can enter a Name for the Alert.
		Rule Type	You can choose between: Single Measure, Measure Calculation, Target Value.
		Target Data Value	Here you can select the Target Data Value. The types are Primary and Secondary measures.
		Comparison Operator	Here you can select the measure which will be compared against the Comparison Value.
		Comparison Value Type	Here you can choose between a Static and a Dynamic comparison value.
		Comparison Value	Depending on the configured options, the property Comparison Value will allow to enter a static value, or setup a dynamic cell selection, or select a dynamic measure.
		Color	Here you can define the color for the Rule.
Number Format		Number Format Definition	Sets the Number Format Definition. The options are Initial View and Custom Number Format
		Show Scaling Unit	Here you can set the scaling unit.
		Scaling Unit Placement	This property allows you to set the Scaling Unit Placement for the Data Label/Tooltip.
		Scaling Unit	This property allows you to set the Scaling Unit for the Data Label/Tooltip.
		Currency/Unit Placement	This property allows you to set the Currency/Unit Placement for the Data Label/Tooltip.
		Scaling Factor	The property allows you to specify a Scaling Factor, which then can be displayed together with the data value for the Data Label/Tooltip.
		Enable Semantic Formatting	This property activates the option for Semantic Formatting for the Data Label/Tooltip.
		Format for Negative Values	This property sets the Format for Negative Values for the Data Label/Tooltip.
		Color for Negative Values	This property sets the Color for Negative Values for the Data Label/Tooltip.
		Format for Positive Values	This property sets the Format for Positive Values for the Data Label/Tooltip.
		Color for Positive Values	This property sets the Color for Positive Values for the Data Label/Tooltip.

Table 4.18: Data

Appearance¶

Sub category	Area	Property	Description
Chart	General Settings Gauge	Start Angle	Here you can set the start angle of the gauge.
		End Angle	Here you can set the end angle of the gauge.
		Fill Gauge	Here you can set the fill color for the gauge.
		Gauge Scale Width	Here you can set the width of the Gauge scale.
		Gauge Size (%)	Here you can set the size of the pane based on percentage level.
		X Position	Here you can set the X position of the pane.
		Y Position	Here you can set the Y position of the pane.
	Plot Band	Type	Here you can set the value type. The types are Static, Dynamic and Percentage.
		From	Here you can set the From value.
		To	Here you can set the To value.
		Color	Here you can set the color for the plot.
	Run Time Selection	Enable Run-Time Selection	Here you can Enable/Disable the run time selection.
		Value Selection	Here you can set the Dial value selection at run time.
Data Label		Enable Data Labels	This property enables / disables the property Data Labels.
		Enable Data Label Outside Gauge	This property enables / disables the property Data Labels outside the Gauge.

Table 4.19: Appearance

Data Source Requirements for a Funnel / Pyramid Chart¶

The minimum data source requirement for a Funnel / Pyramid Chart is a data source with a minimum of one dimension and one measure. In case of the Funnel / Pyramid Drilldown Chart the minimum requirements are to have at least two dimensions and one measure.

How to use the Funnel / Pyramid Chart?¶

In the following steps we will outline how you can setup a new Funnel Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Solid Gauge:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows a measure Revenue along dimension Sales Stage.
3. Add a Funnel Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Funnel Chart.
5. Navigate to the Additional Properties of the Funnel Chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. In the Additional Properties navigate to the category Appearance and to the sub category Chart.
8. In the area General Settings ensure that the property Select Chart Type is set to the value Funnel.

Figure 4.205: Funnel Chart

9. Your Funnel Chart should look similar to Figure 4.205 now.

Data Source Requirements for a Progress Component¶

The minimum data source requirement for any of the Progress Components is a data source with a minimum of one data cell. The progress components will visualize the value of a single cell and therefore you will have to configure a Data Selection in addition to assigning the data source to the component.

How to use the Progress Bar?¶

In the following steps we will outline how you can setup a new Progress Bar, which is one of the Progress Components. The Number Counter and Circular Counter are working very similar and you should be able to follow the steps below with those components as well.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows measure Revenue along dimension Product.
3. Add a Progress Bar from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Progress Bar.
5. Navigate to the Standard Properties of the Progress Bar.
6. In case the Standard Properties are not shown, use the menu View • Standard Properties to activate the display of the Standard Properties (see Figure 4.176).
7. Select the property Data Selection.
8. Use the button on the right hand side to open the Data Selection dialog.
9. In the next dialog you have the option to select a single cell from the overall data set.
10. Select a single cell.
11. Click OK to close the dialog.
12. Your Progress Bar should look similar to Figure 4.207.

Figure 4.207: Progress Bar

Category General¶

Sub category	Area	Property	Description
Chart Titles	Title	Chart Title Text	This property allows to set the Text shown as part of the Circular Counter and Number Counter.

Table 4.21: General

Data¶

Sub category	Area	Property	Description
Data Series	Chart Settings	Maximum Value	Here you can define the Maximum Value for the Progress Bar.
Number Format		No of Decimal places	Here you can define the number of decimal places.
		Thousand Separator	Here you can define the Thousand Separator.
		Decimal Separator	Here you can define the Decimal Separator.
		Prefix	Here you can define the Prefix for the value of the Circular Counter.
		Suffix	Here you can define the Suffix for the value of the Circular Counter.

Table 4.22: Data

Appearance¶

Sub category	Area	Property	Description
Chart	General Settings	Counter Type	This property allows to configure the counter type. The available options are Number Counter and Percentage Counter. This property is available only for the Circular Counter and Number Counter.
		Circle Fill Color	This property allows you to define the color for the filled part of the Circular Counter.
		Circle Track Color	Allows you to define the color for the progress bar.
		Circle Thickness	This property allows you to define the Thickness of the Circular Counter.
	Chart Area	Background Color	This property allows you to define the Background Color for the Circular Counter.
		Plot Background Color	This property allows you to define the Background Color for the inner part of the circle.
	Chart Font	Number Font Family	This property allows you to set the Font Family for the Number Value.
		Number Font Size	This property allows you to set the Font Size for the Number Value.
		Enable Google Font	Here you can enable / disable the option for Google Font.
		Google Font Category	This property allows you to set the Font Category. The options are Serif, Sans serif, Display, Handwriting and Monospace.
		Google Font Family	Here you can select the Global Google Font Type. This option will be enabled only when Enable Google Font is activated.

Table 4.23: Appearance

Data Source Requirements for a Waterfall Chart¶

The minimum data source requirement for a Waterfall Chart are a data source with at least one dimension and one measure. The data source should indicate the positive and negative values. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Line Chart or you can decide to plot the complete data set onto the chart.

How to use the Waterfall Chart?¶

In the following steps we will outline how you can setup a new Waterfall Chart. For our example we will assume that we are going to use a data source with a dimension showing the value type and a measure with the actual value.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows a single measure along a dimension Value Type.
3. Add a Waterfall Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Waterfall Chart.
5. Your initial chart should look similar to Figure 4.209.

Figure 4.209: Waterfall Chart

6. Navigate to the Additional Properties of the Waterfall Chart.
7. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
8. Navigate to the category Data and to the sub category Data Series (see Figure 4.210).

Figure 4.210: Additional Properties

9. In the area Chart Settings you can activate the option of an Intermediate Summary and you can choose after which value the Intermediate Summary will be placed using the property Place Intermediate Sum After.
10. You also have the ability to enable a custom sort option and you can configure elements from the assigned data source as an Interim or Final Balance.
11. For our example we place an Intermediate Summary after the value for the Service Revenue.
12. Our Waterfall Chart looks now like shown in Figure 4.211.

Figure 4.211: Waterfall Chart

Sorting Options for Waterfall Chart¶

By navigating to the category Data and to the sub category Data Series, you can activate the properties Sort By and Enable Custom Sort to enable the sorting options for the Waterfall chart.

Sort By: Using this property in the area Chart Settings, you can sort the dimension members on the X-Axis based on a set of options. The options are Initial View, Dimension Text in Ascending order, Dimension Text in Descending order, Dimension Key in Ascending order, and Dimension Key in Descending order. For our example, we have selected the option Dimension Text in Descending order (see Figure 4.212).

Figure 4.212: Sort By option

Enable Custom Sort: Using this property in the area Chart Settings, you can sort the dimension members on the X-Axis by defining a custom sort order. For our example, we created a custom sort order by swapping the dimension member Audio Equipment in the place of Cameras (see Figure 4.213).

Figure 4.213: Custom Sort

Based on the Custom Sort configuration, the Waterfall Chart will be shown as in Figure 4.214.

Figure 4.214: Custom Sort

Enable Interim / Final Balance from Data Source¶

If you wish to have an existing entry from the data source as an Intermediate Balance/Final Balance, then you can enable the property Enable Interim/Final Balance from the Data Source in the area Chart Settings. For our example, we have selected the existing entry as dimension member “Audio Equipment” and assigned the option as Intermediate Balance for that dimension member (see Figure 4.215).

Figure 4.215: Intermediate Balance Selection

Based on the above configuration, you will be able to visualize the Waterfall Chart as shown in (see Figure 4.216).

Figure 4.216: Intermediate Balance on Dimension Member

Sorting and Hierarchy Drill Down options

The Custom Sorting and Interim/Final Balance options will not function when the Drill Down options for the Waterfall Chart is enabled.

Hierarchy Drill Down options for Waterfall Chart¶

Starting with the release 2.0 of the Visual BI Extensions, you are provided with the following Hierarchy Drill Down options. You can configure the details by navigating to the category Data and to the sub category Drill Down (see Figure 4.217).

Figure 4.217: Hierarchy Drill Down

** Enable Hierarchy Drill Down**: Using this property, you can enable the Hierarchy Drill Down for the Waterfall chart based on the active Hierarchy based on the Initial View of the data source.

Include Root Level Nodes: Using this property you can include or exclude the Root Level Nodes of the active hierarchy.

Max no. of Hierarchy Levels: Using this property, you can specify the maximum number of levels from the hierarchy, which will be available for the Drill Down navigation. By specifying the maximum number of hierarchy levels you can limit the data volume, which you will be able to retrieve using the drilldown option.

Activate Hierarchical Labeling: Using this property you can activate a specific labeling which will visualize the hierarchical nature of the data and keep the labels on the X-Axis grouped together based on the hierarchical structure. For our example the labels of the both Category and Sub category items appear on the X-Axis (see Figure 4.218)

Figure 4.218: Hierarchical Labeling

Enable Drill Down: Using the property Enable Drill Down, you will be able to enable the Drill Down option for the Waterfall Chart. For our example, we have assigned the data set having the dimensions Item Category and Item Subcategory and measure Order Cost. Based on this configuration you will be able to visualize the Waterfall Chart with dimension Item Category with its dimension members for the measure Order Cost (see Figure 4.219). When you double click on any one of the dimension member of the dimension Item Category - for our example “Books” - it gets drilled down to the next level showing the Waterfall Chart with dimension members for the dimension Item Subcategory (see Figure 4.220).

Figure 4.219: Waterfall Chart with Dimension Item Category

Figure 4.220: Waterfall Chart – Drilled Down to Dimension Item Subcategory Subcategory

Enable Hierarchy Drill Down: When the property Hierarchical Drill Down is enabled, then you need to assign a data source having Hierarchy data set and visualize the Waterfall Chart based on the Hierarchy Drill Down configuration. In this scenario you will be able to visualize the Waterfall Chart representing the parent nodes and when you double click on any one element of the parent node, it gets drilled down to the next level showing the Waterfall Chart with the elements of the child node.

Hierarchy Drill Down option

The Hierarchy Drill Down option will only function when the Drill Down option for the Waterfall Chart is enabled.

Category Data¶

Sub category	Area	Property	Description
Data Series	Chart Settings	Enable Final Balance	This property enables the option to show a final balance as part of the chart.
		Place Intermediate Sum After	This property allows you to place an intermediate summary after a selected value of the data series.
		Sort By	This property allows you to set the sorting options. The options are Initial View, Dimension Text in Ascending order, Dimension Text in Descending order, Dimension Key in Ascending order and Dimension Key in Descending order.
		Enable Custom Sort	This property allows you to enable/disable the Custom Sort.
		Enable Interim / Final Balance from Data Source	By enabling this property, you can select the Intermediate Balance or Final Balance options.
Drill Down	Hierarchy Drill Down	Enable Drilldown	Using this property, you can enable/disable the Drill Down option for the Waterfall Chart.

Table 4.25: Data

Data Source Requirements for a Heat Map Chart¶

The minimum data source requirement for a Heat Map Chart are a data source with at least one dimension in the Rows, and one dimension in the Columns of the Initial View of the data source. In addition the data source should contain at least one measure. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Heat Map Chart or you can decide to plot the complete data set onto the chart.

You can use the following set of rules for the data structure for a Heat Map Chart:

• Each Dimension placed into the Rows of the Initial View of the Data Source will be used for the X-Axis of the chart.
• Each Dimension placed into the Columns of the Initial View of the Data source will be used for the Y-Axis of the chart.

How to use the Heat Map Chart?¶

In the following steps we will outline how you can setup a new Heat Map Chart. For our example we will assume that we are going to use a data source with a dimension Month in the Rows, a dimension Product in the Columns, and a measure Profit in the Columns of the Initial View of the data source.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project similar to the description outlined previously.
3. Add a Heat Map Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Heat Map Chart (see Figure 4.222).

Figure 4.222: Heat Map Chart

5. Navigate to the Additional Properties of the Heat Map Chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Data and to the sub category Data Series (see Figure 4.223).

Figure 4.223: Category Data

8. In the area Chart Settings you can use the Minimum Value Color and Maximum Value Color options as well as the Minimum and Maximum Value options to customize the coloring and scaling of the chart.

Category Data¶

Sub category	Area	Property	Description
Data Series	Chart Settings	Minimum Value	Here you can configure the minimum value for the scale of the chart.
		Minimum Color	Here you can configure the color for the minimum value of the chart.
		Maximum Value	Here you can configure the maximum value for the scale of the chart.
		Maximum Color	Here you can configure the color for the maximum value of the chart.

Table 4.26: Data

Data Source Requirements for a Scatter Chart¶

The minimum data source requirement for a Scatter Chart are a data source with at least one dimension in the Rows, and two measures in the Columns. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Scatter Chart or you can decide to plot the complete data set onto the chart.

You can use the following set of rules for the data structure for a Scatter Chart:

• Each Dimension placed into the Rows of the Initial View of the Data Source will be used for the plotted points of the chart.
• The first measure placed in the Columns of the Initial View of the Data Source will be used for the X-Axis.
• The second measure placed in the Columns of the Initial View of the Data Source will be used for the Y-Axis.

How to use the Scatter Chart?¶

In the following steps we will outline how you can setup a new Scatter Chart. For our example we will assume that we are going to use a data source with a dimension Product in the Rows and measure Profit and measure Revenue in the Columns of the Initial View of the data source.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project similar to the description outlined previously.
3. Add a Scatter Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Scatter Chart (see Figure 4.224).
5. Navigate to the Additional Properties of the Scatter Chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Data and to the sub category Data Series (see Figure 4.225).

Figure 4.225: Scatter Chart

8. In the area Series Color you can setup the color as well as the symbol for each of the data series members.

Category General¶

Sub category	Area	Property	Description
X-Axis	General Settings	Cross Value	Here you can specify at which value the X-Axis will cross the X-Axis.
Y-Axis	General Settings	Cross Value	Here you can specify at which value the Y-Axis will cross the Y-Axis.

Table 4.27: General

Data¶

Sub category	Area	Property	Description
Data Series	Chart Settings	Swap Axes	Using this property you can swap the X-Axis and Y-Axis from the chart.
	Series Color	Series Color	In the Series color area you can define the color as well as the symbol for each data series element.

Table 4.28: Data

Data Source Requirements for a Bubble Chart¶

The minimum data source requirement for a Bubble Chart are a data source with at least one dimension in the Rows, and three measures in the Columns. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Bubble Chart or you can decide to plot the complete data set onto the chart.

You can use the following set of rules for the data structure for a Bubble Chart:

• Each Dimension placed into the Rows of the Initial View of the Data Source will be used as a Data Series element and you can assign the different colors in the Additional Properties.
• The first measure placed in the Columns of the Initial View of the Data Source will be used for the X-Axis.
• The second measure placed in the Columns of the Initial View of the Data Source will be used for the Y-Axis.
• The third measure placed in the Columns of the Initial View of the Data Source will be used for the Bubble size.

How to use the Bubble Chart?¶

In the following steps we will outline how you can setup a new Bubble Chart. For our example we will assume that we are going to use a data source with a dimension Product in the Rows and measures Revenue, Cost, and Profit in the Columns of the Initial View of the data source.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project similar to the description outlined previously.
3. Add a Bubble Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Bubble Chart.
5. Navigate to the Additional Properties of the Bubble Chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Data and to the sub category Data Series (see Figure 4.227).

Figure 4.227: Bubble Chart

8. In the area Series Color you can define the color for each data series of the chart.

Category General¶

Sub category	Area	Property	Description
X-Axis	General Settings	Cross Value	Here you can specify at which value the X-Axis will cross the X-Axis.
Y-Axis	General Settings	Cross Value	Here you can specify at which value the Y-Axis will cross the Y-Axis.

Table 4.29: General

Data¶

Sub category	Area	Property	Description
Data Series	Chart Settings	Swap Axes	Using this property you can swap the X-Axis and Y-Axis from the chart.
	Series Color	Series Color	In the Series color area you can define the color as well as the symbol for each data series element.

Table 4.30: Data

Data Source Requirements for a Marimekko Chart¶

The minimum data source requirement for a Marimekko Chart are a data source with at least two dimensions in the Rows, and one measure in the Columns. In case the data source does contain additional dimension or additional measures, you can leverage the Data Utility tool to specify which information is to be used by the Marimekko Chart or you can decide to plot the complete data set onto the chart.

You can use the following set of rules for the data structure for a Marimekko Chart:

• The first Dimension placed into the Rows of the Initial View of the Data Source will be used as Dimension for the X-Axis.
• The second Dimension placed into the Rows of the Initial View of the Data Source will be used as Dimension for the stacking of the values.

How to use the Marimekko Chart?¶

In the following steps we will outline how you can setup a new Marimekko Chart. For our example we will assume that we are going to use a data source with a dimension Month and a dimension Product in the Rows and measures Revenue in the Columns of the Initial View of the data source.

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project similar to the description outlined previously.
3. Add a Marimekko Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Marimekko Chart.

Figure 4.229: Marimekko Chart

5. Navigate to the Additional Properties of the Marimekko Chart.
6. In case the Additional Properties are not shown, use the menu View • Additional Properties to activate the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart (see Figure 4.230).

Figure 4.230: Additional Properties

8. In the area General Settings you can use the Select Chart Type property to setup a Marimekko Standard Chart or a Marimekko Percentage Chart.
9. Now navigate to the category General and to the sub category X-Axis.
10. Scroll down to the area Axis Label (see Figure 4.231).

Figure 4.231: Category General -  X-Axis

11. The property Enable Total Display allows you to display the Total for each data series on the X-Axis as numerical value.
12. The property Display Total in Percentage allows you to display the Total for each data series on the X-Axis as percentage value share of the total value.
13. Navigate to the category Appearance and to the sub category Chart.
14. Scroll down to the area General Settings (see Figure 4.232).

Figure 4.232: Category Appearance

15. The property Visualize Total allows you to activate an extra area next to the Marimekko Chart, which visualizes the Total values for each of the stacked dimension members (see Figure 4.233).

Figure 4.233: Marimekko Chart with Total Values

16. The property Visualize Total in Percent allows you to show the Totals in percentage values based on share.
17. Navigate to the category Data and to the sub category Data Utility (see Figure 4.234).

Figure 4.234: Data Utility

18. In the sub category Data Utility you can choose which dimension will be used for the Width on the X-Axis and which dimension will be used for stacking up the values. In addition you can choose the measure from the underlying data source.

Category Data¶

Sub category	Area	Property	Description
Data Utility		Enable Data Utility Tool	This property enables/disable s the Data Utility Tool option.
		Select X-Axis	Here you can choose which dimension will be used for the Width of the chart on the X-Axis.
		Select Stacking Dimension	Here you can choose which dimension will be used for the stacking the measures of the chart.
		Select Measure(s)	Here you can choose which measure will be used for the chart.

Table 4.31: Data

Appearance¶

Sub category	Area	Property	Description
Chart	General Settings	Visualize Total	This property allows you to enable / disable the display of the total values of the chart in a separate area.
		Visualize Total in Percent	This property allows you to enable / disable the display of the total values of the chart in a separate area using percentage values.

Table 4.32: Appearance

Data Source Requirements for a Tree Map Chart¶

The minimum data source requirement for a Tree Map Chart is a data source with single dimension in the Rows, and two measures in the Columns.

How to use the Tree Map Chart?¶

In the following steps we will outline how you can setup a new Tree Map Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project. You can follow the steps below to configure the Tree Map Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows two measures - Sales Amount and Forecast Amount - and one dimension Product.
3. Add a Tree Map Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Tree Map Chart.
5. Navigate to the Additional Properties of the Tree Map Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart in the Additional Properties of the Tree Map Chart. In the area General Settings you can configure the type of Tree Map Chart using the property Select Chart Type. There are five different types and each type represents a different option to position and size the data:

• Slice and Dice
• Stripes
• Squarified
• Strip
• Horizontal stripes

8. For our example, you can set the property Select Chart Type to the option Slice and Dice (see Figure 4.236)

Figure 4.236: Tree Map Chart – Category Appearance

9. Ensure that the property Enable Redraw is activated, so that the chart will be redrawn when the browser window is being resized at run time.
10. Set the property Dimension Value Display to the option Text Only. This property allows you to choose if the dimension should be displayed with the Key, Text, or both values.
11. Navigate to the category Data and to the sub category Data Series of the Additional Properties for the Tree Map Chart. In the area Chart Settings you can assign the measures from your data source to the Size and Color options for the chart. (see Figure 4.237).

Figure 4.237: Tree Map Chart – Category Data

12. Set the property Select Measure for Size to the measure Forecast Amount.
13. Set the property Minimum Value Color to light blue.
14. Set the property Select Measure for Color to the measure Sales Amount.
15. Set the property Minimum Value Color to dark blue.
16. Set the property Select Type of Color Scheme to the option Min-Max Color which configures the type of color scheme that will be used. The options for the color schemes are listed below

• Min-Max Color
• Series Color
• Custom Color Pallet

17. Navigate to the category Appearance and to the sub category Data Label in the Additional Properties. The Tree Map Chart can use 2 dimensions for which the data labels inside the containers will be shown. As shown in Figure 4.238, you can configure the appearance of the data label for each level individually

Figure 4.238: Tree Map Chart – Category Appearance

18. Set the property Font Size to the value 10.
19. Set the property Font Family to the option Default.
20. Set the property Font Color to black.
21. Set the property Font Style to the option Bold.
22. Set the property Horizontal Alignment to the option Left.
23. Set the property Vertical Alignment to the option Middle.
24. Navigate to the category Appearance and to the sub category Chart (see Figure 4.239).

Figure 4.239: Tree Map Chart – Category Appearance

25. In the area Data Series set the property Border Color to black.
26. Set the property Border Width to the value 1.
27. Set the property Border Style to the option Solid.
28. Similarly, you can configure the different properties from the different categories in the Additional Properties for the Tree Map Chart.
29. Navigate to the menu Application • Save.
30. Select the menu Application • Execute Locally.
31. You will be able to view the Tree Map Chart based on the configured properties (see Figure 4.240).

Figure 4.240: Tree Map Chart

32. The Tree Map Chart can use a maximum of 2 dimensions and we can configure the Labels in regards to the Style for the two different levels (see Figure 4.241).

Figure 4.241: Category Appearance – Data Label

33. Figure 4.242 shows the Tree Map chart configured with 2 levels of labels.

Figure 4.242: Tree Map Chart with two dimensions

Tree Map Capabilities

Please note that in case if you require more than two dimensions being part of the Tree Map Chart we would recommend to take a look at the Tree Map Drill Down Chart (see section 4.14.19).

Category Data¶

Sub category	Area	Property	Description
Data Series	Chart Settings	Select Measure for Size	Here you can set the measure for the Size.
		Minimum Value Color	Sets the Color for the Minimum value.
		Select Measure for Color	Here you can set the measure for the Color.
		Maximum Value Color	Sets the Color for the Maximum value.
		Select Type of Color Scheme	Sets the type of color. The options are Min-Max Color, Series Color and Custom Color Pallet.

Table 4.34: Data

Category Appearance¶

Sub category	Area	Property	Description
Chart	General Settings	Select Chart Type	Here you can set the Chart Type. The options are Slice & Dice, Stripes, Squarified, Strip and Horizontal stripes.
		Dimension Value Display	Sets the Display Dimension Value. The options are Default, Key, Text or both values.
		Allow Data Point Selection	This property allows the series points to be selected.
		Enable Redraw	When activated, the chart will be redrawn when the browser window is being resized.
	Data Series	Border Color	Sets the Border Color for the series.
		Border Width	Sets the Border Width for the series.
		Border Style	Sets the Border Style for the series.
Data Label	Level 1	Font Size	Sets the Font Size of the data label for Level 1.
		Font Family	Sets the Font Family of the data label for Level 1.
		Font Color	Sets the Font Color of the data label for Level 1.
		Font Style	Sets the Font Style of the data label for Level 1.
		Horizontal Alignment	Sets the Horizontal Alignment for Level 1.
		Vertical Alignment	Sets the Vertical Alignment for Level 1.
	Level 2	Font Family	Sets the Font Family of the data label for Level 2.
		Font Size	Sets the Font Size of the data label for Level 2.
		Font Style	Sets the Font Style of the data label for Level 2.
		Font Color	Sets the Font Color of the data label for Level 2.
		Horizontal Alignment	Sets the Horizontal Alignment for Level 2.
		Vertical Alignment	Sets the Vertical Alignment for Level 2.

Table 4.35: Appearance

Data Source Requirements for a Tree Map Chart¶

The minimum data source requirement for a Tree Map Chart is a data source with two dimensions in the Rows, and two measures in the Columns.

How to use the Tree Map Drill Down Chart?¶

We have two different scenarios for the Tree Map Drill Down Chart and they are outlined in the sections below.

Scenario 1:

In Scenario 1, we will outline how you can setup a new Tree Map Drill Down Chart as part of your next SAP BusinessObjects Design Studio/SAP Lumira Designer project.

You can follow the steps below to configure the Tree Map Drill Down Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows two measures - Sales Amount and Forecast Amount - and two dimensions Product Category and Product.
3. Add a Tree Map Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Tree Map Drill Down Chart.
5. Navigate to the Additional Properties of the Tree Map Drill Down Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart in the Additional Properties of the Tree Map Drill Down Chart. In the area General Settings you can configure the type of Tree Map Chart using the property Select Chart Type. There are five different types and each type represents a different option to position and size the data:

• Slice and Dice
• Stripes
• Squarified
• Strip
• Horizontal stripes

For our example, you can set the property Select Chart Type to the option Slice and Dice (see Figure 4.243)

Figure 4.243: Tree Map Drill Down Chart – Category Appearance

8. Ensure that the property Enable Redraw is enabled where the chart can be resized to fit the container when the window is resized at run time.
9. Set the property Dimension Value Display to the option Text Only. This property allows you to choose if the dimension should be displayed with the Key, Text, or both values.
10. Navigate to the category Data and to the sub category Data Series of the Additional Properties for the Tree Map Drill Down Chart. In the area Chart Settings you can assign the measures from your data source to the Size and Color options for the chart. (see Figure 4.244).

Figure 4.244: Tree Map Drill Down Chart – Category Data

11. Set the property Select Measure for Size to the measure Forecast Amount.
12. Set the property Minimum Value Color to light blue.
13. Set the property Select Measure for Color to the measure Sales Amount.
14. Set the property Minimum Value Color to dark blue.
15. Set the property Select Type of Color Scheme to the option Min-Max Color which configures the type of color scheme that will be used. The options for the color schemes are listed below

• Min-Max Color
• Series Color
• Custom Color Pallet

16. Navigate to the category Appearance and to the sub category Data Label in the Additional Properties for the Tree Map Drill Down Chart. In the area Level 1 you can configure the Label styles inside the container (see Figure 4.245)

Figure 4.245: Tree Map Drill Down Chart – Category Appearance

17. Set the property Font Size to the value 10.
18. Set the property Font Family to the option Default.
19. Set the property Font Color to black.
20. Set the property Font Style to the option Bold.
21. Set the property Horizontal Alignment to the option Left.
22. Set the property Vertical Alignment to the option Middle.
23. Navigate to the category Appearance and to the sub category Chart (see Figure 4.246).

Figure 4.246: Tree Map Drill Down Chart – Category Appearance

24. In the area Data Series set the property Border Color to black.
25. Set the property Border Width to the value 1.
26. Set the property Border Style to the option Solid.
27. Navigate to the menu Application • Save.
28. Select the menu Application • Execute Locally.
29. You will be able to view the Tree Map Drill Down Chart based on the configured properties. The Figure 4.247 shows the first dimension being displayed in the chart.

Figure 4.247: Tree Map Chart

30. In Figure 4.248, by clicking the member of the first dimension, in our example Kitchen Appliances, you can view the Tree Map Drill Down Chart with the second dimension.

Figure 4.248: Tree Map Drill Down Chart

Scenario 2:

For the second scenario, we will outline how you can setup a Tree Map Drill Down Chart with a hierarchy and allowing your users to drill down along the hierarchical levels.

You can follow the steps below to configure the Tree Map Drill Down Chart:

1. Create a new project in SAP BusinessObjects Design Studio/SAP Lumira Designer.
2. Add a data source to the project. For our example we will assume that our data source shows two measures - Sales Amount and Forecast Amount - and one dimension Store with an activated hierarchy (see Figure 4.249).

Figure 4.249: Initial View – One Dimension and Two Measures

3. Add a Tree Map Drill Down Chart from the VBX Charts to your SAP BusinessObjects Design Studio/SAP Lumira Designer project.
4. Assign the data source to the Tree Map Drill Down Chart.
5. Navigate to the Additional Properties of the Tree Map Drill Down Chart.
6. In case the Additional Properties are not shown, please use the menu View • Additional Properties to activate the display of the Additional Properties.
7. Navigate to the category Appearance and to the sub category Chart in the Additional Properties of the Tree Map Drill Down Chart where you can configure the types of Tree Map Drill Down Chart. There are five different types and each type represents a different option to position and size the data:

• Slice and Dice
• Stripes
• Squarified
• Strip
• Horizontal stripes

For our example, you can set the property Select Chart Type to the option Slice and Dice (see Figure 4.250)

Figure 4.250: Tree Map Drill Down Chart – Category Appearance

8. Ensure that the property Enable Redraw is activated where the chart can be resized to fit the container when the window is resized at run time.
9. Set the property Dimension Value Display to the option Text Only.
10. Navigate to the category Data and to the sub category Data Series of the Additional Properties for the Tree Map Drill Down Chart. In the area Chart Settings you can assign the measures from your data source to the Size and Color options for the Chart (see Figure 4.251).

Figure 4.251: Tree Map Drill Down Chart – Category Data

11. Navigate to the category Data and to the sub category Drill Down. In the area Hierarchy Drill Down ensure that the property Enable Hierarchy Drill Down is activated which allows the drilldown to happen based on the hierarchy of the dimension.
12. Set the property Select Measure for Size to the measure Forecast Amount.
13. Set the property Minimum Value Color to light blue.
14. Set the property Select Measure for Color to the measure Sales Amount.
15. Set the property Minimum Value Color to dark blue.
16. Set the property Select Type of Color Scheme to the option Min-Max Color which configures the type of color scheme that will be used. The options for the color schemes are listed below

• Min-Max Color
• Series Color
• Custom Color Pallet

17. Navigate to the category Appearance and to the sub category Data Label in the Additional Properties of the Tree Map Drill Down Chart. In the Area Level 1 you can configure the Label styles inside the container (see Figure 4.252)

Figure 4.252: Tree Map Drill Down Chart – Category Appearance

18. Set the property Font Size to the value 10.
19. Set the property Font Family to the option Default.
20. Set the property Font Color to black.
21. Set the property Font Style to the option Bold.
22. Set the property Horizontal Alignment to the option Left.
23. Set the property Vertical Alignment to the option Middle.
24. Navigate to the category Appearance and to the sub category Chart (see Figure 4.253).

Figure 4.253: Tree Map Drill Down Chart – Category Appearance

25. In the area Data Series set the property Border Color to black.
26. Set the property Border Width to the value 1.
27. Set the property Border Style to the option Solid.
28. Navigate to the menu Application • Save.
29. Select the menu Application • Execute Locally.
30. You will be able to view the Tree Map Drill Down Chart with our activated hierarchy. In our example the top level node is shown – US. (see Figure 4.254).

Figure 4.254: Tree Map Chart

31. Using a double-click allows you to drill down and the next level of the hierarchy is shown (see Figure 4.255).

Figure 4.255: Tree Map Drill Down Chart with Dimension Hierarchy levels

The Tree Map Drill Down chart is able to leverage any number of dimensions for the drill down, as well as any number of hierarchical levels.