Null Processing Option (analysis services 2005)

Hello,

I've got a problem with a references relationship and null value.

I've got a relationship bteween the table visiteur and the table keyword by a composed key which has the collection key: Action_id, reflink_value and reflink_name

the keyword and visiteur table are bound by this composed key. and the relation is materialize (Analysis services 2005)

But sometime, I've got values in visiteur table that are not in keyword table, I want that there's not an error when I process the cube.

How can I do to force my cube to process and to count the correct number of visit in my table visiteur. For the moment, my cube count 7100 visiteur but I've got just 5300 visitor in the table.

Thanks for your help

For each of your key column (Action_id, reflink_value and reflink_name) in the visiteur table, set the NullProcessing property to UnknownMember. Then on the dimension (or both dimensions if this is a reference between two dimensions) set the UnknownMember property to Visible. This will tell the AS server to treat nulls as unknown members and to show unknown members in the dimension. (By default the server will treat null values as zeros which will then map to an incorrect ID or to no ID at all.)