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?
