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 Date: 2017-03-13 22:33 To: user 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 史少锋
