KNOWLEDGE BASE

Error "Cannot blend the secondary data source because one or more fields use an unsupported aggregation." Blending With A Cube Data Source


Published: 01 Oct 2015
Last Modified Date: 29 Jul 2016

Issue

When blending data where the primary data source is a cube database, the following error might occur:

Cannot blend the secondary data source because one or more fields use an unsupported aggregation.

Environment

Tableau Desktop

Resolution

  1. Right-click and drag the linking dimension to the view.
  2. Select the desired aggregation, ATTR(), MIN(), or MAX().

Cause

In order to blend with a cube database, it is necessary to aggregate the secondary data source.

Additional Information

The linking field from the primary (cube) data source must be in the view for blending to work properly.
Did this article resolve the issue?