Data Provider Properties

At runtime in a BEx Web application, you can make various settings for the data provider upon which the Web application is based.

The data provider can be a data provider of type Query View or a data provider of type Filter. The system provides different configuration and display options, depending on the type.

You make the settings on the following tab pages:

Data Formatting

The following settings are available under Data Formatting:

• Under Result Position, you can specify where the results are to be displayed in the table:
  • Bottom/Right (default setting)
  • Top/left
  • Bottom/Left
  • Top/Right
• You can display characteristics that are split across multiple columns in one column as a hierarchy. 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.
• You can display characteristics that are split across multiple rows in one row as a hierarchy. 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.

Size Restriction for Result Sets

Here, you can set the maximum number of cells in the result set for this data provider. This allows you to avoid result sets that are too large and that can have a negative impact on the performance and quality of Web applications.

• Maximum Number: The value under maximum number is the setting made by your system administrator.
• Standard Number: The value under standard number is the setting made by your system administrator.
• User-defined number of cells: Instead of using the preset standard number or the maximum number, you can set your own maximum number of cells to be displayed for this data provider (query view). Enter the required number in Number of Cellsfield.
  Note

  If the user-defined number of cells exceeds the maximum number, the maximum number is automatically taken as the user-defined number of cells.

More information: Setting the Size Restriction for Result Sets

Number Format

Under Number Formatting, you can find the following settings:

• Under Display of +/- Signs, you choose how the minus sign is displayed.
  • In front of the value - for example, -5 is displayed
  • After the value - for example, 5- is displayed
  • In parentheses - for example, (5)is displayed
• Under Display of Zeros, you can select how you want to display zeros:
  • With Currency/Unit (default setting): Zeros are displayed with a currency or unit entry, for example, EUR 0.00.
  • Without Currency/Unit: Zeros are displayed without a currency or unit entry, that is, 0.00.
  • As Empty Cells: Cells containing a zero value remain empty.
  • Custom String: If you choose this setting, you can enter the required value in the Custom Zero String field (characters, numbers, or letters), for example, *. Cells that contain a zero are filled with this value.

Zero Suppression

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

You can select from the following options under Apply Suppression to Columns and under Apply Suppression to Rows:

• 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 row or column contains, 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.

If you also want to suppress structure elements that only contain zeros, select Zero Suppression for Structure.

More information: Suppression of Zero Rows and Zero Columns .

 

By choosing Advanced, you can display the following additional tab pages:

More Information Is Available

This provides you with more information about the data provider: Description, Technical Name, Created By, Last Changed By, Changed On, Changed At and Due Date.

InfoProvider Information

This provides you with more information about the underlying InfoProvider: Description, Technical Name and System

Currency Translation

You can specify the currency that the key figures and structure components of the data provider are to be converted into. More information: Making Currency Translations .

In the Web application, choose Properties → Data Provider in the context menu of a characteristic value, characteristic description, or structure element. The Query View Properties or Filter Properties dialog box appears. Make your settings and choose OK.