The Ad Hoc Editor shows some minor differences when working with OLAP-based views. For example, only Chart and Crosstab are available in the view type menu, and you can only use full data. The Data Selection panel shows a special icon for dimensions. Some options are different: for example, you can add levels to a dimension using the context menu. For information about OLAP-based crosstabs, see the Jaspersoft OLAP User Guide and Jaspersoft OLAP Ultimate Guide.
The following figure illustrates the canvas when displaying an OLAP-based crosstab in the Ad Hoc Editor:
Ad Hoc Editor’s OLAP-based Crosstab Layout |
Component | Description |
Column Groups | Drag dimensions and measures from the Data Selection panel to this area to create column groups. |
Row Groups | Drag dimensions and measures from the Data Selection panel to this area to create row groups. |
Available Dimensions | Displays all the dimensions defined in the current OLAP cube. Drag them to the Columns and Rows areas to add them to the crosstab. |
Available Measures | Displays all the measures defined in the current OLAP cube. Drag them to the Columns or Rows areas to add them to the crosstab. |
Measure Labels | Displays the label of each measure in the crosstab. |
Dimensions | Displays the levels that have been added to the crosstab from each dimension. Note that dimensions can be added as both rows and columns. |
Measures | Displays the measures that have been added to the crosstab. Note that measures can be added as either rows or columns. |
Columns | Displays dimensions and measures as columns. |
Rows | Displays dimensions and measures as rows. |
Recommended Comments
There are no comments to display.