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 various tab pages, each of which contains 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

Displays the technical name of the query.

InfoProvider

Displays the technical name of the InfoProvider that the query is based on.

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

Choose . The Select Values for Date dialog box appears.
Select a date from the calendar.
If you select 01/01/1999 for example, the system reads time-dependent data for 01/01/1999.
Choose OK.

You can also select a variable key date:

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

Note

To be able to do this, 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 cancreate 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.
Choose OK.

Note

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

Last Changed By

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

Tab Page: Variable Sequence

Displays any entry variables contained in the query. 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 formatting adjustment function, 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, while other identical key values are hidden.

Tip

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

Region	Order	Sales
DE	A	EUR 14,900
	B	EUR 15,800
	C	EUR 17,600
USA	A	EUR 12,800
	C	EUR 32,800

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

Region	Order	Sales
DE	A	EUR 14,900
DE	B	EUR 15,800
DE	C	EUR 17,600
USA	A	EUR 12,800
USA	C	EUR 32,800

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. This additional header row contains information about the scaling factor and the unit or currency, 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 theAnalysis Web item.

If the query is used in SAP BusinessObjects Analysis, Edition for Microsoft Office, you need to make this setting again. More information: http://help.sap.com → SAP BusinessObjects → All Products → Analysis, edition for Microsoft Office in the User Handbook: SAP BusinessObjects Analysis, Edition for Microsoft Office under Analyzing Data → Defining How Elements, Key Figures and Results are Displayed → Showing/Hiding Scaling Factors.

If 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 todocuments that you have created for these objects. If documents exist for these objects, the icon appears next to them. 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. SeeDocument Classes.

More information:Working with Documents in Web Applications.

Tab Page: Rows/Columns

Result Position

This allows you to 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.

You have the following options:

Do Not Suppress: Rows or columns with zeros are displayed.
Active: If the rows and columns contain characteristics, any row or column with a result of zero is not displayed. The row or column contains the values 1, -1, 1, -1 for example, meaning that 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

This allows you to specify how the minus sign (-) is displayed. You have the following options for displaying 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

You have the following options 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. This allows you to determine whether and how the query is accessed.

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, seeDefining Formulas.

For more information about OLE DB for OLAP, seeMapping 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, seeManaging 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

This allows you to decide 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, seeSelection/Formula/Cell Properties (Planningtab page) andInput-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.

Activities

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.