You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Alberto Ramón <a....@gmail.com> on 2016/11/07 08:21:37 UTC
Re: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BY
Column and Group By Column are all measures column
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:
>
>
>
回复： Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BYColumn and Group By Column are all measures column
Posted by 张磊 <12...@qq.com>.
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 史少锋
Re: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BY
Column and Group By Column are all measures column
Posted by ShaoFeng Shi <sh...@apache.org>.
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 史少锋
Re: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BY
Column and Group By Column are all measures column
Posted by 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 史少锋
Re: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER
BYColumn and Group By Column are all measures column
Posted by Jian Zhong <zh...@apache.org>.
jira tracking this is https://issues.apache.org/jira/browse/KYLIN-2111
fixed in 1.6
On Wed, Nov 9, 2016 at 11:22 AM, 张磊 <12...@qq.com> wrote:
> thanks
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "a.ramonportoles";<a....@gmail.com>;
> 发送时间: 2016年11月7日(星期一) 下午4:21
> 收件人: "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
>
>
>
> 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:
> >
> >
> >
>
回复： Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BYColumn and Group By Column are all measures column
Posted by 张磊 <12...@qq.com>.
thanks
------------------ 原始邮件 ------------------
发件人: "a.ramonportoles";<a....@gmail.com>;
发送时间: 2016年11月7日(星期一) 下午4:21
收件人: "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
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:
>
>
>