Show TOC

 Axis PropertiesLocate this document in the navigation structure

Use

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

Note

The settings available for data formatting and zero suppression are the same as those available in the properties for the query view (see Data Provider Properties ). However, the settings in the properties for the axis are specific to either a row axis or a column 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.