Inserting and Setting Up Visualizers

To create a visualizer, use:

• Commands of the drop-down menu of the Visualizers button on the Home ribbon tab.

• Buttons from the Visualizers group on the Insert ribbon tab.

• Commands of the New Block item in the container element or dashboard's context menu.

After a visualizer has been created, set its data source.

Use the Data Sources tab on the side panel to select a visualizer data source.

To control data source parameters, use the Data Source Parameters tab on the side panel.

To manage data source structure, use the Data Source Structure tab in the Structure and Parameters dialog box.

To manage visualizer parameters, use the Manage Parameters tab in the Structure and Parameters dialog box.

To manage data displayed in the visualizer, use the Selection group of tabs on the side panel.

Aggregation enables the user to execute multiple selection of fixed dimensions elements by means of the selected aggregation method.

NOTE. Aggregation of fixed dimensions is not available if global cache is used.

To aggregate fixed dimensions:

1. Select a visualizer by clicking the left mouse button on it.

NOTE. Aggregation is only used for the selected visualizer.

2. Go to the Data tab from the Data side panel group.

3. Select required aggregation method in the Aggregate Fixed Dimensions drop-down list:

• None. Data is not aggregated.

• Sum. The summation is executed by selected elements in fixed dimensions

• Maximum. The maximum value is displayed from selected elements in fixed dimensions

• Minimum. The minimum value is displayed from selected elements in fixed dimensions

• From Source Dimensions. Fixed dimension data is handled with the aggregation method specified in settings of data source.

When working with ADOMD cubes, the aggregation specified in the corresponding ADOMD sources is used.

• From Source Facts. In fixed dimensions with full selection, server aggregation server aggregation is used according to the methods specified for source facts is set up for data source. Source facts aggregation should be set up if a data source contains several records for one set which should be aggregated.

If the Aggregate Selected Elements Onlycheckbox is selected in cube dimension aggregation settings, and on the Facts Binding page the aggregation method is selected for facts, aggregation is calculated on server by selected elements according to the methods specified for cube facts. When single selection is used for parent element, aggregation is executed only for its child elements. If only parent element is selected without child elements, data is not aggregated into it. If the checkbox is deselected, aggregation in multiple selection is executed by the whole dimension regardless of the selection. When single selection is used for parent element, aggregation is executed for its child elements.

If the ODBC data source is selected as a table, in th standard cube wizard for this data source one can calculate client aggregation.

• Average. The average value is displayed by selected elements in fixed dimensions.

NOTE. When selecting any item in the list, except for None, the Select All Fixed button becomes active, when clicking on it, all items in fixed dimensions will be selected.

NOTE. The option is available for all visualizers, except for the Table type.

To view source data, by which a visualizer is built, change visualizer type to Table. A table with source data is displayed.

It is available to select the source data table area, by which a visualizer is built. Click the Visualizer Data button on the Data ribbon tab to select data area that is used to build a visualizer. The following menu appears:

• Entire Table. A visualizer is built by the entire source data table.

• Selected Area. A visualizer is built by the area selected in the source data table.
  Features of building visualizers by the selected area:

• If one cell or corner is selected in the source data table, a visualizer is built by the entire data table.

• If several cell ranges are selected in the source data table by means of the CTRL key, the selection joined by rows and columns by all selected ranges is sent to the visualizer.

Use the following to filter and transform the data displayed in a visualizer:

• The Data tab on the side panel.

• The Data ribbon tab.

Dimension synchronization enables the user to control element selection in a number of dashboard blocks at a time.

Use the Dimension Synchronization tab on the side panel to set up block dimension synchronization.

NOTE. Viewing and setup of the title are available if a data source is specified for the visualizer.

To display the title, select the Title checkbox in the visualizer's context menu. The Title checkbox is deselected by default, and the title is not displayed.

To set up structure of the title, use the Title tab on the side panel.

To set up formatting of the title, use the Title ribbon tab.

To change visualizer type, use the Visualizer Type command in the visualizer's context menu. In the menu that opens select the required visualizer type.

The visualizer is rebuilt in accordance with the selected type, settings of dimension selection, filtering, sorting and other user settings will be saved.

NOTE. The option is available for the Map, Bubble Chart, Bubble Tree, Tree Map, Indicator visualizers if in calendar dimension several elements are selected.

Animation shows dynamics of observation objects by the selected metrics over a certain period of time. A timeline shown in the lower part of the visualizer is used to work with animation.

Click the button to start the animation. During the animation process, fill and other parameters depending on the visualizer type, are changed.

Click the button to stop the animation.

Use the buttons to move along the timeline.

NOTE. The option is available for all visualizers except for the Table type.

To display the data, based on which a visualizer is built:

1. Display object control buttons:

2. Click the button.

Visualizer source data will be displayed.