Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
1.9 kB
1
Indexable
Never
An error occurred while communicating with the Incorta Connector by Incorta data source 'sales_business_Schema (SALES_BUSINESS_SCHEMA.sales_business_Schema) (bi_test)'
Bad Connection: Tableau could not connect to the data source.
Error Code: FAB9A2C5
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
Connector Class: incorta_jdbc, Version: 1.0.0
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