SSAS Tabular : DAX

DAX Query Engine Internals

The VertiPaq engine, which is the core of the new SQL Server Analysis Services Tabular engine, has an unprecedented level of performance, thanks to its fine-tuned architecture and its ability to perform fast cross-fltering. Automatic cross filtering between columns of the same table or related tables is a very powerful feature of DAX. It allows a measure to evaluate to different values for different cells in a pivot table even though the DAX expression for the measure does not change. Filter context is the underlying mechanism that enables this magic behavior. But it is also a very tricky concept that even befuddles some DAX experts. In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.

 

Level : 400
Date & heure : 3 décembre 2013 – 10h30
Speaker(s) : Marco Russo

 

Merci de vous connecter pour vous inscrire à l'évènement

This entry was posted in JSS 2013. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *

extension Network-wide options par YD - Développeur Wordpress