You don¹t need put all province_id, rev_addr_province_id, province_name into dimensions; Leave just the one that you¹re going to group by, which is ³province_name² in this case.
On 3/31/15, 5:55 PM, "wanghaifei" <[email protected]> wrote: > hi, > Here has a example: > select province_name, count(user_id) from dw.fact_1 as a > right join dim.dim1 as b on >b.province_id=a.rev_addr_province_id > group by province_name > > I choose province_id, rev_addr_province_id, province_name as >Dimension. But when I save the cube it has a error.The error content: > Error Message > > Cannot find rowkey column PROVINCE_ID in cube > > question : > If I remove province_id from Dimension, the cube builded >successed. But how to join dim1 , to realize that example? >
