instantOLAP Online documentation 2.6.1 - The Configuration explorer

The Configuration explorer

The Configuration-Explorer is located at the upper left corner of the Workbench. With this explorer you can investigate the datasources used by the configuration with all their tables, columns and other elements offered by the data sources.

Also, the explorer is the most important source for developing configuration using drag&drop. All elements of the databases can be dragged out of the explorer into the configuration with the mouse. You can drag elements onto the worksheet or onto the properties, which are displayed in the Property-Editor.

The Explorer is displayed as a tree-view (comparable with the File-Explorer from Microsoft Windows). Some elements can contain sub-elements, which can be opened (and closed) by clicking on the plus symbol to the left of the elements.

The Model-Explorer uses the same location as the Repository-Explorers. You can switch back and forth between the explorer with the tabulators below the panel.

Exploring the calendar

The calendar is always the topmost element in the Explorer. It offers the most frequently used date patterns which you can use when you create a time dimension.

The calendar is no real datasource, it always exists in the Explorer and no datasource has to be connected to see it.

Exploring databases

In the explorer you will also see all databases for which connections in your configuration exist.

If you open a database in the explorer, all of its tables (or a subset of the tables, if you defined a table filter) will be displayed as sub elements.

If you open a table, you will see all columns of the tables and all its table expressions (which are "virtual columns" defined in the configuration).

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Starting the Config-Editor
Structure of the Config-Editor
The Worksheet
The Configuration explorer
The Property-Editor
The toolbar
The SQL-query tool
Editing configurations
Concepts
Query properties
Chart properties
Configuration properties
Expressions
Formats
SQL-Expressions