SAP BusinessObjects BO Dashboards – How to bypass Microsoft Office prerequisite?

In one of Clariba’s customer projects we had to install SAP BusinessObjects BO Dashboards 4.1 on top of Microsoft Office 64 bit version. Now, the 64 bit version is not supported by the tool based on Product Availability Matrix (page 14) so the setup will fail, but there are still ways to install it.

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-1.png

Message when trying to install it.

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-2.png

Please find below 2 methods in order to bypass this prerequisite.

Method 1 – Adding a new fake key in registry (applies for any tool which require Microsoft Office 32 bit version)

The way the Setup.exe is checking for the required Microsoft Office version is by looking into registry. If you add the key in the registry which the Setup.exe is searching for then the prerequisite will have a Succeeded status and you will be able to continue your installation.

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-3.png

The same logic is followed by almost any Setup which have Microsoft Office as prerequisite so let’s take a look on how we can create that key in registry.

1. Manual

Go to C:\Windows and open  Regedit.exe   

Navigate to HKEY_LOCAL_MACHINE->SOFTWARE->Wow6432Node->Microsoft->Office

Right Click on Office and pick New->Key.

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-5.png

Name it 10.0 and repeat New->Key until you have Office->10.0->Excel->InstallRoot structure and then right click on InstallRoot->New->String Value

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-6.png

Name it a path and set the value to:

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-6.png

2. Create a .reg file

Create a new Text file with the following text:

Windows Registry Editor Version 5.00

 [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\10.0\Excel\InstallRoot]

"Path"="C:\\Program Files (x86)\\Microsoft Office\\Office14\\"

Save it as fakeKey.reg 

Run it:

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-7.png

After pressing Yes you will get the following message:

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-8.png

Method 2 – Editing Setup files (applies for SAP BO Dashboards only)

Setup.exe is using several files when executing and the file which checks the Prerequisites is one of them. You can find it in DATA_UNITS\Xcelsius\dunit\product.xcelsius-4.0-core-32\ by the name of product.seed.xml

There are different ways of get rid of this prerequisite by editing the file so here is the one I consider the easiest one.

Open product.seed.xml with a text editor (Notepad) and go to 72 line:

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-9.png

Remove  TYPE ERROR  and save the file then rerun Setup.exe

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-10 .png

This way the Microsoft Office requirement will be Optional so the Setup won’t fail anymore.

SAP-BO-Dashboards-bypass-Microsoft-Office-prerequisite-11.png