What’s new in Analysis Services 2012 Multidimensional?

Now that SQL Server 2012 has been released, I’ve just realised I’ve not seen a definitive list of what’s new in SSAS 2012 Multidimensional. In fact I’m surprised I haven’t got round to writing a blog post about this… after all, despite the fuss over Tabular, Power View and all the other cool new stuff I guess most existing SSAS users are going to be more interested in staying with the Multidimensional model when they upgrade.

So what is new? Here’s a list of everything I know about plus some relevant links:

Have I forgotten anything? Have you found anything changed that isn’t documented? If so, please leave a comment. I’ll update this post as and when I find/remember new stuff.

34 responses

  1. Great post, thanks for compiling this list Chris!

    For the development, I think you mean Visual Studio 2010, not 2012… is that right?

  2. Great to see those changes in the new release and thanks a lot for summarizing it Chris. It is a pity that you have to catch your flight and could not stay with us after the SQL PASS event on Sat. in Dublin.

  3. I agree that browser change sucks. Instead of upgrading to maybe a PivotTable like browser they are making it mostly unusable by making it SSRS like.

  4. Regarding the OWC deprecation. The OWC component was used in a few separate areas of the product, all of which were impacted.

    Other SSDT components affected are the calculation debugging and exploring data in a DSV. For calculation debugging, a replacement control was provided, same as for cube browsing. Exploring data in the DSV is the worst, as Microsoft simply removed the functionality for creating pivot tables and charts from DSV. Now you can only show data from DSV in a tabular format within SSDT.

    The OWC components were also removed from SSMS and replaced with the MDX query designer.

    I will note here that Microsoft did extensive side-by-side testing with SQL Server 2008 R2 and SQL Server 2012 tools. If the OWC deprecation makes you very sad, you can just use the old tools side-by-side with the new tools. You can manage a SQL Server 2012 multidimensional model very well from SQL Server 2008 R2 SSMS, and you can simply browse your cubes in OWC from there after deployment.

  5. Pingback: SQL Server 2012: SSAS enhancements | James Serra's Blog

  6. Pingback: Analysis Services 2012 Multidimenzionális újdonságok - Kővári Attila szakmai blogja - TechNetKlub

  7. Thanks for detailing the changes, Chris — always appreciated. You are indeed correct that this new cube browser is undeniably terrible. I’d like to use stronger words, but this is a family blog after all.

    In case anyone else finds it useful, I’ll point out that SSDT will only work once you install the SQL2012 client tools. Before that, I had tried downloading SSDT and installing it on my existing VS2010. Imagine my frustration when I was able to use the database tools, but unable to connect to SSRS, SSAS, etc. In short, keep in mind that two different sets of tools are flying under the SSDT banner.

  8. Hi Chris

    Great info, I’m trying AS2012 Distinct Count enhancement for ROLAP, but don’t see the AS2012 property parameter: OLAP\ProcessPlan\EnableRolapDistinctCountOnDataSource
    Am I missing something??

  9. Pingback: SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources « Datta's Ramblings on Business Intelligence 'N' Life

  10. Pingback: Top FREE tools for SSAS 2012 Developers « byoBI.com

  11. I know it’s a bit off topic, but can we expect improvement with regards to SSRS and SSAS integration.
    F.e. built in support for drilldown and drillup?

    By the way, whatever happend to the great work IT-Workplace did with regards to the custom SSRS data source for SSAS, it doesn’t seem to be around anymore (?)

    • I think it’s safe to say that, after all this time, there won’t be any changes or improvements to SSAS/SSRS integration now!

      No idea what happened to IT Workplace…

  12. Hi Chris

    Nice list of the new or edited features of SQL Server…

    As we do the design of cubes mostly on servers where no excel is installed is there a plugin or something similiar to browse the cube than with the horrible new cube browser integrated in SSMS / SSDT?

    We would really appreciate something to browse trough the hierarchies and all the stuff as we can do in SSMS 2008R2… Perhaps you have an idea?

    Thx in advance and best wishes from switzerland

      • Hey Chris

        Thank you for your fast answer… I think the old SSMS is not really an option due to licence-problems.

        I hoped that there is another solution for that newly created dilemma such as a add-in or something equivalent…


  13. Chris,

    I’m using Analysis Services 2012 Multi-Dimensional mode. I have a 64 logical processors box. When I run large # of queries, I only see AS using 16 Logical Processors. I’ve played around with some of the ini settings, but I can’t get it to use more than 16 logical processors. Have you seen this behavior?

    • It’s hard to say what’s going on here – which ini file settings have you changed, and are you running queries that are Storage Engine intensive (have you partitioned your measure groups and do your queries hit lots of partitions)?

  14. Hello,

    I’m testing SSAS 2012-SP1 on a very powerful server (4 sockets / 10 cores / 80 logical processors) with 512 Go RAM / this server is numa mode hardware / WS2012 standard edition and two disk partitions (1 Raid 5 1To) and the other SSD 512go dedicated to OLAP.
    We have realized several tests between Tabular mode and Olap mode .. OLAP works perfectly on numa mode ! the 80 proc are all used during the compilations and the SE perfectly use all procs !. (very impressive !). our main fact table as more that 2 billions rows. and the respond time is less that 2 seconds on 80% or our Mdx querys (even when the SE has to aggregate from scrach).
    as I said to Marco we have lot of problems with tabular engine (not compatible with numa mode, dont use the 80 procs ! ) and in conclusion OLAP with SSD disks is faster that Tabular ! and really more stable.

  15. Pingback: FREE tools for SSAS Developers | The Daily DBA

  16. removing the OWC component is a huge step backward. why on earth would I need to install Excel on the Production server just so that I can verify the data on SSAS. I believe this is an ambush from Microsoft so that they can push for Excel as a BI client. very disappointed indeed.

    • I agree it was a step back, but it’s not a conspiracy. OWC had been deprecated for a long time before it was removed from Visual Studio – the SSAS team just didn’t have the resources to build a new control.

  17. Thanks Chris for this post. Can you please inform is there anything else new in SSAS 2012? Or everything is already covered in above blog and comments?

  18. Pingback: If I Could Have New Features In SSAS Multidimensional, What Would They Be? | Chris Webb's BI Blog

  19. Pingback: Walk-through Steps: I’m New to BI, Where to Start? – Part 2 | RADACAD

Leave a Reply

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

%d bloggers like this: