I’ve been working with a client who has been generating some impressive PowerView reports using SharePoint 2010 and a SQL 2012 Analysis Services cube (Multidimensional instance). Everything was working fine until I was posed the question ‘any idea why I don’t have the ability to pin filters’ in PowerView?
After raising this with some colleagues, it transpired that this missing element was addressed in SQL 2012 SP1 Cumulative Update 4. But don’t be fooled into thinking this means that the CU has to be applied to the SQL 2012 Analysis Services instance, this update is applicable to the SSRS Add-in, which should be installed across all of your SharePoint Web Servers. PowerView is part of the SQL Server Reporting Services family and therefore, this ‘pin’ facility, is part of the Add-in.
Download to SQL 2012 SP1 CU4 :
Once updated, your Add-in should display the following version number: 11.1.3368.0