Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Source table Name changed. Now Dimension Needs connecting to this new table Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 5:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
Hi,

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

Debbie
Post #1405354
Posted Thursday, January 10, 2013 5:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
Depending on how big you dimension is then recreating it is an option

However you can change the table ID tho...

Edit the dimension - click on each attribute and go to Properties --> KeyColumns --> The key column --> Source --> TableID

You may have to do the same with the NameColumns

Hope this helps,
Mack
Post #1405361
Posted Thursday, January 10, 2013 6:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
Thats the one...

Brilliant, thats sorted. Thankyou!
Post #1405381
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse