Grouping dimensions in a table
O3 Browser supports the grouping of dimensions, placing more than one dimension on the same analysis axis, either as columns or rows.
In order to add a dimension to one of the axes of the table, we must select it in the Dimensions Bar and take it to the desired position, keeping the mouse left button pressed.
O3 Browser shows the place where the new dimension will be inserted with a yellow line, to the right or left of the dimension next to which you wish to add it.
This operation can also be done from the Dimensions Explorer, selecting the corresponding options Add to Rows or Add to Columns as suitable, or just dragging the desired element from the Explorer to the table.
It is possible to group dimensions from the Explorer, in the case that the analysis pane displays information in graph mode. In order to group dimensions from the Dimensions Bar, the user must necessarily be working in table mode.
If a dimension already placed on one axis is added to the other one, it disappears from the original axis. If that dimension was the only one on that axis, it is substituted by the current measure.
If display is changed from table to graph, it is possible to maintain the embedding process but it is difficult to keep a clear vision of the information due to the number of combinations that must be shown. For this reason, it is recommended to restrict the use of embedded dimensions to tables only.
The table label identifies the dimensions assigned to each axis in this format:
DimX1, DimX2, . . ., Dim XN / DimS1, DimS2, . . ., DimSN
Where DimX are the dimensions on the X-axis (or columns in the table) and DimS are the dimensions in the Series (or rows in the table).
Picture 1: Grouping dimensions
Exporting the values in the table
O3 Browser allows users to export data displayed in a table to other applications, such as Word processors or Spreadsheets, through the use of the Operating Systems notepad.
Steps to follow to copy data from the table:
- Select the Copy option in the Edit menu. Data is copied to the notepad.Â
- In the corresponding application, select the Paste option. Data is copied in the selected document or table.Â