Query Properties 
Use
You can make various settings for your query in the Query Properties dialog box.
Integration
You reach the Query Properties dialog box by selecting a query name in the Ad-hoc Query Designer and choosing Properties from the context menu.
If you have not yet saved your query and therefore have not yet given the query a name, the name of the query appears in the title as <New Query>.
Features
The Query Properties dialog box is divided into four tab pages, each covering different settings.
Tab Page: General
Description
The name of the query that you entered when saving the query appears automatically as the description. You can change this to a new description.
Technical name
The technical name of the query is displayed.
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. Click on the Key Date field. A dialog box with a calendar appears for you to select your key date.
2. Select a date from the calendar. If you select 01.01.1999 for example, time-dependent data is read from the 01.01.1999.
The key date applies only to time-dependent data.
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 Release for OLE DB for OLAP.
Note: Queries containing formulas with the operators
%RT, %CT, SUMRT, SUMCT 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.
Data staging
You choose here whether you want to display the query in a tabular or multi-dimensional view.
If you choose Tabular View, you can determine the sequence of the columns on the Tabular View tab page.
If you choose Multi-dimensional View, you can specify whether the columns or the rows are displayed hierarchically. Select the checkbox and specify the InfoObject to which you want to expand the hierarchical display.
Properties
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: Presentation
Presentation options
Results position
Here you determine whether the result is displayed on the bottom right (=default), bottom left, top right or top left.
+/- sign display
Here you determine how the minus sign is displayed. The following display options are available for negative values:
· - 5 = the minus sign is positioned before the value (=default setting)
· 5 - = the minus sign is positioned after the value
· (5) = negative values are displayed in parentheses
Zero display
The following display options are available for displaying zeroes:
With Currency/Unit: Zeroes are displayed with the currency/unit (for example, 0.00EUR). This is the default setting.
Without Currency/Unit: Zeroes are displayed without a currency or unit entry, that is, 0.00.
A Empty Cells: 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).
Display zeroes As...
You enter the required value (characters, numbers or letters), 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.
Display options
The following settings are possible:
· Adjust format after refresh
· Suppress repeated key values
· Display scaling factors
· Display document links
¡ for InfoProvider data
¡ for metadata
¡ for master data
· Display Drag&Relate links
These options are identical to those in the BEx Query Designer. For more information, see Query Properties.
Tab Page: Variables
This tab page appears only when the query contains variables. Reusable restricted key figures, calculated key figures, or structures can all have variables. If you have any of these reusable objects containing variables in your query, the Variables tab page appears in the query properties.
Any entry variables the query contains are listed here. You can determine the sequence in which the variables appear in the variables screen when you execute the query. In the dropdown box, select the placing (1,2,3...) for the current variable.
Tab Page: Tabular View
You can also use the query in a tabular view. In the tabular reporting view, the InfoObjects are displayed only in the columns. By assigning columns how you want, you can, for example, display a characteristic between two key figures.
In the Presentation tab strip under Data Processing, you choose Tabular View.
You can determine the sequence of the characteristics and key figures used in the query in the columns by selecting the placing (1, 2, 3...) from the dropdown box of the InfoObject that you are using.
Activities
Make the settings you need for the query and choose Transfer.