Axis area settings

In the Axis area of the Layout Editor you can configure the aggregation level of the Layout query by selecting Entities to be displayed by row and/or by column. These Entities, in turn, define how Cubes in Data Blocks are dimensioned by in the associated Screen Object.

To set Entities in rows and columns, drag and drop them from the Data panel on the left to the "BY ROW" and "BY COLUMN" fields in the Axis area on the right.

Depending on the Object the Layout is associated with, the "BY ROW" and "BY COLUMN" fields may not be available or may have different names. For example, some Chart Objects have the following Axis area to better reflect how data is dimensioned in the Objects themselves:

Click the "Settings" button to configure additional Axis settings in the panel that appears on the right-hand side of the page. The following properties are available:

For the "BY ROW" field:
- Display mode. Defines which information about Entity members should be displayed: default, code, description or both
  The "default" option is defined under the Entity options menu in the Data model section of Board.
- Show All. When enabled, it displays all rows,including those with zero values. This option is disabled by default, therefore rows containing only zero values are not displayed
- Down Totals. Allows enable or disable the column totals, for all blocks of the layout
For the "BY COLUMN" field:
- Display mode. Defines which information about Entity members should be displayed: default, code, description or both
  The "default" option is defined under the Entity options menu in the Data model section of Board.
- Show All. When enabled, it displays all columns, including those with zero values. This option is disabled by default, therefore columns containing only zero values are not displayed

Learn more about: