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:
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.
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.
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 |
This setting is normally deactivated.
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:
Zero Format: You have the following options for displaying zeroes: