Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
1.8 kB
7
Indexable
Never
An error occurred while communicating with the PostgreSQL data source 'New_View (Sales_BSCH.New_View) (default)'
Bad Connection: Tableau could not connect to the data source.
Error Code: 88889F6A
ERROR: Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY[ Unsupported Operation Exception: Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY]. 
 Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY
  Detail: java.sql.SQLException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY [java.lang.UnsupportedOperationException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY]
	at com.incorta.sqlinterface.exception.ErrorCode.toSQLException(ErrorCode.java:63)
	at com.incorta.sqlinterface.exception.BridgeException.get(BridgeException.java:58)
	at com.incorta.sqlinterface.exception.BridgeException.convert(BridgeException.java:135)
	at com.incorta.sqlinterface.exception.BridgeException.toSQLException(BridgeException.java:108)
	at com.incorta.sqlinterface.net.tra
SELECT SUM("New_View"."AMOUNT_SOLD") AS "sum:AMOUNT_SOLD:ok",
  SUM("New_View"."COST_OF_GOODS") AS "sum:COST_OF_GOODS:ok",
  CORR("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073647910928:ok",
  COVAR_SAMP("New_View"."COST_OF_GOODS", "New_View"."AMOUNT_SOLD") AS "usr:Calculation_140456073654411282:ok",
  COVAR_POP("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073655603219:ok",
  CAST(TRUNC(EXTRACT(YEAR FROM "New_View"."TIME_ID")) AS INTEGER) AS "yr:TIME_ID:ok"
FROM "Sales_BSCH"."New_View" "New_View"
GROUP BY 6