Julian Hyde wrote: > The workaround is to make sure that foreign keys are not null and point > to valid records in the dimension table. Beyond workaround, this is really an ETL best practice; search for "zero key" in this article: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part5/c1961.mspx?mfr=true JVS