Hi
i have dimension that with : costumerid+ contactnumber+contactidmethod
contactid is (1-email,2-phone,3-fax)
the pk is : costumerid+ contactidmethod
and main dimension that call: costumers
contain costumerid+details
i have 2 problems;
1.when i link second dimension to main is ok
but dimension can have only one column pk : so i understand that i can make new column name (with 2 columns)
2. second problem i see in excel that for 1 costumer id is present the all data of all costumers, so mean the join between 2 dimensions fail
what im doing wrong
t h a n k s