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 appreciated