(DI-1802) IMP-001 InfoObject usage statistics
- Zuzana Čížová (Deactivated)
IMPROVEMENT ARCHIVE
Download link
Description: Insights 1802 IMP-001 InfoObject usage statistics
https://mats.datavard.com/downloader.php?ticketid=d700530da2dfed09c6f2ac8c89edf2da
Password: Datavard1
Transports requests
| Request | Date | Owner | Short Text |
|---|---|---|---|
| NSQK904340 | 11.04.2018 | DATAVARD | Insights 1802 IMP-001 InfoObject usage statistics |
Transport request need to be imported to central system and all satellite systems.
Improvement can be used for versions: 1708, 1711 and also for latest 1802 version.
Collection of statistics
Collection of free characteristics and key figures needs to be enabled to be able analyze them in future. Statistics can be enabled in following way:
Enter transaction /DVD/HM chose Statistics from menu bar and click on Manage DVD Stat.
In query statistics settings screen switch ON Key figures and free char, click on save button and confirm.
Statistics are not supporting for usage of structures in query execution.
Statistics are collected only when data are requested from database.
InfoObject usage characteristics statistics program
Simple report shows usage of free characteristics and key figure during query execution.
Report name: /DVD/HS_FREE_CHAR_USAGE
Transaction: /DVD/HS_FREECHAR
For further detailed analysis following view and table can be used.
View: /DVD/QS_QICHAR - used key fields and free characteristics
Table: /DVD/QS_QACHAR - all key field and characteristics in query
Parameters
| Parameter | Description |
|---|---|
| Date | analyzed time period |
| User Name | user name of user that executed query |
| Characteristic | free characteristics and key figures that should be included |
| Query | query selection |
| Show Query | display query name in results |
| Show Structure | Display element's structure |
| Show User name | display user name in results |
| Not used only | display characteristics and key figures which wasn't used |
Results
Over all characteristics statistics
Display InfoObject name, its type (C - free characteristic, K - key figure, L - local defined element) and it's usage in queries. Report also show from which time period data was analyzed.
Show query option
Display also Query name.
Show User name option
Display also user name option
