This was my input:
Data > Import External Data > New Database Query > OLAP Cubes > New Data Source
Using Microsoft OLE DB Provider for OLAP Services 8.0 to connect to a HTTP server (Analysis server)
This was the outcome:
Unable to open connection. A connection with the server cannot be established.
Pls help me.