Articles of 2012
Best practices using SUMMARIZE and ADDCOLUMNS
This article provides the best practice to use ADDCOLUMNS and SUMMARIZE, two functions that can be used in any DAX expression, including measures. 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 in the lookup table. In this article you will see how to handle relationships between tables that have different granularities,… 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 not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no… Read more
Optimizing Many-to-Many Calculations in DAX with SUMMARIZE and Cross Table Filtering
PowerPivot and Analysis Services 2012 Tabular do not support many-to-many (M2M) relationships directly in the data model. However, you can obtain the desired result from a many-to-many relationship by writing a DAX expression. For example, consider the classic M2M relationship… 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 Excel formula and it can be considered a functional language. You do not have iterative statements, but you can run… Read more
Optimizing High Cardinality Columns in VertiPaq
VertiPaq is the internal column-based database engine used by PowerPivot and BISM Tabular models. High cardinality columns might be the more expensive parts of a table. If you cannot remove a high cardinality column from a table, by using the… 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 OLE DB connection should be the right way to get your data. It works, but if you your code is… Read more
Parallelize ProcessAdd with AMO
In this article we see a function to enable parallelism in commands sent to Analysis Services by using the AMO library even when you need to use the change the QueryBinding. This function is useful because the current AMO library… Read more
Incremental Processing in Tabular Using Process Add
In Analysis Services 2012 you can process a table in a Tabular model by several ways: you can process the whole table, you can split the table in several partitions and process a single partition, you can merge partitions and… Read more
Upgrading PowerPivot from Excel 2010 to Excel 2013
If you have a PowerPivot workbook created with Excel 2010, in order to navigate and/or update the data model with Excel 2013 you need to upgrade the workbook. Read more