Query Properties 

Use

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 (see Tools → Query Designer).

Features

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

●      Navigational 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.

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:

●      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 Columns to Rows

●      Move Selected Dimensions from Rows to Columns

●      Move Selected Dimension of Columns Up One Position

●      Move Selected Dimension of Columns Down One Position

●      Move Selected Dimensions from Rows to Free Characteristics

●      Move Selected Dimensions from Free Characteristics to Rows

●      Move Selected Dimension of Rows Up One Position

●      Move Selected Dimension of Rows Down One Position

●      Move Selected Dimension of Free Characteristics Up One Position

●      Move Selected Dimension of Free Characteristics Down One Position

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 Columns Hierarchically and Expand To– 

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 Rows Hierarchically and Expand To – 

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 Factorsetting in Key Figure Properties.

Display Document Links to …

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 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. See Document Classes.

 

Currency Translation

You have a number of options for converting the currency displayed in your results:

●      Convert to Currency as Defined in Query: Complex currency translations can be configured using BEx Query Designer. If this type of translation is configured in your query, you can use this function in your query results.

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

○       Use Currency Translation: After selecting the target currency for the results, select the type of translation to use for the conversion from this dropdown box.

○       First Apply Currency Translation from Query Definition: Select this checkbox to convert into the currency defined in the query, and then to convert to the currency defined in these settings.

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

See 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 either to rows and columns, to rows only, or to columns only:

●      Rows

●      Rows and Columns

●      Columns

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. 

●      Left

●      Right (default)

Position of Result in Columns

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

●      Bottom (default)

●      Top

Displaying +/- 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.

Displaying 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 Without Currency/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:

●      Created by

●      Last changed by

●      Changed 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.

○       Choose BEx Analyzer → Context Menu for Selected Cell.

       2.      Choose Query Properties.

The Query Properties dialog box appears.