Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member182521
Active Contributor

BusinessObjects environment assessment is one of the critical steps whenever you go for migration or an upgrade. Identifying the existing objects in current deployment and cleaning up the unnecessary and unused objects will help you to design and size your system properly with optimal performance. In this document I want to show simple steps to estimate BI contents using Query builder.

Have a look here BusinessObjects Query builder - Basics  for Query builder basics. You should fire the below environment assessment queries in Querybuilder.

1. Estimating User Community

User count

          SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USER'

Named user count

          SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USER' AND SI_NAMEDUSER=1

Concurrent user count

            SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USER' AND SI_NAMEDUSER=0

User group count

            SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USERGROUP'

2. Estimating BI Content

Universe count

           SELECT COUNT (SI_ID) FROM CI_APPOBJECTS WHERE SI_KIND = 'UNIVERSE'

Connection count

            SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'CONNECTION'

Count of crystal reports

            SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'CRYSTALREPORT'

Count of Full client reports

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'FULLCLIENT'

Count of WebI reports & Instances

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'WEBI'

Count of WebI reports (Only report templates)

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'WEBI' AND SI_INSTANCE=0

Count of WebI report instances

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'WEBI' AND SI_INSTANCE=1

Count of Folders

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS, CI_APPOBJECTS, CI_SYSTEMOBJECTS WHERE SI_KIND = 'FOLDER'

     * Please note I have included all three virtual tables for the folder count as it may exist in all the categories

Count of Categories

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'CATEGORY'

Count of Program Objects

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'PROGRAM'

Count of Shortcuts

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'SHORTCUT'

Count of Agonistic documents

           SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND IN ('EXCEL','PDF','WORD','RTF','TXT','POWERPOINT')

Count of Calenders

           SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'CALENDAR'

Count of Events

          SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'EVENT'

Count of Hyperlinks

          SELECT COUNT (SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND = 'HYPERLINK'

3. Estimating Servers/Server groups and metrics

Server count

            SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'SERVER'

Server group count

           SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'SERVERGROUP'

Server metrics

           SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'SERVER'

At the end of the assessment you should be able to provide the below matrix

Parameters of Assessmentvalue
Users
Named users
Concurrent users
User groups
Universes
Connections
Crystal reports
Full client reports
WebI report
WebI report templates
WebI report instances
Folders
Program Objects
Categories
Shortcuts
Calenders
Events
Agonistic documents
Servers
Server groups
Hyperlinks

Query Builder Blog series

Basics

             BusinessObjects Query builder - Basics

               BusinessObjects Query builder – Best practices & Usability

Sample Queries

             BusinessObjects Query builder queries

               BusinessObjects Query builder queries - Part II

               BusinessObjects Query builder queries - Part III

               BusinessObjects Query builder queries - Part IV

               BusinessObjects Query builder – Exploring Visualization Objects

              BusinessObjects Query builder – Exploring Monitoring Objects

              BusinessObjects Query builder - Exploring Lumira & Design studio Objects


Use cases

               BusinessObjects Environment assessment using Query builder

               BusinessObjects Environment Cleanup using Query builder

               BusinessObjects Query builder – What's New in BI 4.0   

30 Comments
Labels in this area