PowerView can now connect to multidimensional models

The cumulative update 4 for the SQL Server 2012 Service Pack 1 has now been released. This update enables PowerView to connect to Multidimensional models and also to have global filters across multiple views (pages) in a PowerView report. Please follow this link for more details http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/05/31/power-view-for-multidimensional-models-released.aspx

SAP vs. Microsoft, Information Assets vs. End User Experience positioning

If your company runs SAP, chances are the picture below represents your environment pretty well The black colors represent the existing investments/business processes and the size of the bubbles represents the effort/investment $$$. Your company has made a very large investment in the SAP back-end (ERP, BW, etc.) which is represented by a large black circle … Continue reading SAP vs. Microsoft, Information Assets vs. End User Experience positioning

SAP Visual Intelligence vs. Microsoft PowerPivot and PowerView

In this post I will review the latest version of SAP Visual Intelligence – 1.08 – and see how it stacks up against the Microsoft self-service BI tools, Excel, PowerPivot and PowerView. In the initial release, Visual Intelligence only supported SAP Hana, but in its latest iteration few other data sources are supported: CSV File … Continue reading SAP Visual Intelligence vs. Microsoft PowerPivot and PowerView

Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models

I have had a pretty frustrating experience with it so far.  I think that the only way get it to work is to have it deployed as a SSRS Service Application inside SharePoint and then configure PowerView.  In other words, if you are planning to install a multidemensional instance of the CTP, install your OLAP cube … Continue reading Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models

Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP

Microsoft demonstrated PowerView on top of the Multidimensional model in Analysis Services several weeks ago at SQL PASS and now the CTP version of the product is available here. There are two pieces of new functionality delivered with this CTP: Update for Analysis Services engine to allow DAX support for Multidimensional models Update for the … Continue reading Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP

PowerView Feature Comparisons

PowerView experience will be delivered across several Microsoft products: Excel (fat client) Excel Services (SharePoint) SharePoint – SQL Edition Office 365 PowerPoint I get a lot of questions as to what features are supported across all these deployment scenarios. Luckily Microsoft shared a slide that I will attempt to reproduce here that explains what features … Continue reading PowerView Feature Comparisons

Microsoft makes big announcements at SQL PASS

I will have a more detailed write-up of everything later but still wanted to give a quick summary of the new announcements: Updateable Column store – Project Hekaton will be released in the next major release of SQL Server and will allow us create updateable clustered column store indexes. This is huge, 20-50 performance increases … Continue reading Microsoft makes big announcements at SQL PASS