The Many-to-Many Revolution 2.0
SQL Server Analysis Services introduced modeling many-to-many relationships between dimensions in version 2005. At a first glance, we may tend… Learn More »
SQLBI Methodology
The SQLBI Methodology defines architecture and implementation of advanced BI solutions using Microsoft SQL Server, SQL Server Analysis Services and… Learn More »
Recent Articles
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… Learn More »
Memory Settings in Tabular Instances of Analysis Services
Memory settings in Analysis Services might be an important tuning of a correct setup, both for production and developer machines.… Learn 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… Learn 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… Learn 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… Learn 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… Learn More »
From SQL to DAX: String Comparison
In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set… Learn More »
From SQL to DAX: Projection
Using DAX as a query language you will lack a fundamental feature like projection. In fact, DAX allows you add… Learn More »
Ratio Over Subtotals with Normalized Tables in DAX
Calculating a ratio in DAX is relatively simple in case the underlying data model is a star schema, but you… Learn 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… Learn 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… Learn 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… Learn 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… Learn More »
KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets
Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is… Learn More »
Automate PowerPivot Data Refresh in Excel
In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data… Learn 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… Learn 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… Learn More »
DateTool dimension: an alternative Time Intelligence implementation
Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity)… Learn More »