Issue
When using custom SQL aggregations sent to an Oracle database, an error may be returned:Unimplemented Feature
Last Modified Date: 25 Nov 2019
Environment
- Tableau Desktop
- Oracle
Resolution
Use an AS clause for the aggregated field in the custom SQL, such as:SELECT t."Product Name,
max(t."Required_Time") AS "Max Required Time"
FROM ....Instead of:
SELECT t."Product Name,
max(t."Required_Time")
FROM ....Cause
The error occurs when the aggregate field is not aliased with an AS clause. The default rules Tableau uses for naming fields without aliases does not work with aggregated fields in Oracle.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials