Screen Area: Output Settings

In the Output Settings screen area of the General tab, you can view and configure settings for query output.

The following settings are available for query output:

• Adjust Formatting after Refreshing: This setting allows you to decide whether the formatting of the query is adapted after refreshing.

  The formatting for the query underlines the type of data contained in a cell and highlights the structure of the delivered results. The position and size of the cell area in the analysis grid change when the query is refreshed. The Adjust Formatting After Refreshing function guarantees that the format is adjusted when the updated query data is refreshed. The setting Adjust Formatting after Refreshing is activated by default.

• Suppress Repeated Key Values: You can specify whether to display identical key values more than once in the query. The Suppress Repeated Key Values setting is active in the default setting. This means that only the first key value is displayed for each characteristic, while other identical key values are hidden.
  Note

  The key value is the value that the characteristic is presented with. This can be the characteristic description or the characteristic key for example. You can specify how the characteristic is presented by using characteristic properties.

  Tip

  In the following example, the Suppress Repeated Key Values setting is activated:

  Region	Order	Sales
  DE	A	EUR 14,900
  	B	EUR 15,800
  	C	EUR 17,600
  USA	A	EUR 12,800
  	C	EUR 32,800

  In the following example, the Suppress Repeated Key Values setting is deactivated:

  Region	Order	Sales
  DE	A	EUR 14,900
  DE	B	EUR 15,800
  DE	C	EUR 17,600
  USA	A	EUR 12,800
  USA	C	EUR 32,800

• Show Scaling for Measures: Key figures can have scaling factors and units or currencies. If you activate the Show Scaling for Measures setting, an additional header row is added to the row or column header in the query. This additional header row contains information about the scaling factor and the unit or currency, as long as it is consistent (for example EUR 1,000).

  This setting is normally deactivated.

  Tip

  In the following example, the settings Suppress Repeated Key Values and Show Scaling for Measures are activated:

  Region	Order	Sales
  		EUR 1,000
  DE	A	14
  	B	15
  	C	17
  F	D	12
  	E	32

• Sign Format: This allows you to specify how the minus sign (-) is displayed. You have the following options for displaying negative values:

  • Before the number: -123.45. The minus sign is positioned before the value (this is the default setting).
  • After the number: 123.45-. The minus sign is positioned after the value.
  • In brackets: (123.45). Negative values are displayed in brackets.

• Zero Format: You have the following options for displaying zeroes:

  • With Currency: Zero with currency/unit. Zeroes are displayed with the relevant currency/unit, for example EUR 0.00. This is the default setting.
  • Without Currency: Zero without currency/unit. Zeros are displayed without a currency or unit entry, for example 0.00.
  • As Space: Zero as an empty space. Cells containing a zero value remain empty.
  • Custom: Zero as a custom text. If you choose this setting, the Show Zeroes field is activated. You can now enter the required value (character, number, or letter), for example an asterisk (*). All cells that contain a zero will now be filled with this value.