Structure of a query
Before you create your own reports, you should get familiar with the structure of a query, the query elements and their functions. This section gives you a detailed overview of the structure and the elements of queries.
Within a query there are fixed elements (which exactly occur once) and variable elements, which you can use as much as desired (or leave them out).
The fixed elements are the title and the selector area. These elements appear in each query, even if you did not specify any title or selector. The title and the selector are always placed in the topmost position.
The variable elements are the blocks (there are inner and outer blocks, which are encapsulated into each other) with pivot tables and comments. You can use as much as wanted of this elements and set their order freely.
Structure of a report
Inner blocks are always placed within outer blocks and pivot tables are always placed within inner blocks, so that the pivot tables of a report are organized in a table-like structure. On the highest level of a query, only outer blocks and comments are allowed.
The order of the outer blocks and the comments can be defined freely. Also, you can define the order of the inner blocks within an outer block at will.
Contents of this chapter:
The worksheet
Selectors
Outer blocks
Inner blocks
Pivot-tables
Comments
Filters and subcubes
