Data Layout is an interface used to edit queries. Data Layout displays the dimensions returned by the database connection, as they are arranged on four axes:
Three kinds of dimensions are differentiated by these icons:
Icon | Dimension |
|---|---|
| Dimensions |
| Attribute Dimensions |
| Attribute Calculations |
Every query must have at least a dimension assigned to the Rows axis and the Columns axis, but you can also nest multiple dimensions on one axis. You can organize the Row and Column dimensions by assigning dimensions to the Page axis. Dimensions not assigned to Rows, Columns, and Pages, remain in the Filter axis.
All dimensions participate in every intersection displayed by a data object, regardless of the axis to which they are assigned. You use Data Layout to arrange dimensions, to specify their level of detail, and to specify query options.
All data objects start as spreadsheets. Charts and Pinboards are graphical representations of the data in the spreadsheet. |
To move a dimension between axes, drag the dimension name from its current axis to another axis.
The cursor displays a box next to it when it is over the axis. When you release the mouse button, the Dimension Browser dialog box displays. Use Dimension Browser to make member selections as needed, and click OK.