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.

• On the Repository panel select the data source 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 a 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.

To add a data source, a slice and a table at the same time, drag the data source to a regular report sheet:

• From to the Sources tab in the Document group of tabs on the side panel.

• From the Repository panel.

To create a table visualizer via a ribbon, on the Insert tab in the Data Areas group click the Data Area button and in the drop-down list select a slice.

The table visualizer is added to the regular report sheet.

Regular reports enable the user to set up general parameters of 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 creating 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 of dimensions and levels in table.

• Setting up table metrics.

• Fixing dimension elements in table.

• Dimension special 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.

To explain data in a table cells, attachments can be linked as files or URLs.