Configuring Data Analysis Views in an extranet configuration (updated)

  • Article

You want to configure Data analysis Views in an extranet configuration. Here are the steps I did:

  • Configure HTTP access to SSAS following the description given here: https://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx 
  • This installation needs to done on the web server, configure http and/or https. Assume the server name is mywebserver.contoso.com and the virtual directory name is olap
  • The virtual directory is configured using Integrated Windows Configuration
  • In your Data Analysis views: Select Custom Server and enter the following extranet http address: https://mywebserver.contoso.com/olap/msmdpump.dll
  • This will complete the data source information in the command and options dialog box of the OWC.
  • Or you can put the http address directly in the data source tab in the command and options dialog box replacing the analysis server name.
    This new connection string should look like
    Provider=MSOLAP;Data Source=https://mywebserver.contoso.com/olap/msmdpump.dll;Initial Catalog=MY_OLAPDB;Client Cache Size=25;Auto Synch Period=10000
    instead of
    Provider=MSOLAP;Data Source=ANALYSISSERVERNAME;Initial Catalog=MY_OLAPDB;Client Cache Size=25;Auto Synch Period=10000

See the attachment for a screen shot of the configuration

If you have extranet users, it is also important to note that Office Web Components require port 2725 or 2383 to allow a direct connection to SQL Server Analysis Services. Even though access is enabled over port 80 via HTTPS, if port 2725 or 2383 is not available, the dynamic OLAP reports will not be able to access the Analysis Services data.

You need to open port 2383 (assuming the default instance of Sql Server Analysis services 2005 is used)

You need to open port 2725 if Analysis Services 2000 is used.

EditDataView-HTTP-OLAP.jpg

Comments

  • Anonymous
    August 30, 2007
    The comment has been removed

  • Anonymous
    August 30, 2007
    The comment has been removed

  • Anonymous
    September 01, 2007
    The comment has been removed

  • Anonymous
    September 05, 2007
    Hi Sergio, You only see the Command tab, when you are editing the data view in PWAManage views. To avoid adding manually the URL. Put the URL in the custom server/Extranet Address (do not fill server name) Steven

  • Anonymous
    January 11, 2011
    Hi Steven Thanks for this post; you save me