O'Reilly logo

Learning SQL Server 2008 Reporting Services by Jayaram Krishnaswamy

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

Appendix A. Queries and Datasets in SSRS 2008

In this Appendix, you will learn about the different sources of data that are used in the Reporting Services. You will also learn about the differences between the SQL queries, MDX and Semantic queries and how each of them is supported in the Query Designer.

Reporting Services data

Reporting Services obtains its data from data stores. The data is stored mostly in relational databases or in the form of XML. Data used in business intelligence will be mostly stored in OLAP (http://www.olapreport.com/fasmi.htm) databases. Reporting Services can access data in relational databases as well as OLAP data stores. It can also query data from semantic data models that are created by the Reporting Service's tools ...

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