InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 04:26:51 GMT20http://www.sqlservercentral.com/Forums/Topic1405354-17-1.aspxThats the one...Brilliant, thats sorted. Thankyou!Thu, 10 Jan 2013 06:29:42 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic1405354-17-1.aspxDepending on how big you dimension is then recreating it is an optionHowever you can change the table ID tho...Edit the dimension - click on each attribute and go to Properties --> KeyColumns --> [i]The key column[/i] --> Source --> TableIDYou may have to do the same with the NameColumnsHope this helps,MackThu, 10 Jan 2013 05:26:13 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1405354-17-1.aspxHi,I have renamed a table in the data source (Id accidentally deleted it first)Now when I go into the actual dimension I get 'The key column refers to an unknown table'It looks like I have to connect the dimension to this newly named table. I have ensured the table is in the data source pane within Dimension Structure but its still not being recognised.Is there anything I can do or do I have to go through the process of recreating the dimension from scratch?Any help would be greatly appreciatedDebbieThu, 10 Jan 2013 05:15:01 GMTDebbie Edwards