Home > BI, Data Modeling, Power BI, Tableau > Tableau 10 Cross Join – An alternative way to achieve CrossJoin / Generate in MDX / DAX

Tableau 10 Cross Join – An alternative way to achieve CrossJoin / Generate in MDX / DAX

Just watched the Tableau Conference 16 session “Cross Database Joins: The unexpected solution to many tough analytics problems”. It is an awesome session, solved some problems which can not be solved by Tableau (before V10) alone.

Essentially, it is trying to solve the famous “event in progress” or “events with duration” questions. This kind of questions can be solved in SQL Server Analysis Services Multidimensional mode, Tabular mode, Power Pivot or Power BI since the beginning. Having said that, this also means the modelling capability of Tableau is one step closer to the OLAP (such as Power BI or Power Pivot for Excel).

A side note, now, within Tableau’s world, the near impossible accumulative distinct count should be able to achieve by this cross database join approach.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: