on 09-16-2014 10:13 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
Hi guys, does anyone have the VBA code to automate the logon as in this picture? Cheers! Lucien
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Alternatively you can skip that to see a list of available BW sources and connect directly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.