In my opinion hierarchy in kylin is just an optimization option, not like the normal hierarchy in other OLAP systems. For your case, you can put set < CITYID, ZONEID, REGIONID > as a hierarchy or a joint dimension. This setting only affects the pre-group granular also the query and cube build performance. Using cuboid <CITYID, ZONEID, REGIONID>, kylin can derive <CITYID, ZONEID>, <CITYID, REGIONID> in memory.
*Below is a SQL analogy, sub-query is kylin's pre-calculated cuboid, outside group operation process in memory/jvm:* *SELECT CITYID, ZONEID, agg-func* * FROM (* * SELECT CITYID, ZONEID, REGIONID, sum/count/avg* * FROM t * * GROUP BY CITYID, ZONEID, REGIONID* *) subquery* *GROUP BY CITYID, ZONEID* Please kindly correct it if any mistake. 2017-03-14 21:09 GMT+08:00 [email protected] <[email protected]> : > Hi, > In this situation, how should I deal with the hierarchy relations which > exist the same dimension CITYID. > Could I just pay attention on the CITYID ZONEID hierarchy ralation,and > ignore the CITYID REGIONID relation? > > the cardinality of these three columns > cityid 88336, > zoneid 11134, > regionid 2692, > > thx > > ------------------------------ > [email protected] > > > *From:* ShaoFeng Shi <[email protected]> > *Date:* 2017-03-13 22:33 > *To:* user <[email protected]> > *Subject:* Re: Aggregation group error > You can have multiple hierarchies, but they should have no overlap. In > this case, what's the cardinality of these three columns? > > 2017-03-13 13:58 GMT+08:00 [email protected] < > [email protected]>: > >> Error Message >> >> Aggregation group 0 a dimension exist in more than one hierarchy: [CITYID] >> >> Hi, >> there are three dimensions cityid（城市）,regionid（行政区）,zoneid（商圈）.actually, >> it forms two hierarchy relations. >> 1、cityid, regionid >> 2、cityid, zoneid >> >> if I config like this below. when I save the cube it shows error. >> >> Could I save the two hierarchy relations? and How Could I solve this >> problems . >> >> >> Advanced Setting config: >> >> Error: >> >> ------------------------------ >> [email protected] >> > > > > -- > Best regards, > > Shaofeng Shi 史少锋 > >
