Query Properties 
Use
You can make various settings for your query in the Query Properties dialog box.
Features
The Query Properties dialog box is divided into three tab pages, each covering different settings.
Tab Page: General
Technical Name
The technical name of the query is displayed.
InfoProvider
This is where the technical name of the InfoProvider, on which the query is based, is displayed.
Description
You can enter or change the query description here.
You can use Text Variables in the description.
You can also enter the query description when you save the query.
Key Date
Each query has a key date. For time-dependent data, the key date determines the time for which the data is selected. The default key date value is the date on which the query is executed, that is <Today>.
...
1.
Choose 
. The Date Selection dialog box
appears.
2. Choose a date from the calendar and use the arrow button to add it to the selection window on the right. If you select 01.01.1999 for example, time-dependent data is read up to 01.01.1999.
3. Choose OK.
You can also select a variable key date:
...
1. In the Date Selection dialog box, choose the Variables tab page.
2. Choose a variable and use the arrow button to add it to the selection window on the right.
In the selection, you may need to know the technical names of the queries as well as their descriptions. In the Description window on the left hand side, choose Technical Names from the context menu (secondary mouse click).
If you want to create a new variable, in the Description window on the left-hand side, choose New Variables from the context menu (secondary mouse click). The Variable Wizard dialog box appears, where you can create new variables .
If you want to change a variable, in the Description window on the left-hand side, select the variable and choose Change Variable from the context menu (secondary mouse click). The Variable Editor dialog box appears, where you can change variables .
3. Choose OK.
The key date only applies to time-dependent master data.
Sequence of Entry Variables
Any entry variables the query contains are listed here. You can use the two arrow buttons to the right of the field to determine the sequence in which the variables appear in the variable screen when executing the query.
Last Changed
This is where you can see details of the owner of the structure, the person who last changed the structure, and the corresponding date and time that the query was changed.
Tab Page: Display
Display Options
The following settings are possible:
· Adjust format after refresh
The setting is useful in the BEx Analyzer and is the default setting.
Formatting for the query underlines the type of data contained in a cell, highlighting the structure of the delivered results. As a rule, the position and size of the cell area in the results area of the query changes when the query is refreshed. The function Adjust Format After Refresh guarantees that the format is adjusted after the updated query data is refreshed.
You can deactivate the function for adjusting the format, for example, if you want to display the data more quickly, or if you use a workbook with your own format template.
For more information, see 
Formatting
· Suppress repeated key values
Here you can determine whether or not identical key figures are to be displayed in duplicate in the query. The setting Suppress Identical Key Values is active by default, so that only the first key value is displayed for each characteristic and additional, identical key values are suppressed.
The key value is the value with which the characteristic is presented. This can be the characteristic description or the characteristic key. You can determine how the characteristic is to presented in the Characteristic Properties.
In the following example, the Suppress Identical Key Values 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 Suppress Identical Key Values 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 |
· Display Scaling Factors for Key Figures
Key figures can have scaling factors and units/currencies. Normally, units/currencies are displayed for every key figure, but not the scaling factors. If you activate the Display Scaling Factors for Key Figures, an additional header row is added to the row or column header. Information about the scaling factor and currency/unit appears in this additional header row, as long as it is consistent (for example, 1,000 EURO).
This setting is deactivated by default.
In the following example, the Suppress Identical Key Values and Display Scaling Factors for Key Figures is activated:
Region |
Order |
Sales |
|
|
1,000 EUR |
DE |
A |
14 |
|
B |
15 |
|
C |
17 |
F |
D |
12 |
|
E |
32 |
· Display 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
symbol 
appears next to these objects. If you click
on this symbol, you jump to where the document is displayed on the
Web.
Highlight the appropriate setting so
that the document links for the desired document class are displayed. The
document classes are oriented to the various categories of BW objects.
InfoProvider
data, metadata and master data.
See Document
Classes.
For more
information, see Using Documents in Web
Applications.
· Display Drag&Relate links
When activating this setting, the
symbol 
appears alongside the Drag&Relate-enabled
InfoObjects in a Web application that serve as DataProviders for this query.
This setting is necessary for you to be able to recognize
Drag&Relate-enabled InfoObjects in an Enterprise Portal and to use the
Drag&Relate function. For more information about the Drag&Relate
function, see Drag&Relate with
BW Content in the Enterprise Portal.
Number Display
The following settings are possible:
· Results position
This is where you determine where the result is displayed.
- Bottom (for rows) right (for columns) (=default setting)
- Bottom (for rows) left (for columns)
- Top (for rows) right (for columns)
- Top (for rows) left (for columns)
· +/- sign display
Here you determine how the minus sign is displayed. The following display options are available for negative values:
- -X = the minus sign is positioned before the value (=default setting)
- X- = the minus sign is positioned after the value
- (X) = negative values are displayed in parentheses
· Display zeroes
The following display options are available for displaying zeroes:
- Display Zeroes: Zeroes are displayed with the currency/unit, for example 0,00EUR. This is the default setting.
- Zeroes without Currency/Unit: Zeroes are displayed without a currency or unit entry, that is, 0,00.
- Do Not Display Zeroes: Cells containing a zero value remain empty.
- Display Zeroes As...: Choosing this setting activates the Display Zeroes As field. You are now able to enter the required value (character, number or letter), for example *. The cells containing a zero value are filled with this value.
Suppressing zeroes
You can use this setting to determine whether columns or rows containing zeros are to be displayed.
The following options are available to you under Suppression:
· No: Rows or columns with zeroes are displayed.
· Active: If characteristics are in the rows and columns, every row or column that has a result of zero is not displayed. The rows or columns include, 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 not displayed.
· Active (all values = 0): Columns or rows containing zero values in all cells are not displayed.
Under Effect on, define whether suppression of zero values should be applied to rows and columns, only to rows or only to columns.
Tab Page: Specific
Release for OLE DB for OLAP
External reporting tools that communicate using the OLE DB for OLAP interface use queries as data sources. If you want to release this query as a data source for external Reporting tools, select Allow External Access to this Query.
Note:
Queries containing formulas with the operators %RT, %CT, %GT, SUMRT, SUMCT,
SUMGT, and LEAF cannot be released for OLE DB for OLAP. These operators are
dependent on how the list is displayed in the BEx Analyzer and the formulas
return unexpected values when using OLE DB for OLAP or MDX. You may be able to
obtain the required result by selecting constants. For more information, see
Selecting
Constants.
For more information about using formula operators, see Defining Formulas.
For more information about OLE DB for OLAP, see Mapping Metadata.
Document Pushbutton
You can use the Documents button to get to the available documents that relate to the query in the Administrator Workbench. You can also create new documents for the query here.
For
more information, see Documents
and Creating Documents
.
Activities
You
call up the properties dialog box for a query by clicking on 
Query Properties in the Query Designer
toolbar.