Drillthrough and Null date values

[FlytLsWaterFowl]

I've got a claims based cube and a dimension that is built directly from the fact table called check date. This can be null for those claims that haven't been paid yet. When browsing the cube, the check date dimension shows a '0' year, and nothing when drilling into the dimension itself (all the null check dates), and the measures change accordingly. The problem is that I can't drill to detail when I've selected the null date values. What's up here?

 

[johnherman]

Well, that's the way nulls work. You could try creating a calculated column such that if the check date is null, move a 'Y' to the NotPaidYetFlag and then do your drilling on that flag, which will only be null for paid claims.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright