Loading

Error "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" With Blended View Using a Cube as Primary Data Source

Publiseringsdato: Apr 13, 2024
Beskrivelse

The error below occurs upon adding a measure from the cube as a primary data source to the view:

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

Cause

The root cause is related to the default aggregation of the Cube measures as they are AVG. 
AVG is a quasi-additive aggregation and it does not work in Tableau.
The supported default aggregations for cube measures are: SUM, MIN, MAX, COUNT.
 
Løsning
Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT.

If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop.
 
Flere ressurser
See the Tableau Desktop and Web Authoring Online Help for further assistance when blending data sources when one or more of the fields uses an unsupported aggregation.
Knowledge-artikkelnummer

001472350

 
Laster
Salesforce Help | Article