This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
Please be aware you'll need to have the Adobe Flash 9 plug-in to watch this video.
Runtime: 2:06 minutes
Showing OLAP Data in SSRS - SQL School Video
Reporting Services makes it easy to get data from a variety of sources, including Analysis Services cubes. In this SQL School video, Brian Knight shows how to use an SSAS cube as the dataa source for your reporting needs.
2008-10-14
5,368 reads