---
schema_version: "1"
id: 4242600f338929316028b9dd9466363d2c57f997f34174bcb6379619838f4fc5
title: Data Source Constraints for Level of Detail Expressions
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/public/desktop/calculations_calculatedfields_lod_constraints.md
canonical_url: https://help.tableau.com/v0.0/public/desktop/en-gb/calculations_calculatedfields_lod_constraints.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 1be2fd259b12dc28a0d6be169b0babd6cdb1b078dbfb8b9d15b0d15b3b8d1f6b
description: Understand data source constraints and version limits for Level of Detail expressions.
---
[Skip to main content](#main-content)

# Data Source Constraints for Level of Detail Expressions

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.

<table class="table--stripes"><tbody><tr class="Body-Body1"><td class="BodyE-Column1-Body1"><b>Data Source</b></td><td class="BodyD-Column1-Body1"><b>Support</b></td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Amazon EMR Hadoop Hive</td><td class="BodyD-Column1-Body1">Supported for Hive 0.13 and later.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Aster Database</td><td class="BodyD-Column1-Body1">Supported for version 4.5 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Cloudera Hadoop</td><td class="BodyD-Column1-Body2">Supported for Hive 0.13 and later.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Cloudera Impala</td><td class="BodyD-Column1-Body1">Supported for Impala 1.2.2 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Cubes (multidimensional data sources)</td><td class="BodyD-Column1-Body2">Not supported.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">DataStax Enterprise</td><td class="BodyD-Column1-Body1">Not supported.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Firebird</td><td class="BodyD-Column1-Body1">Supported for version 2.0 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Generic ODBC</td><td class="BodyD-Column1-Body2">Limited. Depends on the specific data source.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Google Big Query</td><td class="BodyD-Column1-Body1">Supported for standard SQL, not supported for legacy SQL.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Hortonworks Hadoop Hive</td><td class="BodyD-Column1-Body2"><p>Supported for Hive 0.13 and later.</p><p>On version 1.1 of HIVE level of detail expressions that produce cross joins are not reliable.</p><p>Cross join occur when there is no explicit field to join on. For example, for a level of detail expression <code>{fixed [Product Type] : sum(sales)}</code> when the view only contains one dimension [<span class="uicontrol">Ship Mode</span>], 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.</p></td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">IBM DB2</td><td class="BodyD-Column1-Body2">Supported for version 8.1 and later.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">MarkLogic</td><td class="BodyD-Column1-Body1">Supported for version 7.0 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Microsoft Access</td><td class="BodyD-Column1-Body2">Not supported.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Microsoft Jet-based connections (legacy connectors for Microsoft Excel, Microsoft Access, and text)</td><td class="BodyD-Column1-Body1">Not supported.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Microsoft SQL Server</td><td class="BodyD-Column1-Body2">SQL&nbsp;Server 2005 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Mongo DB</td><td class="BodyD-Column1-Body2">Not supported.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">IBM PDA (Netezza)</td><td class="BodyD-Column1-Body2">Supported version 7.0 and later.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Oracle</td><td class="BodyD-Column1-Body1">Supported version 9i and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Actian Matrix (ParAccel)</td><td class="BodyD-Column1-Body2">Supported version 3.1 and later.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Pivotal Greenplum</td><td class="BodyD-Column1-Body1">Supported for version 3.1 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">PostgreSQL</td><td class="BodyD-Column1-Body2">Supported version 7 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">SAP Sybase IQ</td><td class="BodyD-Column1-Body2">Supported version 15.1 and later.</td></tr><tr class="Body-Body2"><td class="BodyE-Column1-Body2">Splunk</td><td class="BodyD-Column1-Body2">Not supported.</td></tr><tr class="Body-Body1"><td class="BodyE-Column1-Body1">Vertica</td><td class="BodyD-Column1-Body1">Supported for version 6.1 and later.</td></tr></tbody></table>