On the Reporting data mart page, you can enter a URL to connect to the OLAP cube over HTTP. This allows your local OLAP client to connect to a remote OLAP server. Under Configuration, click Edit HTTP data source url. In the Url field, enter the address to connect to Analysis Services. Click Save. You return to the Reporting data mart page.
With this URL, an OLAP client such as Microsoft Excel can access OLAP data over the Internet. This is useful to run a local copy of Excel against a remote OLAP server. You can configure the web server to proxy the MDX commands from Excel or any other OLAP client, and the OLAP Excel Reports feature will use the URL you supply in the connection string in place of the OLAP server name.