Edit HTTP Data Source URL
On the Reporting data warehouse 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, select Edit HTTP data source url. In the Url field, enter the address to connect to Analysis Services. Select Save. You return to the Reporting data warehouse 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.
Note: This option is only available for clients who install Blackbaud CRM on premise. For hosted clients, Blackbaud does not support the Analysis Services configuration that is necessary to connect to the OLAP cube over HTTP.