Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

IMPROVEMENT ARCHIVE

Description: Insights 1802 IMP-001 InfoObject usage statistics

https://mats.datavard.com/downloader.php?ticketid=d700530da2dfed09c6f2ac8c89edf2da

Password: Datavard1

Transports requests

RequestDateOwnerShort Text
NSQK90434011.04.2018DATAVARDInsights 1802 IMP-001 InfoObject usage statistics

...

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:

...

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. 

...

Table: /DVD/QS_QACHAR - all key field and characteristics in query

Parameters

ParameterDescription
Dateanalyzed time period
User Nameuser name of user that executed query
Characteristicfree characteristics and key figures that should be included
Queryquery selection
Show Querydisplay query name in results 
Show StructureDisplay element's structure
Show User namedisplay user name in results
Not used onlydisplay 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

...