O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to Analysis Services

In Reporting Services, data sources are items instructing Reporting Services how to connect to a particular resource. Data sources identify a provider (driver), a provider-specific connection string, and how to present the user’s identity when connecting to the resource.

A Reporting Services data source may exist independent of a report, enabling its reuse across multiple reports. This is referred to as a shared data source.

A Reporting Services data source may also be defined for use within a specific report. This is referred to as an embedded data source.

Embedded data sources allow a data source’s connection string to be handled as a Reporting Services expression. Although useful in some scenarios, this advantage ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required