Connecting to Microsoft Analysis Services Over the Internet David Botzenhart Support Professional PS

1
Connecting to Microsoft Analysis Services Over
the Internet David Botzenhart Support
ProfessionalPSS Analysis ServicesMicrosoft
Corporation
2
Contents

• Introduction
• Requirements
• Architecture
• Setup and configuration
• Security considerations
• Connection string
• Troubleshooting

3
Introduction

• Fat client vs. thin client
• Pivot Table Services versus XML for analysis
• Microsoft Analysis Services security
  requirements
• Windows authentication
• HTTP connection
• Internet Information Services (IIS) validation

4
Requirements

• Microsoft Analysis Services Enterprise Edition
• IIS and Microsoft Analysis Services installed on
  the same machine
• Pivot Table Services (PTS) version 8.0 installed
  on client machine

5
Architecture
Firewall or Proxy Server
IIS Web Server
HTTP / HTTPS
Analysis Server
Client Side Cache
OLAP Data
6
Setup and Configuration

• MSOLAP.asp
• Move to WWW Root of IIS
• MSMDPUMP.dll
• IIS directory security
• Install of PTS version 8.0 on clients
• PTSFULL.exe or PTSLITE.exe

7
Security Considerations
8
Connection String

• Add to data source path to MSOLAP.asp
• ProviderMSOLAP
• Data SourceHTTP//myserver/directory
• User IDJohn Smith
• PasswordPocahontas
• Initial CatalogFoodmart 2000

9
Troubleshooting

• Test connection to MSOLAP.asp from Internet
  Explorer
• http//myserver/MSOLAP.ASP
• Use Anonymous Security in IIS
• Test connection from MDX Sample Application

10
MDX Sample Application
11
Performance Issue

• Using slow connections
• Large Level Threshold10
• Execution Location3Default Isolation Mode1
• Dimension Keys Unique
• MDX Compatibility2

12

• Thank you for joining us for todays Microsoft
  Support
• WebCast.
• For information about all upcoming Support
  WebCasts
• and access to the archived content (streaming
  media
• files, PowerPoint slides, and transcripts),
  please visit
• http//support.microsoft.com/webcasts/
• We sincerely appreciate your feedback. Please
  send any
• comments or suggestions regarding the Support
• WebCasts to feedback_at_microsoft.com and include
• Support WebCasts in the subject line.