THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

First steps with #ssas #Tabular in #Denali #CTP3

The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services "Denali".

In these early days I read several messages asking for clarification about the names and acronyms used in Denali. For a complete description I suggest you to read the Analysis Services - Vision & Roadmap Update published by Microsoft in May 2011 and my personal comments in this blog. However, if you are in a hurry, this is a short recap:

  • Analysis Services Denali has two enginges: the traditional OLAP one (the only one it had until 2008) and the new Vertipaq one (introduced by PowerPivot and now directly available without SharePoint and/or Excel).
  • In order to cover these two tecnologies under the same hat, a new acronym has been introduced: BISM (Business Intelligence Semantic Model)
  • When yuo create a project for BISM you can use either BISM Multidimensional (corresponding to a classic SSAS project based on the OLAP engine) or BISM Tabular (corresponding to the new project type based on the Vertipaq engine).
  • In documentation, books and article you will read Multidimensional (corresponding to BISM Multidimensional) and Tabular (corresponding to BISM Tabular).
  • Both Multidimensional and Tabular models can be queried by using MDX. However, internal calculation are based on DAX in Tabular and DAX can also be used to query a Tabular model. In a possibly near future, we should expect to use DAX also to query a Multidimensional project (I hope this will happen very very soon - months and not years).
  • When you install Analysis Services Denali you have to choose what type of engine you want to use for the instance you are installing. If you want to be able to use both engines, you need to install two instances of Analysis Services. During the setup you can choose which one you desire and Multidimensional is the default.
  • The UDM acronym (Unified Dimensional Model) is no longer used. An UDM project is now a BISM Multidimensional project. THere is a 100% compatibility for existing projects and from the point of view of the existing feature, BISM Multidimensional is 100% corresponding to UDM in 2008 R2. Any existing book, documentation and whitepaper is still valid in BISM Multidimensional. The Analysis Services release has improvements (there is no longer a 4GB limit for string stores, for example), fix and optimizations, but there aren't new major features in Multidimensional for this release.

Thus, if you want to test what is new in Analysis Services Denali, this is the call to action:

  1. Install Analysis Service Denali in Tabular mode
  2. Import your existing PowerPivot workbooks in a Tabular project (yes, you can!)
  3. Learn DAX.
  4. Start using the new features in Denali (you have KPI, Partitions and Security, just to name a few)
  5. Learn DAX
  6. Play with this new baby and stay tuned for more content in this and other blogs!
  7. Learn DAX

In case it is not clear, if you are a BI professional, there is an important thing you have to do in order to keep your skill updated: Learn DAX!

Published Thursday, July 14, 2011 7:25 AM by Marco Russo (SQLBI)



h_d_t said:

hi marco. any good books you can recommend for DAX?

July 19, 2011 10:00 PM

Marco Russo said:

I have to promote myselft...

I think that today the more complete book about DAX is our one about PowerPivot:

Half of the book is about DAX and everything we wrote is valid for Tabular. There are some extension in Denali but you can start with this and then integrate with books on line, blog posts and article. Otherwise you have to wait a few months for our next book :)


July 20, 2011 1:16 AM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement