Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BO Analysis for Excel – How to connect to SAP BW

Hi Gurus,

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?

Regards,

Reynir

Former Member
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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question