Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

1327


CHAPTER


59


Creating and Deploying Power


View Reports


IN THIS CHAPTER


Understanding Power View Requirements

Creating Report Data Source and BI Semantic Model Connection Files

Creating and Deploying Reports with Power View

P


ower View is the new ad-hoc reporting tool part of SQL Server 2012 Reporting Services add-in
for SharePoint 2010. It is a browser-based Silverlight application available through SharePoint
2010 that provides end users with the ability to create rich and interactive reports through a
true drag-and-drop experience, with no coding or report development experience necessary.

This new tool provides end users with the familiar Ribbon interface of Microsoft Offi ce with the
benefi ts of a WYSIWYG development environment. Power View launches directly from a BI Semantic
Model found in a PowerPivot workbook or from an Analysis Services Tabular database.

Power View Requirements


You can categorize Power View requirements as server-side requirements and
client-side requirements.

Server-Side Requirements
Power View server-side requirements include feature installations of SQL Server 2012 and
SharePoint 2010. Power View is a SQL Server 2012 Reporting Services feature available in SharePoint
mode only and as part of the following SQL Server 2012 Editions:

■ Enterprise Edition

■ (^) Business Intelligence Edition
■ Developer Edition
■ (^) Evaluation Edition
c59.indd 1327c59.indd 1327 7/31/2012 10:37:03 AM7/31/2012 10:37:03 AM
http://www.it-ebooks.info

Free download pdf