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
