Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eyalso
Starting Member
1 Post |
 Posted - 2007-09-20 : 18:04:06
|
| hi in analysis services when i proccess a cube i got an error that data from the fact table isnt exists in the dimenstion table for example fact table sales has column suplier that one of its row has data that doesnt match with the dimension tablehow can i handle this error ? can i insert instead someyhing else so that the proccess can continue and not failed ? Thanks Eyal |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-22 : 23:06:20
|
| You need set fkey between them to maintain data integrity. |
 |
|
|
|
|
|
error handling