Query Properties

You can make various settings for your query in the Query Properties dialog box.

The Query Properties dialog box is divided into tab pages, each of which provides different settings.

Tab Page: General

Description

You can enter or change the query description here.

You can also enter the query description when saving the query.

Technical Name

The technical name of the query is displayed.

InfoProvider

The technical name of the InfoProvider that the query is based on is displayed.

Key Date

Every query has a key date. For time-dependent data, the key date determines the time that the data is selected for. The default value for the key date is the date when the query is executed: <today>.

1. Choose . The Select Values for Date dialog box appears.
2. Choose a date from the calendar.

   If you select 01/01/1999 for example, the system reads time-dependent data for 01/01/1999.

3. Choose OK.

You can also select a variable key date:

1. In the context menu, use the black arrow next to the icon to choose Entry of Variables.
2. Select a variable.
   Note

   For the selection, you might need to know the technical names and descriptions of the variables. Choose Display Key/Text to show the key.

   If you want to create a new variable, choose Create New Variable.

   The Variables Editor appears, where you can create a new variable .

   If you want to change a variable, select it and choose Edit Variable from the context menu.

   The Variables Editor appears and you can change the variable.

3. Choose OK.
   Note

   The key date only applies to time-dependent master data.

Last Changed By

Details of the owner of the query, the person who last changed it, and the date and time when the query was last changed are displayed.

Tab Page: Variable Sequence

Any entry variables the query contains are listed here. You can use the two arrow buttons to set the sequence where the variables appear on the variables screen when the query is executed.

Tab Page: Display

Display Options

You can make the following settings:

• Adjust Formatting after Refreshing

  The setting is useful in BEx Analyzer and is therefore active in the default setting.

  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.

  You can deactivate the function for adjusting the formatting, for example if you want to display the data more quickly, or if you are using a workbook that has its own format template.

  More information: Workbook Settings .

• Hide Repeated Key Values

  You can specify whether to display identical key values more than once in the query. The Hide Repeated Key Values setting is active in the default setting. This means that only the first key value is displayed for each characteristic and other identical key values are hidden.

  Note

  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 .

  Tip

  In the following example, the Hide Repeated Key Values setting is activated:

  Region	Order	Sales
  DE	A	14.900 EUR
  	B	15.800 EUR
  	C	17.600 EUR
  USA	A	12.800 EUR
  	C	32.800 EUR

  In the following example, the Hide Repeated Key Values setting is deactivated:

  Region	Order	Sales
  DE	A	14.900 EUR
  DE	B	15.800 EUR
  DE	C	17.600 EUR
  USA	A	12.800 EUR
  USA	C	32.800 EUR

  Caution

  Note that the setting made to hide repeated key values when using the query as a data provider in Web applications is not evaluated. You need to make this setting again for the Analysis Web item. When the query is used in BEx Analyzer, the system uses the settings you have made here.

• Display Scaling Factors for Key Figures

  Key figures can have scaling factors and units or currencies. Units or currencies are displayed for every key figure, but not the scaling factors. If you activate the Display Scaling Factors for Key Figures setting, an additional header row is added to the row or column header in the query. Information about the scaling factor and the unit or currency appears in this additional header row, as long as it is consistent (for example EUR 1,000).

  This setting is normally deactivated.

  Tip

  In the example below, the Hide Repeated Key Values and Display Scaling Factors for Key Figures settings are activated:

  Region	Order	Sales
  		EUR 1.000
  DE	A	14
  	B	15
  	C	17
  F	D	12
  	E	32

  Caution

  Note that the setting made to display the scaling factors for key figures when using the query as a data provider in Web applications is not evaluated. You need to make this setting again for the Analysis Web item. When the query is used in BEx Analyzer, the system uses the settings you have made here.

Document Links

For metadata, master data, and InfoProvider data for a query, you can display links to documents that you have created for these objects. If documents exist for these objects, the icon appears next to these objects. You can choose this icon to navigate to where the document is displayed on the Web.

Select the appropriate setting so that the document links for the required document class are displayed. The document classes are based on the various categories of BW objects: InfoProvider data, metadata and master data. See Document Classes .

More information: Working with Documents in Web Applications .

Tab Page: Rows/Columns

Result Position

This is where you specify where the result will be displayed.

• Rows: Aboveor Below
• Columns: Left or Right

In the default setting, the results are displayed at the bottom right.

Suppress Zeros

You can use this setting to specify whether columns or rows containing zeros are to be displayed.

The following options are available here:

• Do Not Suppress: Rows or columns with zeros are displayed.
• Active: If characteristics are in the rows and columns, any row or column with a result of zero is not displayed. The row or column contains, for example, the values 1, -1, 1, -1 and thus the result is 0. If you select this setting, the whole row or column is hidden.
• Active (All Values = 0): Columns or rows containing zeros in all cells are not displayed.

Under Effect on, you specify whether suppression of zeros should be applied to rows and columns, only to rows, or only to columns.

Tab Page: Value Display

+/- Sign Display

Here, you specify how the minus sign (-) is displayed. The following display options are available for negative values:

• Before the Number -123.45: The minus sign (-) is positioned before the value (default setting).
• After the Number 123.45-: The minus sign (-) is positioned after the value.
• In Parentheses (123.45): Negative values are displayed in parentheses.

Zero Value Display

The following display options are available for displaying zeros:

• Zero with Currency/Unit: Zeros are displayed with the currency or unit, for example EUR 0.00. This is the default setting.
• Zero Without Currency/Unit: Zeros are displayed without the currency or unit, for example 0.00.
• Zero as Space: Cells containing a zero remain empty.
• Zero as Default Text: If you choose this setting, the Show Zeros asfield is activated. You can now enter the required value (character, number, or letter), for example an asterisk (*). Cells that contain a zero are filled with this value.

Tab Page: Advanced

Release for External Access

External reporting tools use queries as their data source. Here, you can determine whether the query is to be accessed and how.

• Access by OLE DB for OLAP

  If you want to release this query as the data source for external reporting tools that communicate via interface OLE DB for OLAP, select By OLE DB for OLAP.

  Caution

  Queries that contain formulas with the operators %RT, %CT, %GT, SUMRT, SUMCT, SUMGT, and LEAF cannot be released for OLE DB for OLAP. These operators depend on how the list is displayed in BEx Analyzer. The formulas return unexpected values if using OLE DB for OLAP or MDX. The required result can be achieved using constant selection. More information: Constant Selection

  For more information about using formula operators, see Defining Formulas .

  For more information about OLE DB for OLAP, see Mapping Metadata .

• Access by Easy Query

  You can release an existing query for external access as an easy query. Easy queries are static queries without formatting settings. You can use these as SOAP services.

  To generate the query as an easy query, select By Easy Query.

  In the BW system, you can manage easy queries using Easy Query Manager (transaction EQMANAGER).

  For more information about the criteria for easy queries, see Managing Easy Queries .

Data Integrity

Here, you can select how recent the data for an InfoProvider is to be when displayed. In an InfoCube, the system can read data with different request statuses. The following request statuses exist:

• Green: Request loaded successfully
• Yellow: Request not loaded successfully (still loading)
• Red: Request not loaded successfully

You can either select a fixed requests status or define a variable.

More information: Specifying Data Integrity .

Near-Line Storage

If the query is based on an InfoProvider that data has already been stored for in a near-line storage, you can use this option to stipulate that the stored data is read and displayed when the query is run.

More information: Reading Stored Data

Tab Page: Planning

Start Query in Change Mode

Here, you can specify whether to start the query in change mode or in display mode.

For queries that are not input ready, the Start Query in Change Mode checkbox is always inactive and cannot be changed. For input ready queries, this checkbox is active in the default setting. Queries are input ready as soon as they contain a structural component that has one of the following properties:

• Data can be changed using planning functions
• Data can be changed using user entries or planning functions

For input ready queries that are started in display mode, the user has the option at runtime of activating the input ready field to use the query for manually entering planning data or executing planning functions. This ensures that users can use the query in planning applications without locking other users out.

For more information, see Selection/Formula/Cell Properties (Planningtab page) and Input-Ready Query .

Calculate Inverse Formulas

Inverse formulas are used to recalculate input-ready formulas in planning applications. You can define here how the system should start calculating inverse formulas.

Select the Symmetrical Calculation Mode for Inverse Formulas checkbox. At query runtime, the system calculates inverse formulas if at least one element in an input-ready formula has been fixed or changed manually.

In the default setting, the Symmetrical Calculation Mode for Inverse Formulas checkbox is not selected. At query runtime, the system calculates inverse formulas if at least one value in an input-ready formula has been fixed or changed manually.

More information: Defining Inverse Formulas .

To call the Query Properties dialog box for a query, choose Query → Properties in the Query Designer menu bar. The Query Propertiesdialog box for the query appears in the Properties screen area. By choosing Display/Change, you can specify whether the query properties can be changed. To save your settings, choose Save.