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

Browser not supported