The tool supports interface of Foresight Analytics Platform 9 or earlier.

Selecting Visualizer for Displaying Data

Analytical queries (OLAP) enable the user to quickly create reports allowing to analyze arbitrary data dimensions by means of visualizers.

The following visualizers are available:

Aggregation of Fixed Dimensions

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 data visualizer.

NOTE. Aggregation is used for all visualizers built on one source.

  1. Go to the Data tab from the Source side panel group.

  2. Select the required aggregation method from the Aggregate Fixed Dimensions drop-down list:

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

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 fact table, in the standard cube wizard for this data source one can calculate client aggregation.

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.

Data Visualizers Layout

Select the data layout mode in the drop-down list:

Available modes of data visualizers layout:

On tabs

Vertically

Horizontally

Selecting Visualizer

A visualizer is selected using the group of buttons in the top right part of the working area.

Depending on the selected data layout option, this button group for selecting a visualizer can look differently:

Showing or Hiding Visualizer

To show or hide visualizer, press or release the button corresponding to the visualizers in the Working Area group on the View ribbon tab:

NOTE. It is impossible to hide all visualizers, at least one visualizer is displayed.

See also:

Data Visualizers| Selecting Data for Building Visualization