Table Visualizer

To create a table visualizer, use the Document group of tabs on side panel:

1. Add a data source to the Sources tab:

• Click the button. Select the Add Source item in the drop-down menu. A standard dialog box for selecting repository objects opens. Select the required data source.

• Select data source on the Repository panel and drag it to the Sources tab.

• Select the Add Source context menu item of free area on the Sources tab.

2. Add a data source slice. To do this, select the Add Slice context menu item for the added source on the Sources tab.

3. Add data area. To do this:

• Select the Add Data Area context menu item for the added slice on the Sources tab. In this case the left top corner of analytical data area matches the active cell.

• Drag the added slice to the required report sheet cell from the Sources tab.

NOTE. To simultaneously add a source, slice and table, drag and drop the data source to regular report sheet:
       •   From the Source tab of the Document group of tabs on the side panel.
       •   From the Repository panel.

The table visualizer is added to the regular report sheet.

Regular reports enable the user to set up general parameters of data table  as an object on the sheet.

A data table provides the following settings to change table appearance:

• Cell size autofit.

• Changing table zoom.

• Displaying dimension names in table corner.

• Displaying table layout.

• Formatting of table and its elements.

• Table rotation.

• Table elements layout.

• Displaying table footnotes.

The following operations are available when working with table data:

• Data drill down and drill up.

• Editing and saving data.

• Searching and replacing data.

• Sorting.

• Excluding data from table.

• Filtering.

• Selecting data for building visualizers.

The following operations are available when working with table hyperlinks:

• Showing and hiding table hyperlinks.

• Actions on opening hyperlink.

The following operations are available when working with table dimensions:

• Selecting dimension elements in table.

• Setting up table metrics.

• Dimension elements layout.

• Fixing dimension elements in table.

The following actions are available when working with the dimension elements in table:

• Editing Selection from Table.

• Selecting Dimension Elements in Table.

• Dimension Elements Layout.

• Dimension Elements Detailing.

• Formatting Dimensions and Levels in Table.

• Setting Up Table Metrics.

• Fixing Dimension Elements in Table.

• Special Dimension Filtering.

• Calculated Elements.

Data analysis is available in a table with the following means:

• Data validation.

• Growth indicator.

• Data transformation.

• Data ranking.

• Distribution.

• Sparklines.

• Summary statistics.

• Conditional formatting.

A table enables the user to apply advanced analytics:

• Econometrics.

• Data validation.

• Data mining.

The following settings are available on calculating totals in table:

• Displaying totals.

• Totals calculation parameters.

• Formatting of data and totals headers.

• Hiding totals.