Data size vs. query usage

The visualization shows the relationship between data access and size of InfoProviders divided by time characteristic (in this case, year) in form of a scatter plot. It can show user how many times were data (of corresponding year) of an InfoProvider accessed in reporting. Visualization summarizes displayed information in tiles on 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 previous selection (scale) just click on the button or if you want to display all collected objects click on the button. The user can also filter data. Table view is also available in one to one form, that means objects that you can see on chart will be listed in table form and ready to download into a CSV file for further processing.

Front-end usage

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

_{Front-end usage analysis chart}

The user 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 user will be redirected to the other analysis called 'Query usage by country' with 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, but all is 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 provide also possibility to define your custom logic for separation of front-ends that is based on handle type and you can define it by implementation of BADI "/DVD/HS_GET_QUERY_FRONTEND_USG".

Query usage by country

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

_{Query usage by country analysis chart}

The user 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 user will be redirected to the other analysis called 'Query usage by user group' with used filter based on the chosen data.
Identification of country is done by company address assigned to user that executed query.

We are providing possibility to implement custom logic of assignation user to country by 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 analysed period.

_{Query usage by user group analysis chart}

The user 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 user will be redirected to the other analysis called 'Query usage by query group' with used filter based on the chosen data.
As default implementation for identification of user group, "User group for authorization check" of user is used. We are providing possibility to implement custom logic of assignation user to user group by 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 analysed period.

_{Query usage by query group analysis chart}

The user 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 user will be redirected to the other analysis called 'Query top usage' with used filter based on the chosen data.
Query group is read from InfoArea which contains InfoProvider where queries were executed. We are providing possibility to implement custom logic for identification of query group by implementation of BADI "/DVD/HS_CENTRAL_GET_QUERY_GRP".

Query top usage

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

_{Query top usage analysis chart}

The user 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 user will be redirected to the other analysis called 'Query runtime single' with used filter based on the chosen data.

Disused / Unused queries

The visualization shows disused and unused queries per some analysed 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}

The user 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.

The user can switch between disused and unused analyses using appropriate radio buttons. 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 analysed time period.

_{InfoProvider usage analysis chart}

The user 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.

Browser not supported