...
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, 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.
...
You may customize your view preferences.
| Info |
|---|
The initial load of the report contains no data. After you click Execute on the menu bar, the desired data is loaded. |
...
| 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 |
...
| Column | Description |
|---|---|
| Query | Technical name of a query |
| Query descr. | Query description |
| Description | Based on selected aggregation:
|
| 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 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 |
...