Holistic Basis View: BusinessObjects BI 4.0 SP 2 Installation & Configuration

Those who wish to install and configure SAP BusinessObjects Business Intelligence platform 4.0 Support Package 2 or other versions, some basic questions come to their mind like

Question 1 : Will there be any separate SID for BObj?

Question 2 : Will it have its separate Database?

Question 3 : Will it be installed like normal SAP systems with sapinst?

➕ Even if you know answers, but you want to understand the installation flow or you need bit more detail on deployment process…

My intention is to cover these points right here in this blog.

ℹ Simultaneously I am also assuming that readers will or already gone through the latest installation guide as well.

Question 1 : Will there be any separate SID for BObj?

It will not like SAP SID but you have to give name to the Node example is in above figure.

Question 2 : Will it have its separate Database?

Yes, you need an already install database and you need to create 2 schema and tablespace for data and temporary tablespace for each schema. BObj installation will not install any database on its own but it will ask you to connect with existing one.

Question 3 : Will it be installed like normal SAP systems with sapinst?

No, The installation will not be done through sapinst, it will be done through script in Unix, Its more like brtools or if you done ccms agent registration from OS where it provide you text based menu/options and you input your options. For windows there will be wizard which will ask for same set of menu/options, like normal software installation in windows.

By looking at above figure, one more question may arise:

Question 4 : Lets say if we use NetWeaver Java then where we need to create the User IDfor BObj?

The WebServer Tomcat or NetWeaver Java will only be used to host the interface or as frontend. All the User ID and password will be created inside BObj Box…. in default scenario like below where authentication is “Enterprise”. Here SAP can be selected also but in that case we need to create alias for each User ID and that will be searched. We will discuss it further after end of installation phase.

Installation flow:

Oracle Database preparation

You need to prepare one pre-installed Oracle database. You can use your existing oracle database used for any of your SAP system, there we need to create two schemas and their tablespaces. Do not worry about space needed for these extra tablespaces, The size of tablespaces after my installation was not more than 30MB each. But please select that DB where you can afford much more space than that.

Lets see how to do it.

For the simplicity of this blog, lets decide the name of those two schema names orabo4 and audbo4.

Create a orabo4 tablespace and a temporary tablespace bo4temp

Now create schema user orabo4 and grant it access like below.

We can check if it is working fine or not like below

Similarly we will create tablespace bo4aud, temporary tablespace audtemp and a schema user bo4aud.

Note: There is no restriction on selecting the schema name tablespace name but for some unknown reason, I try to keep it like SAP naming conventions.

When this is done, we are good to go for next step

Business Object Installation

To keep this blog short, I have kept the screenshots for installation phase in below locations. Please follow the link to view the step by step screenshots.

When you go through the screenshots, specially watch out for these 3 screens.

1. BObj Node name
2. How to connect with oracle
3. There was an oracle error & its simple solution

Create an OS User for Admin, in our case we have got bobadm user, login with this ID and start script as shown in below links.

Screenshots : BusinessObjects BI 4.0 SP 2 Installation part-1

Screenshots : BusinessObjects BI 4.0 SP 2 Installation part-2

Business Object deploy-able files generation

Now the installation of BObj is done, its time to deploy these installed components on WebServer or NetWeaver Java, in this example we have used NetWeaver Java so we will proceed with this in this blog.

To do this first we have to create deploy-able files on the server where we have installed the BObj.

When we will get those files then we will move them on the server where our NetWeaver Java is installed.

If you have noticed last two screens of installation it tells the path from where we have to start the wdeploy.sh script in our case it is.

/usr/sap/BOB/sap_bobj/enterprise_xi40/wdeploy

Login with bobadm on BObj server, goto the specified location of wdeploy.sh and check installed component with the command

./wdeploy.sh sapappsvr73 listapps

Here sapappsvr73 is parameter because we are going to use NetWeaver7.3, detail you can get in Installation guide

It will provide details of all the installed components.

With this command it will create deploy-able files

./wdeploy.sh sapappsvr73 predeployall

For me it took around 12 minutes to generate those files.

if you will watch the screen you will find the location where files were getting created, which was at location

/usr/sap/BOB/sap_bobj/enterprise_xi40/wdeploy/workdir/sapappsvr73/application/

Business Object deployment on NetWeaver Java

Copied the directory /usr/sap/BOB/sap_bobj/enterprise_xi40/wdeploy present on BObj Server.

to my NetWeaver AS Java lets say its SID is NW3

/usr/sap/NW3/sap_bobj/enterprise_xi40/wdeploy

This means I created sap_bobj/enterprise_xi40 directory inside /usr/sap/<SID> and copied entire content of wdeploy directory there.

Login with nw3adm user at OS level and goto location /usr/sap/NW3/sap_bobj/enterprise_xi40/wdeploy

We also require Web application server administrative account password, lets say its T3ch#312 then execute below command

./wdeploy.sh sapappsvr73 -Das_admin_password=T3ch#312 deployonlyall

This will deploy all the components for NetWeaver AS Java.

But if your system is NW7.3 then it will not succeed for all components. You need to copy the .sca file present at location

sap_bobj/enterprise_xi40/wdeploy/workdir/sapappsvr73/application/

and copy them to inbox of Trans directory /usr/sap/trans/EPS/in/

Set your display and start JSPM, select this option

and proceed next

This way you can deploy your remaining components.

Now you are ready to go with these two links.

http://<hostname>:5<nn>00/BOE/CMC

http://<hostname>:5<nn>00/BOE/BI

After login to CMC you can get screen like below which will open door for you to configure.

From this screen click on “OLAP Connection” and create new connection to any SAP BW system.

By clicking on Authenticatin you can select the type of authentication is needed

By selecting SAP you can also import users and roles from SAP system as well.

This was the brief overview for BObj BW 4.0. Hope it will give some idea to those who have never worked with BObj earlier.

My other Blogs, if you have time…

What’s new in SAP NetWeaver 7.3 – A Basis perspective Part-I

What’s new in SAP NetWeaver 7.3 – A Basis perspective Part-II

Bye bye STRUSTSSO2: New Central Certificate Administration NW7.3

Multiple/Bulk transports with tp script for Unix (AIX, Solaris, HP-UX, Linux)

Holistic Basis View: BusinessObjects BI 4.0 SP 2 Installation & Configuration

How to Rename the Oracle Listener & Change Listener port for SAP

OSS1 & RFC connections SAPOSS, SAPNET_RFC, SDCC_OSS

Interrelation: SAP work process, OPS$ mechanism, oracle client & oracle shadow process

Install and configure NetWeaver PI 7.3 Decentralize Adapter part-1

Install and configure NetWeaver PI 7.3 Decentralize Adapter part-2

List of Newly added/converted Dynamic parameter in NetWeaver 7.3