In our extensions you can bind settings representing numbers or strings to WebI variables. In order to do so you need to fill the corresponding field with the string $<VARNAME>$. If <VARNAME> in the string is replaced by an existing WebI variable, our extension will use the first value in the variable's data series for the settings. To use the variables it's necessary to pass them to the extension (charts, tables, bubbles) during the data allocating process. The following examples will show you the variables' applications within the graphomate extensions.

Example 1 - charts - Setting Multihighlights with Variable Number of Elements in a Series

In this example the multihighlight is to always be set from the first element to the last in a series. The result should look like this:

Procedure

1) Define a type 'number' and name 'measure' variable which reads the number of elements in a series. Definiton of variable <MH_countElements>:

=Count([Year]) in report

2) Add a graphomate chart to your WebI report. While allocating data, remember to set the variable <MH_countElements> as 'Measurements variables'.

3) After the graphomate chart was rendered in the report navigate through the chart settings via the context menu to Format Custom Element / Helper / Highlight. Activate the 'Multi' Highlight Mode and enter <MH_countElements> in 'Multi Highlights Definitions'. Pay attention to the string's spelling.

1.1-1.$MH_countElements$

Input Control Elements can control the visibility of elements in a series. The variables' content will be adjusted correspondingly.

Example 2 - charts - Creating Sums with a Series

This example shows how to use the graphomate chart's sum function on a series. The result should look like this:

Procedure

1) The first step is to create the variable <V_empty> of type 'Text' and the qualificationn 'Dimension' defined as follows:

=""

2) Add a graphomate chart to your WebI report. Make sure to add <V_empty> first to 'Category Axis' while assigning data.

3) In order to display the sum, in this case 'Quantity sold' with 'Lines', the property 'Calculate Sums' needs to be activated. You can find it in the Format Custom Element Menue under Display / Display.

Example 3 - charts - Generating the Title-Element including the current year

This example illustrates how to set the date automatically in the chart title. The result looks like this

Procedure

1) The first step is to create the variable <V_titleYear> of type 'Number' and the qualificationn 'Dimension' defined as follows:

=Year(CurrentDate())

2) Add a graphomate chart to your WebI report. Make sure to add <V_titleYear> to 'Dimensions variables' while assigning data.

3) In order to display the current year in the title, you need to set the Title within the properties of the Format Custom Element Menue under Labels / Labels.

Browser not supported