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