Hi all
i have dimension of costumers .... the pk is costumerid
and second dimension that calls : customers details
with columns : costid + contactType (1-phone,2-mail,3-fax)
mean the pk of second dimension is by 2 columns : costid +contacttype
i create outside pk that contain the 2 columns (since on dimension is limited to 1 field pk)
but when i link the dimension by costumerid
and go to excel is bring to specify costumer for example all details contact method of all costumers ....mean join between the 2 dimension not work
i dont know why...
can someone tell me what wrong?
thanks