Thursday, March 27, 2014

What do you need to author a Power View Report?

This is the first question that you ask yourselves.

As Power View report is based on data it finds on a tabular data model, you need SQL Server Analysis Services(SSAS) server, which can host a tabular model. This means that you must have
configured the SQL Server Analysis Server to support tabular model. You create
the tabular model using SSDT, which installs when you install SQL Server 2012.

However with SQL Server 2014 which went RTM recently you can create Power View Reports as well as DAX queries using the Multi- dimensional models.

Installing SSAS to support tabular model was covered in Chapter 1, Overview and
Installation – SQL Server Reporting Services 2012 of my book Learning SQL Server Reporting Services 2012.

Also, as the PowerView is launched from SharePoint Server 2010, you want
the SQL Server Reporting Services 2012 configured to operate in integrated mode
with SharePoint Services. Installing Reporting Services 2012 in SharePoint Integrated mode was
described in Chapter 1 , Overview and Installation – SQL Server Reporting Services 2012 of my book..
The Power View reports in the above chapter are based on these premises. Power Views
are only possible for enterprise-grade servers for both SharePoint Server 2010 and
SQL Server 2012.
The environment for developing Power View described in this book is based on
the following:
•  Possibility of installingSharePoint 2010 Server on Windows 7 (x64) computer
•  Installing SQL Server 2012 Reporting Services in SharePoint Integrated mode
•  Configuring SQL Server 2012 Analysis Services to support tabular
data model
•  Availability of a Silverlight-enabled browser

No comments: