Start of Content Area

Procedure documentation Query Properties  Locate the document in its SAP Library structure

Use

On the Query Properties dialog box for the query monitor you can make settings for a BI query with regard to the read mode, the cache mode, the selection of structure elements, the optimization mode and the calculation accuracy. You can switch off the default Parallel Processing for queries on a MultiProvider. For queries with virtual characteristics or key figures, you can activate the use of the cache, which is deactivated by default. If you select the Generation Log indicator, when you choose the Generation Log pushbutton in the query monitor, you can display a log in which reasons why the query was regenerated are listed.

Prerequisites

You have created the relevant query in the BEx Query Designer. The settings specified in Customizing for the InfoProvider on which the query is based, or those that were specified earlier in the Query Monitor, are applied to the query.

Procedure

Select the required settings.

Note

Some options are always available; however, some options are only provided depending on the InfoProvider on which the query is based.

Changing Read and Cache Mode for Existing Queries

In InfoProvider maintenance, you can specify standard settings for the read and cache mode of an InfoProvider (and persistence mode, if applicable). These settings apply to all queries subsequently created for the InfoProvider. Choose Environment InfoProvider Properties Change and specify the required read mode on the Query/Cache tab page.

Furthermore, for InfoProviders for which data cannot be changed within the BI system (such as VirtualProviders and DataStore objects for direct update), you can specify the cache validity, that is, the data retention period in the cache.

Note

If required, you can subsequently change the InfoProvider-specific settings in the Administration functional area of the Data Warehousing Workbench under Current Settings.

In the Query Monitor, you can change the standard settings for the read mode (see Read Mode) and cache mode (see Cache Mode) for existing queries. You can only specify the cache validity for InfoProviders in Customizing.

Specifying Data Integrity According to the Request Status

Using the Request Status setting, you can specify for the selected query, up to which request the data is to be included (see Specifying Data Integrity According to the Request Status).

Using the Delta Cache Process

When the data basis changes, you can optimize the cache performance for suitable InfoProviders using the delta cache process (see Activating Delta Caching); you can also optimize the cache performance for queries based on MultiProviders by specifying a grouping (see Specifying the Grouping for Delta Caching).

Using the Selection of Structure Elements

The Use Selection of Structure Elements option can be selected for any query; however, it is only useful in some cases.

In queries, selections are frequently based on one or more characteristics in the columns, or more precisely, in the structure elements. One or more of these structure elements are often filtered in the BEx Analyzer or in BEx Web applications. If you do not select the Use Selection of Structure Elements option, these dynamic (structure element) selections are not transferred to the database. Normally, the data for the entire structure or for both structures is then read from the database.

Specifying the Accuracy

You can specify the accuracy with which a key figure is to be calculated in InfoObject maintenance.

You can only specify the accuracy with which all query key figures are to be calculated in the Query Monitor (and not in the BEx Query Designer). You use this to override the settings made in InfoObject maintenance for individual key figures, where necessary (see Accuracy).

Deactivating Parallel Processing

A query based on a MultiProvider is split internally into subqueries; these are automatically processed in parallel. In most cases, parallel processing has benefits in terms of performance. However, in some cases, query performance benefits more from sequential processing (see Processing Queries).

You can deactivate parallel processing for a MultiProvider in the RSADMIN table.

You can deactivate parallel processing for a query based on a MultiProvider in the Query Monitor. (See Not Using Parallel Processing.)

Specifying the Optimization Mode

If you do not make any other settings, the OLAP processor determines the optimal initial size of the table SP, that is, the memory structure in which data is held and processed in the OLAP processor (see Cache Structure). This is done after the query is first executed and again after a period of 31 days since the last optimization. A report is generated automatically.

In the Query Properties dialog box in the Query Monitor, you can implement, modify, or deactivate this function. Choose one of the following options:

      Query Will Be Optimized after Generation (0)

      Query Optimization with Individual Periods in Days(1) You can specify the optimization period as required.

      Query Optimization Inactive (9)

Permitting Cache Use Despite Virtual Characteristics and Key Figures

If virtual characteristics or key figures are used in the query, the cache is deactivated by default. In the Query Monitor, you can change this setting using the Cache Use Despite Virtual Characteristics/Key Figuresoption.

Statistics Details

The system displays the Detail Level setting for BI query runtime statistics as it is set in the maintenance of statistics properties (transaction RSDDSTAT) for the Query object type (for more information, see Maintenance of Statistics Properties and the section Statistics Detail Level for the Query Object Type).

 

End of Content Area