Why SharePoint 2013 (ECS) is great for Multi dimensional!

The new ECS in SharePoint 2013 is pretty awesome, the Extel team has worked hard to make ECS on par with Excel. But wait what do these changes have in common with MOLAP? Well since most of the underlying Excel code is shared, a lot. Let me show you.

I created this Pivot table in Excel 2013 that points to the Adventureworks Molap cube. Nothing new yet here:

clip_image002

Now lets share this to SharePoint 2013, again nothing new here just a new UI:

clip_image004

Now lets open it in the browser, this is where things get interesting! Observe it looks very much like Excel 2013, and it even has a Pivot table fields list.

clip_image006

You now can change the pivot tables on the server (of course when you have the credentials) and add measures and rows and column all within the browser.

clip_image008

This is awesome! We now have a web based MOLAP browser that allows ad-hoc analytics. Just to make sure this is clear, this of course also works for Tabular Smile.

3 Replies to “Why SharePoint 2013 (ECS) is great for Multi dimensional!

  1. I check this blog, because open it in the browser, this send me an error message about update in external data source and is impossible change the pivot tables, If I open in Excel then not problem present

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.