You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kylin.apache.org by "guojialing@smartbi.com.cn" <gu...@smartbi.com.cn> on 2020/08/13 11:22:39 UTC

【Asking for help】how to build measures " sum(A+B)"

Hi,
    I've created a Cube. like
    

    Then I found that if I exec SQL like 

   ' select
        CATEG_LVL2_NAME as F_INSIGHT_FIELD_OUTER_1,
        sum(LEAF_CATEG_ID) +sum( SITE_ID) as F_INSIGHT_FIELD_OUTER_2
    from
        KYLIN_CATEGORY_GROUPINGS
    group by
        CATEG_LVL2_NAME
    order by
        CATEG_LVL2_NAME' , it will success.


    But if I exec SQL like 

    'select
        CATEG_LVL2_NAME as F_INSIGHT_FIELD_OUTER_1,
        SUM( sum(LEAF_CATEG_ID+SITE_ID) ) as F_INSIGHT_FIELD_OUTER_2
    from
        KYLIN_CATEGORY_GROUPINGS
    group by
        CATEG_LVL2_NAME
    order by
        CATEG_LVL2_NAME',   it will fail.

    How could I make it seccuss? 

    Look forward to your favourable reply.


Jaylin Guo