Ad Hoc Reports NEW in 2005


Ad Hoc Reports NEW in 2005

This is a new capability that was added for SSRS and was not available prior to this release. Microsoft provides the Windows application Report Builder NEW in 2005 tool to support this functionality. Report Builder uses models generated by the Model Builder NEW in 2005 tool.

Model Builder is a tool used by database developers to abstract the complexities of the database schema, and provide information analysts with a view of "business objects" to which analysts can relate. The model also allows developers to relate the business objects (or entities) to other objects within the database. Because the model contains information on the underlying database schema, as well as how to abstract it, it becomes integral to ad hoc reporting. After a model is complete, it is published to the report server, just as any report.

The Report Builder uses models to provide the end user views of business objects and how they relate to each other. Because the model has information on the relationship between entities, and the underlying database schema, it allows for a feature called "infinite drill down." This feature allows information analysts to browse through company data with little or no knowledge of SQL.



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net