The Worksheet
The Worksheet is the central element in the Configuration Editor. Here you can add datasources, dimensions, cubes, or caches to your configuration or edit them.
The Worksheet is divided into several parts, each of them can be reached by its tabulator at the top if the Worksheet:
- The datasource editor allows to add datasources (SQL databases) to the configuration and to add additional informations to them, like links between tables. Additionally, there is an ERM diagram which allows to visualize database-tables and to edit the relationships between them.
- The dimension editor is used to add dimensions to your configuration and to define, how they are loaded from the several datasources.
- The access editor allows to restrict access to dimensions or keys with rules.
- The cube editor is used to add cubes to your configuration and to define how they will load their data from datasources and to which dimensions they are connected to.
- In the cache editor you can add caches to your configuration in order to improve its execution time.
- In the formula editor you can define formulas combinations of facts and dimensions which can not be loaded from any datasource and have to be calculated therefore.
- In the include panel you can include other configuration-files and use the dimensions defined in the other configuration in your model.
- The settings panel allows to define some general settings for the model.
- The notes panel allows to write notes into the configuration file. These notes are stored together with the configuration and have no influence to the model at the runtime.
Each of this editors, except the notes panel, is described in the section "Editing configurations". To open one of these editors or panels simply click onto the tabulator at the bottom of the Worksheet.
Some editors need the dimensions defined in the dimension-editor to work, therefore changing to these editors can force the Worksheet to build a temporary model containing all dimensions of the configuration (without its cubes, caches or formulas). Whenever the editor is loading the temporary model, a small message-popup saying "Loading model ..." will appear in the lower right edge of your Workbench. Then you will have to wait until the dimensions are loaded.
If an error occurs while loading the model, the panel you switched to will not open until you fix the error in the dimension-definition. Then change back to the dimension-editor and fix the error.
