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… 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… 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… Read More »
Order of Evaluation in CALCULATE Parameters
DAX is the new language used by PowerPivot and Analysis Services in Tabular mode and it resembles the syntax of… Read More »
Clever Hierarchy Handling in DAX
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are… Read More »
Budget and Other Data at Different Granularities in PowerPivot
PowerPivot and BISM Tabular handle relationships between tables by using a single column that requires to be a unique column… Read More »
Execute DAX queries through OLE DB and ADOMD.NET
If you want to execute a DAX query from your code to a Tabular model, you might think that an… Read More »
Understanding Circular Dependencies in Tabular and PowerPivot
When you design a data model for Tabular you should pay attention to a though topic, which is that of… Read More »
Sorting Dates Columns in PowerPivot v2 and BISM Tabular
Sorting a column by using another column is one of the nice features of the new version of PowerPivot introduced… Read More »
Videos available from SQLBits
We presented a few session at SQLBits and the video of these sessions are available. This is the list of… Read More »
Converting MDX to DAX – First Steps
A BISM Tabular model can be queried by using both MDX and DAX. These two different languages rely on different… Read More »
Creating a copy of a BISM Tabular project
Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name… Read More »
Separate date and time in PowerPivot (and BISM tabular)
In PowerPivot you can import data from several sources and it is often the case that you import a DateTime… Read More »
Drillthrough for BISM Tabular and attribute keys in SSAS Denali
In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL… Read More »