Query element / InfoObject usage report

Extended query statistics includes the information, which query elements were used during the query execution. Query definitions can include multiple elements (e.g. free characteristics, key figures, etc.) that can be used for a further drill down to get more detailed information of the aggregated data. However, most of them are hidden by default and not all of them are used regularly. Using our statistics, you can identify elements that are used most, less or never. Query element can use one or multiple InfoObjects, therefore based on the usage report of query elements, you can also obtain the InfoObject usage. The report enables you to analyze statistics from different perspectives. You are able to group, show/hide desired result fields to get most suitable granularity of statistical data.

Technical information:

Report	/DVD/HS_QUERY_ELM_USAGE
Transaction	/DVD/HS_ELMUSG

User interface

You may customize your view preferences.

The initial load of the report contains no data. After you click Execute on the menu bar, the desired data is loaded.

Report parameters sections:

The report enables you to analyze usage statistics with different view perspectives and with selected filters and aggregation.

Screenshot	Description
	Date range of analyzed statistics
	Statistics can be aggregated to two source data InfoObject - Query elements enhanced with InfoObjects Enterprise ID only - Query elements only
	Detail level Basic display only elements that are visible at the query output (doesn't matter whether element is flagged hidden or not) Additional display elements from previous level and also used reusable Calculated and Restricted key figures All linked display elements from previous levels also all elements that relates to at least one of displayed objects in previous levels
	Display/hide columns in results
	Columns that will be used for subtotals
	Result filters

Result table

Result table contains statistics based on the selected filters and aggregation.

Column	Description
Query	Technical name of query
Query descr.	Query description
Description	Based on selected aggregation InfoObject description of InfoObject Enterprise ID only description of query element
Key	Technical name of query element You can find it in the BEx query designer
Enterprise ID	Unique ID of the query element You can find it for example in the BEx query designer
InfoObject	Technical name of the InfoObject
User name	Technical name of the user, who used the query element. Note that the collection of the user name must be switched on in the Extended query statistics
Type	Type of the query element
Subtype	Sub-type of the query element
Structure	Technical name of the element's parent structure
Structure Enterprise ID	Enterprise ID of the element's parent structure
Date	Date when the query element was used
Usage	The number of times the query element was used in query execution

List of supported query element types and sub-types:

Type	Subtype	Description
SEL	STM	Structure element
SEL	CHA	Free characteristic
FML	STM	Formula
CKF	CKF	Calculated Key Figure
SEL	RKF	Restricted Key Figure

Collection of statistics

To analyze used query elements (free characteristics and key figures) in the future, you should enable their analysis as shown below. The collection of statistics can be enabled in following way:

Enter transaction /DVD/QS_CONF.

On Query Statistics settings switch on the Displayed query elements, click Save and confirm.

Statistics are collected only, when the query requests data from a database.

SNP

(DI-1908) Query Element Usage Statistic and Analysis