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 |
|
drsloat
Starting Member
45 Posts |
 Posted - 2008-05-06 : 16:50:38
|
| I have a fact table that has a couple of different time values. There is a createtime which is my primary time dimension, but there is also an expiration time. Not all records have an expiration time, but I'd like to have this as a dimension, such that the rows that don't have an expiration time could be grouped as none or unknown.Is it possible to configure this in the ErrorConfiguration section for the dimension? I keep getting errors on processing for missing key values. |
|
|
drsloat
Starting Member
45 Posts |
Posted - 2008-05-07 : 10:12:12
|
| I got this to work. The missing piece was setting the KeyErrorLimit to -1 for the fact table with null dates. I'm now starting to think that this is not a very good design and that I should make some kind of None row in my dimension table. |
 |
|
|
|
|
|
Time Dimension With "None" Option