I am bit confused down here, i have product dimension with levels product line,product type,and product and show scope doesn't work until i verify product as unique.My question is what uniqueness is doing here and is common column not enough between the two sources.Thanks
the last or bottom level of a dimension, products in your case, always has to be unique. Thisis because the other levels will all finally converge onto the last level and must be mapped "one to one" ..lack of a better term :)
Thanks,Mate.