Quick question for you all. I'm working on my first data cube, and in the process of modelling my data, have noticed that some of the dimension tables that should have relevant primary keys, don't. Looking at the relationships generated by the
wizard, the successfully linked tables have a primary key --> foreign key relationship, whereas the tables that aren't captured have a primary key --> primary key relationship, which isn't captured within BIDS Now, as far as I know, it's possible
to change an existing column within a current database as a Primary key, but the question I have is, where is it best to do this? I *could* do it in SQL Studio, but this would mean editing my source data, which I don't want to do.
Is there any way that I can do this within BIDS instead?
Any questions, comments or suggestions are welcome.
View Complete Post