(DI-1805) IMP-001 Query element usage statistic and analysis
- Martina Pospisilova (Unlicensed)
IMPROVEMENT ARCHIVE
Download link
Description: Insights 1805 IMP-001 Query element usage statistic
https://mats.datavard.com/downloader.php?ticketid=9dd5d2dc0c956526bcc39bebaa58b905
Password: Datavard1
Transports requests
| Request | Date | Owner | Short Text |
|---|---|---|---|
| NSQK904578 | 22.06.2018 | DATAVARD | Insights 1805 IMP-001 Query element usage statistic |
Import the transport request to the central system and all satellite systems.
Improvement can be used for the version 1805.
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.
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 Refresh 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
|
| Display/hide columns in results |
| 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
|
| 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 |