BO Analysis for Excel – How to connect to SAP BW
We recently upgrade to BO 4.1 (from 3.1). And want to start to use Analysis for Excel.
We are little unclear how to connect from Analysis for Excel to SAP BW 7,3.
From Analysis select “Select Data Source” Then get a pop-up “Logon to SAP BussinessObjects BI Platform” with User, Password and Web Service URL. All those are blank. For the Web Service URL there is a message “Error while checking availability of SAP BussinessObjects BI Platform system”
If choose “Skip” then get SAP Logonpad and can log on to BW. From there I can choose the BW queries directly.
What is the best practice to connect from Analysis for Excel to SAP BW?
Is it not possible to connect to the BO server? And choose OLAP connection from there to connect to BW?
If so, is something missing in our setup?
Tammy Powlas replied
Your Web Service URL is typically http://yourcmsname:8080/dswsbobje/services/Session
You need to replace "yourcmsname" with whatever the BI admin named your CMS; your Basis team or BI admin should have this information.