You can use this function to configure various settings that affect the behavior of the query and how it is displayed in analysis mode. These are local query properties, rather than properties defined in the query itself. To change the query itself, use Query Designer (seeTools → Query Designer).
There are seven tab pages in the query properties dialog box:
To toggle the display of technical names, choose Display Technical Names/Do Not Display Technical Names on the tab pages.
Navigational State
Use this tab to change the arrangement in the analysis grid of dimensions (characteristics and key figures) on the rows, columns, and free characteristics for the query.
The navigational state of the query is displayed in three list boxes:
The dimensions are displayed in the rows and columns in the sequence in which they appear in the query. You can select a dimension or dimensions and rearrange their position and sequence in the rows axis and columns axis of the query (or remove them from the current results to the free characteristics) by using the arrow buttons:
You can also arrange the dimensions across columns, rows, and free characteristics using the drag and drop function.
You can open the Properties dialog box and Selector dialog box (to select a filter value) of a dimension. To do this, use the secondary mouse button to choose the dimension and select the appropriate option from the context menu.
Data Formatting
Multidimensional View - presents a multidimensional result and allows you to configure hierarchies as you want:
Select this checkbox to place characteristics that are split over several columns into one column in a hierarchy. In the dropdown box, specify the node to which you want to expand this hierarchy.
Select this checkbox to place characteristics that are split over several rows into one row in a hierarchy. In the dropdown box, specify the node to which you want to expand this hierarchy.
Display options
You configure various display settings using the following functions:
Display scaling factors
If a scaling factor has been applied to the key figures, select this checkbox to add an additional header row in the row or column header of the table that displays the factor (1,000 EURO for example).
Scale key figures by factors using the Scaling Factor setting inKey Figure Properties.
Display Document Links to …
Select the checkboxes to display links to documents if they exist for different types of objects:
If you have selected this flag and the documents exist, the document icon appears next to these objects in the analysis grid. Click this icon to display the document in a Web browser window. SeeDocument Classes.
Currency Translation
You have a number of options for converting the currency displayed in your results:
SeeCurrency Translation in the Business Explorer
Zero Suppression
To suppress results rows or columns that contain zeros, and therefore remove them from the display in the analysis grid, select the following options:
Zero Suppression
Use this dropdown box to select the following suppression options:
For example, if the rows or columns include the values 1, -1, 1, -1, the result is 0. If you select Active, the whole row or column is not displayed
Apply To
Use this dropdown box to define whether suppression of zero values is to be applied either to rows and columns, to rows only, or to columns only:
Apply Also to Members of Structure Key Figures
Select this checkbox if you also want to suppress the structure elements that only contain zeros.
Presentation Options
You configure the results position and display of zeros using the following functions:
Position of Result in Rows
Specify the position in the rows in which you want to display the results.
Position of Result in Columns
Specify the position in the columns in which you want to display the results.
Displaying +/- Signs
Use this function to specify how to display negative values that appear in your results:
Displaying Zeros
The following display options are available for displaying zeros:
Show Zeros As
Enter a value to display in cells that contain zero results. You can enter any character, number, or letter, for example *. Cells that contain a zero value are filled with this value, for example *.
Properties
Displays the following data about a query:
The Editable checkbox, which is active for input-ready queries only, allows you to toggle between display and change mode for the query data.
Conditions
Displays the following data about a query:
For more information, seeConditions, Definition of Conditions, Using Conditions andDefining Conditions in a Workbook.
The Query Properties dialog box appears.