Cubes/MDX on their way out… BISM to replace them?

The latest news from the PASS summit is that Microsoft are starting to prepare SSAS for the retirement home, in favour of a young gun by the name of BISM.

BISM (BI Semantic Model) is an attempt to unify the worlds of SSAS and SSRS, a bit like a Business Objects Universe with knobs on. You’ll be able to design and publish the model, which then turns into an Analysis Services in-memory database on the server. The column-based technology that underlies it allows lightning fast performance and massive scalability. Not only that, but you will be able to use the model in a SQL pass-through mode instead, where SQL statements are generated when you make queries of the model. Sounds fantastic!

However, there is a ‘but’. What happens to SSAS, with its OLAP cubes and MDX queries? It seems that little new development will go into SSAS- BISM is very much the way forward as far as Microsoft is concerned. However, BISM will not be able to do quite a few things that SSAS can do now, with several key improvements pencilled in for ‘post Denali’. This leaves a certain amount of confusion in the roadmap- do customers invest in SSAS which is very capable but perhaps won’t last for many more releases, or do they invest in BISM which will not have reached maturity?

I hope Microsoft clear this up as soon as possible, or at least listen to the views of the community to make this as smooth as transition as possible.

Chris Webb gives more details in this blog post.

Update: After Microsoft posted to provide clarity on the situation, Chris has posted further here.

Advertisements
This entry was posted in News and tagged , , , , . Bookmark the permalink.

3 Responses to Cubes/MDX on their way out… BISM to replace them?

  1. Say bye-bye… Cubes are hard… BISM is Ez-Peasy…

    • rjback says:

      Clearly you’ve never tried to write DAX 🙂

      • Marco Russo explores this matter in depth in a video here: http://www.sqlbits.com/Sessions/Event9/Vertipaq_vs_OLAP_Change_Your_Data_Modeling_Approach
        He shows various scenarios that have traditionally driven people to use SSIS, a datawarehouse, datamart and cubes, that are done simply and with way better results in BISM using straight TSQL queries against relational data.
        The question then becomes, “Are there any *actual* (not theoretical) problems that my company can’t address with Tabular? For many companies, the answer will be a resounding “no”.
        The pain of writing DAX is real, but greatly diminished by the realization that you don’t have to build a datamart, and you don’t need MDX. Nor will you need to go to DAX for the lion’s share of your work because of the ease of slicers and such.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s