The pivot table element defines a table element with fixed roles and types for its
columns. Grouping, sorting and summarizing allows results to be displayed in different
ways.
What are pivot tables?
The pivot table element is a table element with fixed roles and types for its columns, suitable for processing multi-dimensional data. Grouping, sorting, and summarizing are performed. The results can be displayed in different ways.
Sample pivot table reports
Two sample pivot table reports are provided with the installation of Genero Studio. One report shows a static pivot table, while the other shows a dynamic pivot table.
Pivot table properties
When you define a pivot table, you set properties specific to the pivot table.
Arrange your hierarchies
In order to minimize the volume of the data stream, the HIERACHIES can be shipped sparsely, in the sense that not all hierarchy values need to be shipped for every row.
Add a dimension
Dimensions are the values against which aggregation occurs.
Add a measure
Measures are placed under a Fact in the Structure View.