Topic: BISM

Organizing Measures and Attributes in Folders with Tabular
When you create a Tabular model in Microsoft SQL Server Analysis Services (SSAS), you have to define all of the measures that the user will be able to use. All the measures defined in the measure grid of a table… Read more
Workshop and Events in Europe next month #ssas #tabular #powerpivot
As I mentioned a couple of weeks ago, I and Alberto are starting to travel again, delivering SSAS Tabular Workshop and other free community events around Europe. This is the updated list of our next dates, including community events: Online – SSAS Tabular Read more
SQLBits XI in May 2013 – many reasons to attend! #sqlbits #dax #tabular
I and Alberto Ferrari will speak at SQLBits XI (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX! Here are our sessions: Thursday, 02 May 2013 – Training Day – From 0 to DAX The Read more

Usage of dates argument in a row context
Several Time Intelligence functions in DAX use a <dates> argument, which has a special behavior because it can be expressed by using both a column reference syntax, a table expression or a Boolean expression. Read more
xVelocity engines compared: VertiPaq vs ColumnStore #ssas #vertipaq #xvelocity #sql #tabular
During the last months I and Alberto worked in several projects using Analysis Services Tabular and we had to face real world issues, such as complex queries, large data volume, frequent data updates and so on. Sometime we faced the challenge of comparing Read more

VertiPaq vs ColumnStore Comparison
SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help you choose the right one or, at least, raise your curiosity about performing more tests on your specific scenario. Read more
Finally in stock: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model #ssas #tabular
It has been a long wait, but finally our book about Analysis Services Tabular is available! Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model Amazon is already shipping it in US and it should be available soon also in Europe. However, Read more
Watch @marcorus and @ferrarialberto sessions online #teched #msteched #tee2012
In June I participated to two TechEd editions ( North America and Europe ). I and Alberto delivered a Pre Conference and two sessions about Tabular. Both conferences provides recorded sessions freely available on Channel 9 so that you can compare which Read more
Optimize Many-to-Many with SUMMARIZE and Other Techniques
We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships Read more
Order of Evaluation in CALCULATE and Clever Hierarchy Handling in #dax
After the first two editions of the SSAS Tabular Workshop , I and Alberto had some time to flush some of the pending activities. We published two articles: Clever Hierarchy Handling in DAX : DAX is not a hierarchy-friendly language, especially if you Read more