Building Reports Using Foresight Excel Add-In > Building Report Using Add-In > Working with Report from Repository > Working with Analytical Queries (OLAP)

Working with Analytical Queries (OLAP)

The mode is used to work with data obtained from the following data sources:

All types of cubes.
Time series databases.
Express reports.
Files in the *.ppexpress, *.ppcube formats.

Working with the add-in in the analytical queries mode includes the following steps:

If required, change and set up a data source.

If required, set up dimension view and select dimension elements.

Set up a data table.

If required, add and set up chart.

If required, add and set up bubble chart.

If required, add and set up bubble tree.

If required, add and set up tree map.

If it is required, add single values or dimension elements from cubes to the cells on the workbook sheet.

If required, refresh data.

If required, set up report title.

If required, export report.

If required, execute batch operations.

Save report or its copy.

See also:

Working with Report from Repository