-
…A query that could be executed easily in VertiPaq […] and it was working with VertiPaq. […] and we have already analyzed that with VertiPaq, […] because when we played with VertiPaq, […] between DirectQuery and VertiPaq. […] However, during… Watch now
-
Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team… Read more
-
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no… Read more
-
The default memory settings for Analysis Services Tabular might be less than optimal. This article describes why this might happen, and guides you choosing the right configuration. Read more
-
DAX introduced a GROUPBY function that should replace SUMMARIZE in some scenarios. This article describes how to use GROUPBY in nested grouping scenarios and other improvements. Read more
-
In this article, Alberto Ferrari describes a new efficient way to compute returning customers in DAX thanks to an idea suggested by a student attending an Optimizing DAX workshop. Read more
-
This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date and ship date. Read more
-
This article describes the differences in the levels available in Azure Analysis Services (Azure AS), comparing them with the features in SQL Server Analysis Services (SSAS) on-premises. Read more
-
In reality, there are two news. First, PivotViewer for Reporting Services CTP1 has been released and you can try it. Second, Cristian Petculescu has a blog and you can find a video about how to install and start using PivotViewer.… Read more
-
As many of you probably already know, Donald Farmer left Microsoft to join QlikView. There is no doubt that Donald has been “the face of Microsoft BI” in the last few years. This news has been initially perceived (me included,… Read more