instantOLAP Online documentation 2.2.7 - The preview panel

The preview panel

While editing a query, you can perform a preview of its result at any time without leaving the editor.

Performing a preview

The preview tabulator below the worksheet

In order to switch from the design mode (when the worksheet is visible) into the preview mode, you must use the "Preview" tabulator underneath the worksheet. After switching to the preview, the query will be executed immediately which is indicated by a progress-bar.

The progress-bar

After the server successfully processed the query, the result will be displayed in the preview window.

Previewing a query in the Workbench

Click to enlarge

If the query and the model used by it are error-free, you will see the preview of the query after its execution. Otherwise, an error message will be displayed inside the preview window.

Leaving the preview

The "Edit" tabulator below the worksheet

In order to return to the worksheet, you must use the "Edit" tabulator (left of the "Preview" tabulator).

Restrictions of the preview

The preview does not offer not all features of the later HTML view or PDF export. These are the main restrictions:

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Structure of a query
Starting the editor
Structure of the editor
The Model-Explorer
The Property-Editor
The Toolbars
The preview panel
Editing queries
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Expressions
Formats
SQL-Expressions