BiWhy – CMS DB Analysis

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.

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 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:

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

#SAP

#SAPTechnologyblog