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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2008-02-26 : 17:19:44
|
| I have a dimension with a date field (int key value actually) that is generally null that I'm using to link to a time dimension. Everything works great when I set Null Processing to UnknownMember in the Measure Group Bindings, but if I try to set it to Preserve or anything else, I get processing errors because it can't match the null attribute key to the time dimension. I think I understand this, but I'm concerned that I'm not doing it the best way. Also, why does this page say "UnknownMember causes a data integrity error at processing time" when that's the only setting that does not give me errors?http://technet.microsoft.com/en-us/library/microsoft.analysisservices.nullprocessing.aspx |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2008-02-26 : 18:27:21
|
| Also, should I be using -1 or something instead of nulls where the date doesn't exist in my foreign key field? |
 |
|
|
|
|
|
Nullable field as fact-dim link causes errors