Re: id-name

[hongbin ma]

to be clear, it's "joint dimensions" in "aggregation group", you can find
it in webUI cube creation wizard.
http://kylin.apache.org/blog/2016/02/18/new-aggregation-group/ gives a
detailed intro

On Wed, Jun 15, 2016 at 11:57 AM, Dong Li  wrote:

> Are these dimensions on Lookup tables or Fact table?
>
> If lookup tables, you could use derived dimension.
> If fact table, would they both become filter? If yes, you can use joint
> aggragation group; if not, you may use ExtendedColumn measure. But this
> measure are not enabled on WebUI currently, I remembered a JIRA(KYLIN-1313)
> about this, but I cannot access JIRA at this moment, you can have a look if
> needed.
>
> Thanks,
> Dong Li
>
> 2016-06-15 10:23 GMT+08:00 yu feng :
>
> > derived dimension is a better choice.
> >
> > 2016-06-14 23:00 GMT+08:00 耳东 <775620...@qq.com>:
> >
> > > hi allwhen I build the cube, there are always dimension like
> > > (city_id,city_name) or (terminal_id,terminal_name) and so on, which is
> > one
> > > to one relation. I don't want to let both id and name be dimension. How
> > can
> > > I make name a measure other than a dimension?
> >
>



-- 
Regards,

*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone

Re: id-name

[Dong Li]

Are these dimensions on Lookup tables or Fact table?

If lookup tables, you could use derived dimension.
If fact table, would they both become filter? If yes, you can use joint
aggragation group; if not, you may use ExtendedColumn measure. But this
measure are not enabled on WebUI currently, I remembered a JIRA(KYLIN-1313)
about this, but I cannot access JIRA at this moment, you can have a look if
needed.

Thanks,
Dong Li

2016-06-15 10:23 GMT+08:00 yu feng :

> derived dimension is a better choice.
>
> 2016-06-14 23:00 GMT+08:00 耳东 <775620...@qq.com>:
>
> > hi allwhen I build the cube, there are always dimension like
> > (city_id,city_name) or (terminal_id,terminal_name) and so on, which is
> one
> > to one relation. I don't want to let both id and name be dimension. How
> can
> > I make name a measure other than a dimension?
>

Re: id-name

[yu feng]

derived dimension is a better choice.

2016-06-14 23:00 GMT+08:00 耳东 <775620...@qq.com>:

> hi allwhen I build the cube, there are always dimension like
> (city_id,city_name) or (terminal_id,terminal_name) and so on, which is one
> to one relation. I don't want to let both id and name be dimension. How can
> I make name a measure other than a dimension?