You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by "Zhang, Zhong" <zz...@cardlytics.com> on 2016/01/05 06:49:34 UTC
hierarchy dimension
Hi All,
I'm trying to build a Kylin cube. There are a couple of
fields like following:
FLATGEO2 is a look up table.
FLATGEO2.REGIONNAME - example "NorthWest"
FLATGEO2.TOWN - example "Atlanta"
FLATGEO2.PROVINCECD - example "GA"
FLATGEO2.PROVINCENAME - example "Georgia"
FLATGEO2.dma_code - 524 for Atlanta and surrounding areas
FLATGEO2.msa - another identifier for a collection of towns
| regionname | town | provincecd | provincename | dma_code | msa |
| SouthEast | ATLANTA | GA | null | 524 | null |
| SouthEast | ATLANTA | GA | null | 524 | null |
| SouthEast | ATLANTA | GA | null | 524 | null |
I'm planning to put "regionname", "town", "provincecd", "provincename", "dma_code" and "msa" in a hierarchy dimension.
Do I understand correctly for the hierarchy dimension?
Best regards,
Zhong
Re: hierarchy dimension
Posted by ShaoFeng Shi <sh...@apache.org>.
yes you're correct;
2016-01-05 13:49 GMT+08:00 Zhang, Zhong <zz...@cardlytics.com>:
> Hi All,
>
>
>
> I’m trying to build a Kylin cube. There are a couple of
>
> fields like following:
>
>
>
> FLATGEO2 is a look up table.
>
> FLATGEO2.REGIONNAME — example “NorthWest”
>
> FLATGEO2.TOWN — example “Atlanta”
>
> FLATGEO2.PROVINCECD — example “GA”
>
> FLATGEO2.PROVINCENAME — example “Georgia”
>
> FLATGEO2.dma_code — 524 for Atlanta and surrounding areas
>
> FLATGEO2.msa — another identifier for a collection of towns
>
> | regionname | town | provincecd | provincename | dma_code | msa
> |
>
> | SouthEast | ATLANTA | GA | null | 524 | null
> |
>
> | SouthEast | ATLANTA | GA | null | 524 | null
> |
>
> | SouthEast | ATLANTA | GA | null | 524 | null
> |
>
> I’m planning to put “regionname”, “town”, “provincecd”,
> “provincename”, “dma_code” and “msa” in a hierarchy dimension.
>
> Do I understand correctly for the hierarchy dimension?
>
> Best regards,
>
> Zhong
>
>
>
>
>
--
Best regards,
Shaofeng Shi