(DI-2111) Query Element Usage Statistic and Analysis
Table of Contents:
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 elements 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 the 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:
| |
Detail level:
| |
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 a query |
Query descr. | Query description |
Description | Based on selected aggregation:
|
Key | Technical name of the 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 username 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 the 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.