BiWhy was conceived as comprehensive support tool for SAP BusinessObjects (BOBJ) to troubleshoot issues and facilitate administrative tasks, but as about half of its functionality is not directly tied to BOBJ, it can be used to troubleshoot and monitor other products. That makes it a General-Purpose Support Tool, with the goal of including functionality most demanded by support engineers and software administrators.
BiWhy is currently available exclusively through CoE Max Attention Engagements.
What it is for:
Analyse CMS DB:
Understand your system usage.
Identify what is causing growth (count or size-wise).
See what is retained over time.
Analyze time trends.
Compare two snapshots to identify differences and common parts:
Between target and source systems to verify promotion.
For the same system to see what has changed.
When to run it:
Occasionally, to get an impression of what is happening in the system and for housekeeping purposes.
NB: Before migration or major promotions, it is a good idea to clean up the CMS DB to speed up promotion and reduce the number of failures.
Background
This functionality has already been used with more than 38 customers, in some cases repeatedly and across multiple systems.
The largest CMS DB processed contained 34 million objects.
CMS DB fetch is optimized with indexed fields, filters, self-tuning batch size, and incremental fetch options.
Analysis & Visualization with BiWhy Embedded Analytic Controls
Flexible table:
Show/hide columns
Group/aggregate
Regex filters for any column
Global and local statistics
Export to Excel
Set of charts
CMS DB tree:
Build by folders or parents
Choose how to view a node (show/hide any available field)
Sort by selected field
Search
Screenshots:
Table overview (grouped by kind, sorted by file size):
Just another table view – one of many:
Time-buckets chart:
Time-buckets chart – another view:
Tree view:
Disclaimer: BiWhy was conceived as comprehensive support tool for SAP BusinessObjects (BOBJ) to troubleshoot issues and facilitate administrative tasks, but as about half of its functionality is not directly tied to BOBJ, it can be used to troubleshoot and monitor other products. That makes it a General-Purpose Support Tool, with the goal of including functionality most demanded by support engineers and software administrators. BiWhy is currently available exclusively through CoE Max Attention Engagements. What it is for:Analyse CMS DB:Understand your system usage.Identify what is causing growth (count or size-wise).See what is retained over time.Analyze time trends. Compare two snapshots to identify differences and common parts:Between target and source systems to verify promotion.For the same system to see what has changed. When to run it:Occasionally, to get an impression of what is happening in the system and for housekeeping purposes.NB: Before migration or major promotions, it is a good idea to clean up the CMS DB to speed up promotion and reduce the number of failures. BackgroundThis functionality has already been used with more than 38 customers, in some cases repeatedly and across multiple systems.The largest CMS DB processed contained 34 million objects.CMS DB fetch is optimized with indexed fields, filters, self-tuning batch size, and incremental fetch options. Analysis & Visualization with BiWhy Embedded Analytic ControlsFlexible table:Show/hide columnsGroup/aggregateRegex filters for any columnGlobal and local statisticsExport to ExcelSet of chartsCMS DB tree:Build by folders or parentsChoose how to view a node (show/hide any available field)Sort by selected fieldSearch Screenshots: Table overview (grouped by kind, sorted by file size): Just another table view – one of many: Time-buckets chart: Time-buckets chart – another view: Tree view: Read More Technology Blog Posts by SAP articles
