If you already installed Analysis Services 2016, you should change the MemoryHeapType setting. There is a new default value (-1), which is an automatic choice that currently applies a new hybrid allocator (which has the number 5 as a value).…  Read more

Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions…  Read more

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…  Read more

Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in…  Read more

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

We presented a few session at SQLBits and the video of these sessions are available. This is the list of sessions available from SQLBits 8 and SQLBits 9 – just click the link on the title and jump to the…  Read more

13:22

SSAS Tabular Video Course

Tabular Presentation Layer: Translations

…And this tool I think I already… OK, SSAS Tabular Translator, you can download it as a zip […] Where is it? sqlbi.com/tools/ssas-tabular-translator…  Watch now

08:49

SSAS Tabular Video Course

Hardware: The NUMA Issue

…SSAS 2016 starting with the Service Pack 1…  Watch now

02:32

SSAS Tabular Video Course

Monitoring Tabular: SSAS Configuration

…of SSAS, the first thing that we need to learn is what is the […] only the memory part of the configuration settings of SSAS. […] that tell SSAS how to use RAM. So these…  Watch now

03:22

SSAS Tabular Video Course

Monitoring Tabular: The SSAS Process

…each instance of SSAS right now. So you see what is happening […] Manager, at what is the SSAS process, how much memory it is […] Manager, the SSAS process has the name […] SSAS 2016. From there, you can see the amount of memory…  Watch now