Untitled
user_1382934795
plain_text
2 years ago
5.2 kB
0
Indexable
Never
SELECT "SalesOrderV"."Channel" AS "Channel",(MAX("SalesOrderV"."Total_Revenue")) AS "max:Total_Revenue:ok",(MIN("SalesOrderV"."Total_Revenue")) AS "min:Total_Revenue:ok",(SUM(CASE WHEN FALSE THEN NULL ELSE ("SalesOrderV"."Order_Quantity" / 1) END)) AS "sum:Calculation_179581094343712770:ok",(SUM((ABS("SalesOrderV"."Unit_Price")))) AS "sum:Calculation_179581094345211908:ok",(SUM(CAST((CEIL("SalesOrderV"."Order_Quantity")) AS BIGINT))) AS "sum:Calculation_179581094345322502:ok",(2.718281828459045 * count(* )) AS "sum:Calculation_179581094345531400:ok",(SUM(CAST((FLOOR("SalesOrderV"."Order_Quantity")) AS BIGINT))) AS "sum:Calculation_179581094345748491:ok",(0 * count(* )) AS "sum:Calculation_179581094346334224:ok",(SUM(CASE WHEN (("SalesOrderV"."Unit_Price" < 0) AND FALSE) THEN NULL ELSE (POWER("SalesOrderV"."Unit_Price",2)) END)) AS "sum:Calculation_374924728235560961:ok",(SUM((ROUND("SalesOrderV"."Total_Revenue")))) AS "sum:Calculation_374924728235753475:ok",(SUM(("SalesOrderV"."Total_Revenue" ^ 2))) AS "sum:Calculation_374924728248070152:ok",(SUM(CASE WHEN ("SalesOrderV"."Total_Revenue" < 0) THEN NULL ELSE (SQRT("SalesOrderV"."Total_Revenue")) END)) AS "sum:Calculation_374924728248135690:ok",(SUM(CAST((CEIL(CASE WHEN ("SalesOrderV"."Total_Revenue" < 0) THEN NULL ELSE (SQRT("SalesOrderV"."Total_Revenue")) END)) AS BIGINT))) AS "sum:Calculation_374924728248442892:ok",(SUM(CAST((FLOOR(CASE WHEN ("SalesOrderV"."Total_Revenue" < 0) THEN NULL ELSE (SQRT("SalesOrderV"."Total_Revenue")) END)) AS BIGINT))) AS "sum:Calculation_374924728248619022:ok",(SUM((ROUND(CASE WHEN ("SalesOrderV"."Total_Revenue" < 0) THEN NULL ELSE (SQRT("SalesOrderV"."Total_Revenue")) END)))) AS "sum:Calculation_374924728248733712:ok",(SUM(CASE WHEN ("SalesOrderV"."Unit_Price" > 0) THEN (LN("SalesOrderV"."Unit_Price")) ELSE NULL END)) AS "sum:Calculation_654147906242260993:ok",(SUM("SalesOrderV"."Total_Revenue")) AS "sum:Total_Revenue:ok" FROM "Mastering_DAX_Function_BSV"."SalesOrderV" "SalesOrderV" GROUP BY 1 [com.incorta.sqlengine.SemanticAnalyser.<unknown>]
Error converting SUM(CASE WHEN (SalesOrderV."Unit_Price" > 0) THEN (LN(SalesOrderV."Unit_Price")) ELSE NULL END) into INCORTA formula [com.incorta.sqlengine.ExecutionPlanner.handleException]
com.incorta.sqlanalysis.asn.AsnException: Error converting SUM(CASE WHEN (SalesOrderV."Unit_Price" > 0) THEN (LN(SalesOrderV."Unit_Price")) ELSE NULL END) into INCORTA formula
at com.incorta.sqlanalysis.asn.AsnException.onFatalError(AsnException.java:15)
at com.incorta.sqlengine.ExecutionPlanner.onFatalError(ExecutionPlanner.java:420)
at com.incorta.sqlengine.FormulaAnayzer.selectItemToFormula(FormulaAnayzer.java:56)
at com.incorta.sqlengine.request.AbstractPhase.prepareEngineSelectRequest(AbstractPhase.java:342)
at com.incorta.sqlengine.request.PlanningPhase.buildPlan(PlanningPhase.java:104)
at com.incorta.sqlengine.ExecutionPlanner.createInternal(ExecutionPlanner.java:388)
at com.incorta.sqlengine.ExecutionPlanner.plan(ExecutionPlanner.java:98)
at com.incorta.sqlengine.ExecutionPlannerInterface.planForExeuction(ExecutionPlannerInterface.java:17)
at com.incorta.sqlinterface.parser.ParsableQueryImpl.executeViaEngine(ParsableQueryImpl.java:190)
at com.incorta.sqlinterface.parser.ParsableQueryImpl.prepareQueryForExecution(ParsableQueryImpl.java:259)
at com.incorta.sqlinterface.parser.ParsableQueryImpl.analyse(ParsableQueryImpl.java:676)
at com.incorta.sqlinterface.net.traffic.command.AbstractQueryCommand.getResult(AbstractQueryCommand.java:305)
at com.incorta.sqlinterface.net.traffic.command.AbstractQueryCommand.executeQuery(AbstractQueryCommand.java:155)
at com.incorta.sqlinterface.net.traffic.command.ExecuteCommand.process(ExecuteCommand.java:103)
at com.incorta.sqlinterface.net.traffic.command.PG_COMMAND.execute(PG_COMMAND.java:42)
at com.incorta.sqlinterface.net.traffic.TrafficCop.processLoop(TrafficCop.java:225)
at com.incorta.sqlinterface.net.traffic.TrafficCop.run(TrafficCop.java:143)
failed to calculate result: [com.incorta.sqlinterface.net.traffic.command.ExecuteCommand.executeQuery]
java.lang.UnsupportedOperationException: Error converting SUM(CASE WHEN (SalesOrderV."Unit_Price" > 0) THEN (LN(SalesOrderV."Unit_Price")) ELSE NULL END) into INCORTA formula
at com.incorta.sqlinterface.executor.engine.NessyQueryExecutor.handleUnsupportedQuery(NessyQueryExecutor.java:136)
at com.incorta.sqlinterface.executor.engine.NessyQueryExecutor.getData(NessyQueryExecutor.java:72)
at com.incorta.sqlinterface.executor.engine.EngineQueryExecutor.getData(EngineQueryExecutor.java:46)
at com.incorta.sqlinterface.net.traffic.command.AbstractQueryCommand.getResult(AbstractQueryCommand.java:345)
at com.incorta.sqlinterface.net.traffic.command.AbstractQueryCommand.executeQuery(AbstractQueryCommand.java:155)
at com.incorta.sqlinterface.net.traffic.command.ExecuteCommand.process(ExecuteCommand.java:103)
at com.incorta.sqlinterface.net.traffic.command.PG_COMMAND.execute(PG_COMMAND.java:42)
at com.incorta.sqlinterface.net.traffic.TrafficCop.processLoop(TrafficCop.java:225)
at com.incorta.sqlinterface.net.traffic.TrafficCop.run(TrafficCop.java:143)