Page 151 - DCAP606_BUSINESS_INTELLIGENCE
P. 151
Business Intelligence
Notes You’ll notice that connecting to Analysis Services 2008 uses MSOLAP.4. To add the provider to
the list of approved providers in Excel Services, go to Central Administration -> Shared Services
Administration for Excel Services. Select Trusted Data Providers from the Excel Services Settings
of the Shared Services Administration page. Add MSOLAP.4 to the trusted list in order for the
connection to work in Excel Services.
Figure 10.3: Excel Services Data Provider
Source: http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/UsingExcelExcelServiceswith
SQLServerAnal_B11A/image_thumb_2.png
Click Add Trusted Data Provider at the top of the list, and enter
Provider ID = MSOLAP.4
Data Provider Type = OLE DB
Description = Microsoft OLE DB Provider for OLAP Services 10.0.
You are now set and can publish your workbook to Excel Services and you will be able to view,
interact and refresh data from Analysis Services 2008 in Excel Services.
Task Compare the Syntax of the MDX SELECT Statement to SQL.
Self Assessment
Fill in the blanks:
6. You can use Analysis Services as a data source for the .......................... PivotTable and
PivotChart characteristics.
146 LOVELY PROFESSIONAL UNIVERSITY
