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.

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.