Filters Using Published Multi-Fact Table Data Sources Return 'Not Defined' DataSourceExceptions on Tableau Cloud

Tableau / Tableau Cloud
Solution in Progress

Created

Nov 12, 2024

Found in Release

2024.2.2, 2024.3

Last Updated

Feb 12, 2025

Reference ID

W-17116940

Summary

When attempting to use filters in a workbook published to Tableau Cloud and connected to a multi-fact table (also referred to as shared dimensions) data source, an error is thrown.


This issue can also be observed from Tableau Desktop, if a workbook is connected to a published extract of the multi-fact table data source. A local extract will not encounter the issue.

Error Details

An error occurred while communicating with the data source. Abstract query SELECT [TEMP(Calculation_1#######################)(0)] is not defined Class DataSourceException

Steps to Reproduce

  1. Create a workbook connecting to a multi-fact table data source.
  2. Create filters to select each fact table.
  3. Publish the data source to Tableau Cloud. Ensure that the workbook is switched to using the published data source.
  4. In the browser, navigate to the published workbook and attempt to change and apply the filter to select all multi-fact tables at once.
  5. An infinite reconnect to data source message will appear (if selecting 'Yes'), choosing 'No' will showcase the error.


Workaround

The filter can be applied without issue if a local extract of the data source is used.

Reference IDW-17116940
Solution in Progress

2 Reports

2 Reports