yes you're correct; 2016-01-05 13:49 GMT+08:00 Zhang, Zhong <[email protected]>:
> 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
