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

Дата публикации: Apr 13, 2024
Описание

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.
 
Решение
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.
 
Дополнительные ресурсы
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.
Номер статьи базы знаний

001472350

 
Загрузка
Salesforce Help | Article