All SAP BusinessObjects environments vary greatly in how they are deployed. The type of BI assets that SAP BusinessObjects suite manages and the users who perform query and reporting against it. MetaMiner is optimized to work out-of-the-box on the vast majority of environments, large and small. Still, there are certain system requirements that must be in place to ensure a well-performing installation of MetaMiner.
Infolytik uses the queries below (for both XI 3.x and BI 4.x installations we understand that some objects no longer appear in the latter one) to gauge the volume and density of your SAP BusinessObjects CMS repository.
To determine your minimum system requirements to run MetaMiner:
| 1. | Log in to your SAP BusinessObjects suite as a Administrator. |
| 2. | Open the largest CMS environment in your landscape. |
| 3. | Open the SAP Query Builder tool. |
| 4. | Run the following test SQL queries - each of them measures the number of some BI assets in your environment: |
Web Intelligence Reports
SELECT count(SI_ID) from ci_infoobjects where SI_KIND = 'Webi' and SI_INSTANCE = 0
Instances
SELECT count(SI_ID) from ci_infoobjects, ci_appobjects, ci_systemobjects where SI_INSTANCE = 1
and SI_KIND in ('Publication', 'ObjectPackage', 'Powerpoint', 'DataDiscoveryAlbum','DataDiscovery','Dashboards',
'Pdf','Txt','Excel','Word','Flash','Webi','FullClient','CrystalReport','Shortcut','Publication','XL.Query',
'Agnostic','AFDashboardPage','MyInfoView','Xcelsius')
Users and groups
SELECT count(SI_ID) from ci_infoobjects, ci_appobjects, ci_systemobjects where si_kind IN ('User','UserGroup')
| 5. | Save the results of your SQL queries, write down number of users, instances, and other BI assets found in your environment. |
| 6. | Compare determined figures to values in the following table: |
Parameters |
Figures |
|||
|---|---|---|---|---|
1 000-4 999 reports 5 000-19 999 instances 100-999 users and groups |
5 000-9 999 reports 20 000-49 999 instances 1 000-2 499 users and groups |
10 000-19 999 reports 50 000-199 999 instances 2 500-4 999 users and groups |
20 000+ reports 200 000+ instances 5 000+ users and groups |
|
Project size |
Small |
Medium |
Large |
Extra Large |
RAM dedicated to MetaMiner Server JVM |
768MB |
1GB |
2GB |
3GB |
# of cores or CPUnits |
2 |
2 |
4 |
4+ |
HDD free space allocated for MetaMiner Database (MMDB) |
10GB |
15GB |
20GB |
35GB |
| 7. | Find a column in this table that contains figures that are as much close to the figures previously determined. |
| 8. | Determine recommended RAM, CPU, and HDD parameters, and proceed to general hardware/software/network/database requirements. |
| 9. | You may want to run additional SQL queries to collect more statistics about your environment(s): |
Desktop Intelligence Documents
SELECT count(SI_ID) from ci_infoobjects where SI_KIND = 'FullClient' and SI_INSTANCE = 0
Crystal Reports Documents
SELECT count(SI_ID) from ci_infoobjects where SI_KIND = 'CrystalReport' and SI_INSTANCE = 0
Semantic Layers
SELECT count(SI_ID) from ci_appobjects where SI_KIND = 'Universe' and SI_INSTANCE = 0
Base Documents
SELECT count(SI_ID) from ci_infoobjects, ci_appobjects, ci_systemobjects where SI_INSTANCE = 0
and SI_KIND in ('Publication', 'ObjectPackage', 'Powerpoint', 'DataDiscoveryAlbum','DataDiscovery','Dashboards',
'Pdf','Txt','Excel','Word','Flash','Webi','FullClient','CrystalReport','Shortcut','Publication','XL.Query','Agnostic',
'AFDashboardPage','MyInfoView','Xcelsius')
Folders
SELECT count(SI_ID) from ci_infoobjects, ci_appobjects where si_kind IN ('FavoritesFolder', 'Folder', 'Inbox', 'Category')
CMS Sparseness
SELECT TOP 1 SI_ID from ci_infoobjects, ci_appobjects, ci_systemobjects order by SI_ID DESC
See also
Adjusting Allocated Memory Settings