Editing queries
This section describes how to work with queries and how to create, edit or delete of individual elements.
Queries can be saved at any time using the menu-item "Save" or "Save as" (in the Workbench) or using the "Save" or "Save as" buttons from the toolbar.
Unless you save a query, the current changes are only visible for you and not for other users.
There is generally the same number of possible operations for nearly each element: You can create, move, delete or select most elements and change their property-values.
The only exception is the worksheet, since this can't be created, moved or deleted because the worksheet represents the query itself. But you can edit the properties of the worksheet (and thus the properties of query).
For each element-type its most important properties are described here.
Usually you can use the mouse to create new elements, e.g. with drag&drop out of the Model-Explorer, using a context-menu or button or by copying existing elements.
This section describes how to create new elements for all types of query-elements.
All elements except the worksheet can be positioned (with certain restrictions) freely. This section describes how to move elements for each type.
Each createable element can also be deleted. The only exception is the worksheet itself.
All elements of a query (including the worksheet) can be selected in order to change their properties in the Property-Editor. Selected elements are displayed with a blue border.
The properties of the currently selected element can be edited in the Property-Editor in order to change its behaviour and appearance.
Nearly all properties of all elements are formulas and are computed at the time of the report execution. Though you also may use simple constants in properties (e.g. if you want to set a background color to a certain and independent value), you must code this value in the correct syntax for instantOLAP-formulas.
Nearly all properties of all elements are controlled by formulas. Therefore you must use the correct syntax for instantOLAP-formulas - also for constant values. Otherwise the system will show an error message.
E.g. the syntax for a constant blue color would be "'blue'" or "'#0000FF", in each case enclosed into simple delimiters. These delimiters mark a constant string in an expression.
Read the "instantOLAP reference" for a detailed description of formulas and their syntax.
Contents of this chapter:
Editing the worksheet
Editing selectors
Editing outer blocks
Editing inner blocks
Editing pivot-tables
Editing comments
