Anoop Krishnaswamy created KYLIN-3988: -----------------------------------------
Summary: Weighted Average does not work on cube Key: KYLIN-3988 URL: https://issues.apache.org/jira/browse/KYLIN-3988 Project: Kylin Issue Type: Bug Components: Driver - ODBC Affects Versions: v2.6.1 Reporter: Anoop Krishnaswamy When we try to get aggregate over multiplication of 2 metrics it throws an error: That both of the two sides of the BinaryTupleExpression own columns is not supported for * while executing SQL: "select sum(riskscoreinitial*cyc_xxx_balanceAdb), cyc_xxx_cyclesdelinquent from fct_profit_table_monthly group by cyc_xxx_cyclesdelinquent LIMIT 50000" My query looks something like this : select sum(<Metric1>*<Metric2>), <dim1> from <table> group by <dim1> Any guidance will help -- This message was sent by Atlassian JIRA (v7.6.3#76005)