This article provides a summary of the high level steps involved with building a SAP BI 4 Demo System and provides guidance on hardware and software requirements and links to where software can be downloaded from. The Demo System will host SAP Business Objects 4.0 and SAP Data Services 4.0
A common issue found when starting SAP Business Objects BI4 is that the system cannot logon to the CMS database repository. Troubleshooting this can be tricky but the following command can be used on a Linux deployment to check connectivity to an Oracle database and capture error messages in a log file,
/opt/sapboe/sap_bobj/ccm.sh -isdbempty -dbdriver "oracledatabasesubsystem" -connect "DSN=<tnsname>;UID=<username>;PWD=<password>" -logfile logfile.out
where <tnsname>, <username> and <password> are the appropriate Oracle logon credentials for the database.
What this command actually does is to check that the target database is or is not an empty database schema. However if there is a database connection error then this will be captured in the logfile.out and from there we can troubleshoot connection issues.
For a while I have been saying to everyone I know that Crystal Reports is more efficient at processing reports than Web Intelligence but I have never had any concrete proof. So I decided to set myself a small project that compares Web Intelligence document to the same report created in Crystal Reports. And the result of that project is Boest – a Java application that can be used for stress testing an SAP BusinessObjects Enterprise installation.
I’ve decided to make this application open source so that others can either just it to test their own systems or even contribute to extending it further to provide more functionality. This application can be downloaded from SourceForge.net.
When deploying an SAP BusinessObjects Enterprise system there are a lot of choices for where you can deploy all the services that make up the system. It is then necessary to make sure that you choose the right deployment in order to meet your requirements, for example, is it easily maintained, is it resilient, is it secure, will it support my user base and can it be easily expanded to accomodate additional users.
This article looks at different deployment patterns for an SAP BusinessObjects Enterprise XI3 system and reviews their advantages and limitations of each. It is the intention then that this can help you make an informed decision about the deployment configuration of your system.
The article focuses on the core SAP BusinessObjects Enterprise servers and does not include Data Services or Performance Management.