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:
- Install Analysis Service Denali in Tabular mode
- Import your existing PowerPivot workbooks in a Tabular project (yes, you can!)
- Learn DAX.
- Start using the new features in Denali (you have KPI, Partitions and Security, just to name a few)
- Learn DAX
- Play with this new baby and stay tuned for more content in this and other blogs!
- 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!