My plan is to connect Excel to an SAP BW, but it's not working.
I installed SAP GUI 7.10 and using the SAP Login I can access the system, so the credentials are correct.
in the settings dialog of the OLE DB provider I tried all combinations I could think of:
as data source string: 1.the ip of the system 2. the same name as the connection entry in the SAP Login 3. the url 4.system ID and so on,
the same for the location string.
But all I get is an empty error window, cklicking on details shows this:
and nothing else.
We need to get this up and running, so does anybody have a hint what else I could try ?