| Table of Contents |
|---|
Busy and quiet times of queries and DTPs
The analysis provides an overview of busy and quiet times of queries and DTP loads which were executed on all InfoProviders on a monitored system. The heatmap shows a total number of queries, DTPs or their sum. You can switch it with buttons Combined (Query & DTP), DTP or Query. Data is aggregated by weekdays and hours and it can be filtered by specific InfoProvider or by analyzed period. This analysis can help you to find quiet hours e.g. for operations which need more system resources. Also the busiest hours can be examined and their content can be split into other less busy hours.
Busy and quiet times of queries and DTP analysis chart
InfoProviders size
The analysis provides an overview of all InfoProviders in the system divided into 3 categories. Each category represents size of InfoProviders that correspond to a particular group. E.g. "10%" group represent first 10% largest InfoProviders and their corresponding size. By clicking on a bar, application will be redirected to "Top InfoProviders" analysis, where "Top %" filter will be applied accordingly.
InfoProviders size analysis chart
...
You can switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.
InfoProviders by year
This analysis provides an overview of InfoProviders in the system. Two charts are displayed here:
- Distribution by InfoProvider type - displays whole system per InfoProvider type
- InfoProviders - objects in the chart are sorted by size by default and can be further filtered
Both charts always display last 4 years + all others merged into other group (e.g. 2013 and lower) based on amount of InfoProvider data that belong to the group.
InfoProviders by year 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 switch color mode of bottom chart to "Query usage". This colorizing mode groups data in InfoProvider by their respecting reporting usage. All data that were reported on less than 10 times are colorized with blue color and all data reported on more than 1000 times are colorized with red color. Warm data colorized with orange color belong to the category between these two threshold values.
InfoProviders by query usage analysis chart
You can change these threshold values by clicking on the 
button.
NLS potential
Based on the analysis performed in the system, the visualization provides you with an overview on the potentials for archiving of particular object types (such as InfoCubes, DataStore objects, Write-Optimized DSOs) in form of column charts.
NLS potential analysis chart
You have the possibility to change archiving settings.The analysis recalculates the archiving potential accordingly by the
button .
NLS potential analysis settings
...
Table view provides a detailed archiving potential on object level. You can download data into a CSV file for further processing.
NLS potential analysis table view
...
These analyses provide information about how data is distributed in InfoProviders based on a specified characteristic and based on how many times these data areas were accessed by reporting (queries). The number of Data distribution analysis tiles depends on the settings on the central system. By default the BW analysis is delivered with only one predefined Data distribution analysis. The Data distribution analysis tile displays the number of analyzed InfoProviders which contain the specified characteristic. The below figure displays temperature based data categorization which is a type of data distribution and is by default included in the package.
Data distribution tile
...
| Column | Description |
|---|---|
| Object | contains technical name of an InfoProvider |
| Type | displays a type of an InfoProvider (InfoCube, DSO, aDSO, WODS) |
| Description | long description of an InfoProvider |
| Size [MB] | total object size in MB
table size calculation differs by various database types
|
| Rows | number of rows in InfoProvider data tables (same tables are used as in the size calculation) |
| Number of queries | the total number of queries that read data in an InfoProvider
|
| Trend - Number of queries | visualization displaying the usage of data areas - values are rounded to natural numbers |
| Trend - Size [MB] | visualization displaying the size of data areas - values are rounded to natural numbers |
| Split characteristic | describes applied time characteristic
|
| Archived size [MB] | size of unpacked archived data in MB
|
| DTP source count | how many times an InfoProvider is used as a source in DTP load requests |
| Last DTP exec. | timestamp of the last DTP load request execution |
| DTP dest. count | number of DTP requests loaded into an InfoProvider (including reloaded requests from an archive) |
| DTP dest. relv | number of requests (DTPs for InfoCubes, activation requests for DSOs) relevant for straggler analysis
|
| DTP stragglers | number of requests with straggler records (see more details)
|
| DTP stragg. rows | number of rows which represent straggler records |
| Number of lookups | number of lookups that are present in a system for an InfoProvider
|
Data distribution analysis standard view
...
You can filter the content of a table column by clicking on the column header. There is also a possibility to download the table content (without chart columns) into a csv. file by clicking on 
toolbar button. You can also hide/show specific column groups by clicking on column group
in View options toolbar. You can sort results based on field of your preference, by clicking again on column header:
Sorting and filtering directly according to the column header
You can click on any InfoProvider line to display queries that were executed on the InfoProvider. Each line in this detail view contains a query that was executed with a filter selection that was used during its execution (only filters for the same characteristic as was used for data distribution are displayed).
InfoProvider query execution details
...