Step 2: Download and run the file called 464142_intl_圆4_zip.exe Step 1: Download the Cumulative Update (CU) from here. Now for the installation (which is pretty standard) and then how to access Power View for Multidimensional.

One of the following two versions of SharePoint.

Microsoft SQL Server 2012 Reporting Services in SharePoint Integrated Mode with SP1 and Cumulative Update 4.

Microsoft SQL Server 2012 Analysis Services (Multidimensional) with SP1 and Cumulative Update 4.

Here are the pre-requisites to use Power View with multidimensional models before we hop into the install.

Currently Excel 2013 still only supports Power View for tabular models. This update only affects reporting services in SharePoint mode, it does not modify the functionality of Power View in Excel 2013. A CTP dropped in January of 2013 and the “later update” was finally released on May 31, 2013. That all changed when Microsoft announced at the 2012 PASS Summit that Power View reporting was coming to multidimensional models in a later update. Power View later made its way into Excel 2013, still maintaining support only for Tabular. From the beginning it was limited to only reporting off tabular models (and therefore PowerPivot models as well).

Power View was a new reporting option added in the SQL Server 2012 release as part of the SharePoint integrated mode of Reporting Services.

Download adventureworks 2012 cube