You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 张磊 <12...@qq.com> on 2016/11/09 03:21:50 UTC

回复: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BYColumn and Group By Column are all measures column

get it, thanks




------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi";<sh...@apache.org>;
发送时间: 2016年11月7日(星期一) 晚上6:12
收件人: "dev"<de...@kylin.apache.org>; 

主题: Re: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BYColumn and Group By Column are all measures column



The 1.6.0-SNAPSHOT build on Kylin download page has included the fix, you
can download and have a verification.

2016-11-07 18:09 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:

> Hi Lei,
>
> Currently you have to add the "group by" column to the "measure columns"
> on the data model, so to select it when creating the TopN measure.
>
> We have realized that this is confusing; In next version, the "group by"
> column of TopN will be from the model's dimensions, please check
> https://issues.apache.org/jira/browse/KYLIN-2111;
>
>
>
> 2016-11-07 16:21 GMT+08:00 Alberto Ramón <a....@gmail.com>:
>
>> Hello
>>
>> Now there are some bugs actives in UI with TopN: KYLIN-2024
>> <https://issues.apache.org/jira/browse/KYLIN-2024>  KYLIN-2097
>> <https://issues.apache.org/jira/browse/KYLIN-2097>
>> But for SUM you will need choose an Aggr Column
>>
>> 2016-11-07 7:28 GMT+01:00 张磊 <12...@qq.com>:
>>
>> > Hi
>> >  When i designer cube, in topn measures, i should choose a measure
>> column
>> > in SUM|ORDER BY Column and choose a dimension column in Group BY Column,
>> > But I only can choose a measure column in all SUM|ORDER BY Column and
>> >  Group By Column.
>> >
>> > Is it a bug in shown, how can solve it? Thanks!
>> >
>> > ORDER | SUM BY Column
>> >
>> >
>> >
>> > Group By Column:
>> >
>> >
>> >
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>


-- 
Best regards,

Shaofeng Shi 史少锋