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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2011-01-20 : 05:37:54
|
| a member with key '5435' was found in the fact but was non found in the level........why i didnt get this error, when i have customer in the fact but not in the dimension? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-01-20 : 05:42:06
|
| This is to do with the way you treat missing members. It can be changed via the dimension properties. Before changing though, you need to be sure that this is the behaviour you want as it can affect the performance and results of the cube. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2011-01-20 : 07:52:14
|
| i am sure that some customers didnt insert into dimension,and i know they exist in the fact.and still the cube didnt fail,how it could be? |
|
|
|
|
|
|
a member with key '5435' was found in the fact but