[ https://issues.apache.org/jira/browse/KYLIN-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16827626#comment-16827626 ]
Shaofeng SHI commented on KYLIN-3988: ------------------------------------- Hello Anoop, sum(x*y) couldn't be translated to sum(x) and sum(y) with any operator, so it is not supported by Kylin, unless you define a column "z" = "x*y" in the source table, and then define "sum(z)" as a measure. If you're not willing to add this column in your hive table, you can define it in a hive view, and then use the view as the cube fact table. > 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 > Priority: Critical > > 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)