I have a SharePoint 2010 SP1 environment configured over SQL Server2008 R2.
I have an Analysis Server running on a separate physical server which is also SQL 2k8 R2. I want to create a powerview based report through a semantic model datasource that connects to a cube hosted on Analysis Server.
There is a discussion regarding this on msdn forums :- http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/95a31c10-f558-48b1-ab1f-ee7cf56741e9/ but it appears inconclusive and rather confusing to me.
System Requirements states that Powerview comes along with SQL Server 2012 BI features. I have downloaded the SQL Server 2012 Reporting Services Addin and have installed it on my SharePoint environment. It installed successfully and also notified me about older version of the same product was present before and it upgraded the RS Adddin from 2008R2 to 2012.
So my question is can powerview really work without reconfiguring the present SharePoint environment with SQL 2012.