I've been doing some research into the setup required to get PowerView to connect to existing cubes sitting on a SQL Server 2008 R2 instance. Can anyone confirm that the following is right (or correct me if I'm wrong)?
I believe I need the following:
- SharePoint Server 2010 Enterprise Edition with 'Reporting Services Add-in for SharePoint Products' installed from SQL Server 2012 or SQL Server 2008 R2
- My existing SQL Server Analysis Services 2008 R2 Enterprise Edition running in 'SharePoint Integrated' mode
- SQL Server 2012 Reporting Services installed in 'SharePoint Integrated' mode updated with SQL Server 2012 Service Pack 1 Cumulative Update 4
I have been trying to put together the information I have found in the following places:
but it's extremely possible I may be getting things confused.
To create Power View reports the data source needs to be hosted on