cancel
Showing results for 
Search instead for 
Did you mean: 

BO Analysis for Excel – How to connect to SAP BW

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Yes you need to define an OLAP connection of you are connecting to BW through the BIP - see tutorial http://scn.sap.com/docs/DOC-20625

You can also connect directly to BW without going through BIP

I also recommend searching before you post per SCN rules - there are many posts about creating OLAP connections

Tammy

Former Member
0 Kudos

Hi,

Thanks for your answers, but you are misunderstanding the question.  But I see now better where the problem is.

I have created an OLAP connection no problem there.  But I can not log on to the BO server to see my OLAP connections. The Web Service URL does come blank, and I am stuck on that screen.

My Basis people do not know what the URL is or how it should look like.

How do I find the “Web Service URL”?

Regards,

Reynir

TammyPowlas
Active Contributor
0 Kudos

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.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi guys, does anyone have the VBA code to automate the logon as in this picture? Cheers! Lucien

Former Member
0 Kudos

Alternatively you can skip that to see a list of available BW sources and connect directly.

former_member110741
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Reynir Thorarinsson,

Connect to BO Server  ? - Yes it is possible

OLAP Connection in  to connect BW in Analysis Office -Yes it is possible

Check the document

http://scn.sap.com/docs/DOC-20625

Regards,

Subhash