How to find the <hostname> when trying to connect to BI Universe from Power Query

[Former Member]

I did a search and found "Microsoft Power Query Connectivity to SAP BusinessObjects Universes - HOW TO" in the Semantic Layer discussion forum.

We are using Business Objects Web Intelligence which is provided to us by a vendor as a reporting solution for their application, so I do not have access to the backend besides CMC. I want the ability to connect to SAP from excel and can't seem to figure out the host IP address (http://<host>:6405/biprws). Is the host address something that can be looked up in CMC?

Thank you,

Ahmed

[amitrathi239]

Hi

Host name is the BO server name or IP address.according to this url Port 6405 need be open from your BO server to your client network,

Amit