(DI-2208) BW User Behavior

Table of Contents:

Data size vs. query usage

The visualization shows the relationship between data access and the size of InfoProviders divided by time characteristic (in this case, year) in form of a scatter plot. It can show you how many times the data (of the corresponding year) of an InfoProvider were accessed in reporting. Visualization summarizes displayed information in tiles on the right-hand side. 

Data size vs. query usage scatter plot 


It is possible to select multiple objects and display only them in the chart.

Analysis area sub-selection


If you want to go back to the previous selection (scale) just click on the button or if you want to display all collected objects, click on the button. You can also filter all data. A table view is also available in the one-to-one form, which means objects you can see on the chart will be listed in a table form and ready to download into a CSV file for further processing.

Front-end usage

The visualization shows the usage of different front-ends. It shows you which front-ends are used and how many queries were executed via them, per some analyzed time period. 

Front-end usage analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

It is possible to click on the data in the plot area and you will be redirected to the other analysis called 'Query usage by country' with a used filter based on the chosen data. 
To distinguish between front-ends we are using handle type (field HANDLETP) of table RSDDSTAT_OLAP. Here is the list of possible front-ends that we are collecting:

Handle type

Front-end description

CMD

BeX Web Application

EXTN

External application (e.g. Analysis office, BOBJ, Crystal reports) all of them collected behind this tag

XLS

Excel (BEX analyzer)

MDX

OLAP BAPI (MDX, XML for Analysis, OLE DB for OLAP)

BICS

ABAP BICS API

W3_I, W3_T

Web templates

BTCH

Batch Query

PLAN

Planning

PLPE

Planning via Planning engine

We also provide a possibility to define your custom logic for separation of front-ends that are based on handle type and you can define it by the implementation of BADI "/DVD/HS_GET_QUERY_FRONTEND_USG".


Query usage by country

The visualization shows the usage of different queries from all over the world. It shows you from which countries queries were executed and how many times, per some analyzed period. 

Query usage by country analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

It is possible to click on the country in the map or in the bar chart and you will be redirected to the other analysis called 'Query usage by user group' with a used filter based on the chosen data.
Identification of the country is done by a company address assigned to the user that executed the query.

We are providing the possibility to implement custom logic of assignation user to a country by the implementation of BADI "/DVD/HS_CENTRAL_GET_QUERY_GRP". 


Query usage by user group

The visualization shows the usage of different queries according to user groups per some analyzed period. 

Query usage by user group analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

It is possible to click on the user group in the bar chart and you will be redirected to the other analysis called 'Query usage by query group' with a used filter based on the chosen data.
As default implementation for identification of a user group, "User group for authorization check" of the user is used. We are providing a possibility to implement custom logic of assignation user to a user group by the implementation of BADI "/DVD/HS_CENTRAL_GET_QUERY_GRP". 


Query usage by query group

The visualization shows the usage of different queries according to query groups per some analyzed period. 

Query usage by query group analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

It is possible to click on the user group in the bar chart and you will be redirected to the other analysis called 'Query top usage' with the used filter based on the chosen data.
Query group is read from an InfoArea which contains InfoProvider where queries were executed. We are providing a possibility to implement custom logic for identification of query group by the implementation of BADI "/DVD/HS_CENTRAL_GET_QUERY_GRP".

Query top usage

The visualization shows the most used queries per some analyzed period. 

Query top usage analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

It is possible to click on the query in the bar chart and you will be redirected to the other analysis called 'Query runtime single' with a used filter based on the chosen data.


Disused / Unused queries

The visualization shows disused and unused queries per some analyzed period. It shows the user queries which are not used anymore "disused" and those which were not used at all "unused". 

Disused queries analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

You can switch between disused and unused analyses. Unused queries are displayed as a list. 

Unused queries analysis list


Data can be downloaded into a CSV file for further processing.

InfoProvider usage

The visualization shows reporting usage (query executions) of InfoProviders in the analyzed time period. 

InfoProvider usage analysis chart


You can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.