At the runtime for a BEx Web application, you can make various settings for a query view axis.
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.
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:
Column Axis:
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:
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.
For more information, see Suppression of Zero Rows and Zero Columns .
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.