Viewing cubes when upgrading to SQL Server 2012

This taken from “Behaviour Changes to Analysis Services Features in SQL Server 2012

Cube browser in Management Studio and Cube Designer has been removed

The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio or in Cube Designer has been removed from the product. The control was an Office Web Control (OWC) component. OWC was deprecated by Office and is no longer available.

This is really annoying for thos who do not have Excel with power pivot. MS has dictated that you must buy both SQL and Excel in order to be able to develop BI solutions. Sure you probably already have Excel and if you use two monitors to develop then you might not mind as you can browse in one screen while developing in the other but you could before too. Now MS have forced you in to it which is really annoying.

I develop on a 22 inch screen but my second monitor is the 13 inch screen on my Sony VaioZ so I don’t really want to use this. On the few occasions where I do not have my monitor connected and the Sony is the only screen, I now have to ALT+TAB between them. It’s just not ideal.

MS still has not created a decent online version of the browser either forcing us to using third party tools for ad-hoc cube browsing on the web. In my current contract my customer wants to browse cubes over the internet and cannot use SSAS but the power pivot also does not really go far enough.

I think MS need top put a little more effort in here. What do you think?


About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)
This entry was posted in Developer stuff, SQL Stuff and tagged , , , , , , . Bookmark the permalink.

1 Response to Viewing cubes when upgrading to SQL Server 2012

  1. Gary says:

    Just discovered this ‘feature’ of 2012 last night – staggered that Microsoft think it a good idea. This is going to slow me down no end when testing cubes now.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s