Hi all,

I have a role-playing time dimension that I use twice in my sales cube, with
two different key columns in the fact table, let's imagine they are "order
date key" and "delivery date key". There is always an "order date key", but
of course for some sales there is no delivery date (yet), so this column is
NULL in the fact table. I enabled the "unknown member" in my time dimension,
it is visible now, and I set the "Error Configuration" of the related
measure groups to "(custom)", specifying the "KeyErrorAction"
"ConvertToUnknown", and the "NullKeyConvertedToUnknown" to "IgnoreError". On
the "Measure Group Bindings" of the delivery date-dimension (the one with
the unknown member) I set the "Null Processing" for the relationship between
dimension columns and measure group columns to "UnknownMember". It processes
beautifully, but I see nothing on the unknown member of the "delivery date"
dimension, and - even worse - from now on the whole cube contains only sales
that have a delivery date, all undelivered sales (with NULLs in the fact
table) are gone from the cube. They come back when I remove the relationship
between "delivery date" and my measure groups.

Does anybody have an idea what am I missing here? BOL doesn't really help
very much on this...

Thanks in advance,

Markus.

It seems that the link between delivery date key and fact date key might be
the problem. Please make sure that you used the right key in the fact (you
will need to have two date keys in the fact table).

"Markus Raatz" wrote: