Hi.

I have two tables as follows:
table Products vs table Sales
ProductID (key) SaleID (key)
Number Number
ProductID

In SQL Analisys Services when I define a cube by adding both these tables I
see a single connection between Products.ProductID and Sales.ProductID.

However, when I add any existing dimension or a shared dimension somehow an
association is made between Products.Number and Sales.Number.

When I manually delete this Number association the dimesnions related to
Sales table are deleted - meaning Number connection is gone, but when I
process the cube I get empty Data results...

I can't change the Number field name in the other table due to restricions I
have.

Any one got any idea why this duplicate names in different table casuses
addiitional unneccesary associations?

Thanks,
Guy