Axis Properties

Use

At the runtime for a BEx Web application, you can make various settings for a query view axis.

Features

You make the settings on the following tab pages:

Data Formatting

Under Result Position, you can specify where the results are to be displayed in the table.

Row Axis:

Bottom (= default setting)
Top

Column Axis:

Right (= default setting)
Left

In the Column Axis Properties dialog box, you can display characteristics that are split across multiple columns as a hierarchy in one column. To do this, you select Display Columns Hierarchically and in the Drill Down To dropdown box, you specify the node to which you want to expand this hierarchy.

In the Row Axis Properties dialog box, you can display characteristics that are split across multiple rows as a hierarchy in one column. To do this, you select Display Rows Hierarchically and in the Drill Down To dropdown box, you specify the node to which you want to expand this hierarchy.

Zero Suppression

You can use this setting to specify whether columns or rows containing zeros are to be displayed.

The following options are available under Suppression:

Do Not Suppress: Rows or columns with zeros are displayed.
Active: Remove Rows if Total = 0: If characteristics are in the rows and columns, any row or column with a result of zero is not displayed.

Tip

The rows or columns include, for example, the values 1, -1, 1, -1 and thus the result is 0. If you select this setting, the whole row or column is hidden.
Active: Remove Rows if All Values = 0: Columns or rows containing zero values in all cells are not displayed.

For more information, see Suppression of Zero Rows and Zero Columns .

Activities

In the Web application, choose Properties → Axis in the context menu of an axis. The Row Axis Properties or Column Axis Properties dialog box appears. Make your settings and choose OK.