Data Source Constraints for Level of Detail Expressions

Applies to: Tableau Cloud, Tableau Desktop, Tableau Public, Tableau Server

For some data sources, only more recent versions support level of detail expressions. Some data sources do not support level of detail expressions at all.

In addition, some data sources have complexity limits. Tableau will not disable calculations for these databases, but query errors are a possibility if calculations become too complex.

Data Source Support
Amazon EMR Hadoop Hive Supported for Hive 0.13 and later.
Aster Database Supported for version 4.5 and later.
Cloudera Hadoop Supported for Hive 0.13 and later.
Cloudera Impala Supported for Impala 1.2.2 and later.
Cubes (multidimensional data sources) Not supported.
DataStax Enterprise Not supported.
Firebird Supported for version 2.0 and later.
Generic ODBC Limited. Depends on the specific data source.
Google Big Query Supported for standard SQL, not supported for legacy SQL.
Hortonworks Hadoop Hive

Supported for Hive 0.13 and later.

On version 1.1 of HIVE level of detail expressions that produce cross joins are not reliable.

Cross join occur when there is no explicit field to join on. For example, for a level of detail expression {fixed [Product Type] : sum(sales)} when the view only contains one dimension [Ship Mode], Tableau creates a cross-join. A cross join produces rows which combine each row from the first table with each row from the second table.

IBM DB2 Supported for version 8.1 and later.
MarkLogic Supported for version 7.0 and later.
Microsoft Access Not supported.
Microsoft Jet-based connections (legacy connectors for Microsoft Excel, Microsoft Access, and text) Not supported.
Microsoft SQL Server SQL Server 2005 and later.
Mongo DB Not supported.
IBM PDA (Netezza) Supported version 7.0 and later.
Oracle Supported version 9i and later.
Actian Matrix (ParAccel) Supported version 3.1 and later.
Pivotal Greenplum Supported for version 3.1 and later.
PostgreSQL Supported version 7 and later.
SAP Sybase IQ Supported version 15.1 and later.
Splunk Not supported.
Vertica Supported for version 6.1 and later.
Back to top
Thanks for your feedback!Your feedback has been successfully submitted. Thank you!