Query Properties 

Use

Using this function, you configure various settings that affect how the query behaves and is displayed in analysis mode. These are local query properties, rather than properties defined in the query itself. To change the query itself, use the Query Designer (see Tools ® Query Designer).

Features

There are seven tab pages in the query properties dialog box:

●      Navigation State – allows you to reconfigure the distribution of dimensions along the query axes

●      Data Formatting – allows you to change the way the axes display

●      Display Options – allows you to configure various display settings

●      Currency Conversion – allows you to convert currency

●      Zero Suppression – allows you to configure options for suppressing results that contain zeros

●      Presentation Options – allows you configure the result positions and display of zeros

●      Properties – displays properties for the query

●      Conditions - displays the conditions for the query view and enables you to edit them.

To toggle the display of technical names, choose Display Technical Names/Do Not Display Technical Names on the tab pages.

Navigation Status

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 status of the query is displayed in three list boxes:

●      Columns: Lists the dimensions that currently appear in the columns

●      Rows: Lists the dimensions that currently appear in the rows

●      Free Characteristics: Lists the free characteristics and dimensions that do not currently appear in the results

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:

●      Move Selected Dimensions from the Columns to the Rows

●      Move Selected Dimensions from the Rows to the Columns

●      Move the Selected Dimension of the Columns One Position Up

●      Move the Selected Dimension of the Columns One Position Down

●      Move Selected Dimensions from the Rows to the Free Characteristics

●      Move Selected Dimensions from the Free Characteristics to the Rows

●      Move the Selected Dimension of the Rows One Position Up

●      Move the Selected Dimension of the Rows One Position Down

●      Move the Selected Dimension of the Free Characteristics One Position Up

●      Move the Selected Dimension of the Free Characteristics One Position Down

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

You switch between a tabular result display and a multidimensional result display, and configure additional multidimensional options, by making the following settings:

●      Tabular View – presents the results in Tabular Reporting format, as in a table. In this view, InfoObjects are displayed only in the columns. A multidimensional result is adjusted to be displayed in a table.

●      Multidimensional View – presents a multidimensional result and allows you to configure hierarchies as you want:

○       Display the Columns Hierarchically and Expand Till – 

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.

○       Display the Rows Hierarchically and Expand Till – 

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 (for example, 1,000 EURO).

Scale key figures by factors using the Scaling Factor setting in Key Figure Properties.

Display Document Links on …

Select the checkboxes to display links to documents if they exist for different types of objects:

●      Data: Displays links to documents that have been created for InfoProvider data

●      Metadata: Displays links to documents that have been created for metadata

●      Master Data: Displays links to documents that have been created for master data

If you have selected this indicator and if the documents exist, the document icon appears next to these objects in the analysis grid. Click this icon to jump to the document display in a Web browser window. See also Document Classes.

 

Currency Translation

You can choose to convert the currency displayed in your results in various ways:

●      Convert to Currency as Defined in the Query Definition: Complex currency translations can be configured using the BEx Query Designer. If such a translation has been configured in your query, this option is available and you can use it in your query results.

●      Convert to Currency: Select this option to convert results to a specific currency. In the dropdown list, select the currency in which the results are to be displayed.

○       Use Currency Translation: After you have selected the currency for the results, select which type of translation to use when converting from this dropdown box.

○       Consider Translation from Query Definition: Select this checkbox to convert first to the currency defined in the query, and then to the currency as customized in these settings.

●      Show Original Currency: Select this option to disable currency conversions.

See also Currency 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:

●      None: Rows or columns with zeros are displayed.

●      Active: If there are characteristics in the rows and columns, those rows or columns that have a result of zero are not displayed.

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

●      Active (all values = 0): Columns or rows containing zero values in all cells are not displayed.

Apply to

Use this dropdown box to define whether suppression of zero values is to be applied to rows and columns, only to rows, or only to columns:

●      Rows

●      Rows and Columns

●      Columns

Apply to Members of Structure Key Figures Too

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:

Result Position for Rows

Specify the position in the columns in which you want to display the results. 

●      Left

●      Right (default)

Result Position for the Columns

Specify the position in the columns in which you want to display the results.

●      Bottom (default)

●      Top

Display of +/- Signs

Use this function to specify how to display negative values that appear in your results:

●      5-: Display the sign behind the value.

●      -5: Display the sign in front of the value.

●      (5): Display the value in parentheses.

●      Default: Use the default display.

Display of Zeros

The following display options are available for displaying zeros:

●      Display: Zeros are displayed with their respective currency or unit (for example: 0.00EUR). This is the default setting.

●      Display No Unit: Zeros are displayed without a currency or unit entry, that is, 0.00.

●      Do Not Display: Cells containing a zero value remain empty.

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:

●      Owner

●      Last changed by

●      Modified on

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:

●      Description

●      Status

For more information, see Conditions, Definition of Conditions, Using Conditions and Defining Conditions in a Workbook.

Activities

...

       1.      In analysis mode, select any cell in the analysis grid and access the context menu using the mouse or keyboard:

○       Select the cell using the secondary mouse button.

○       Or in the menu, choose BEx Analyzer ® Context Menu for Selected Cell.

       2.      Choose Query Properties.

The Query Properties dialog box appears.