Hi,

If I in Analysis Services 2000 had a table with a column containing NULL
values in some rows and this table was referencing another table, I would
normally change the NULL value til a value like "(None)" in a data warehouse
and then create an "(None)" row in the table beeing referenced. This worked
fine.

Is this still the way to do it in Analysis Services 2005?

Thanks

Henrik

Hi there,
you can use the 'Unknown Member' in SSAS 2005 to create a member to handle
NULL or unknown values.

Regards
Bobby Henningsen

"Henrik Skak Pedersen" <skak (AT) community (DOT) nospam> wrote

Thanks I will take a look at that.

"Bobby Henningsen" <bobhen (AT) mail (DOT) dk> wrote