I have a fact table in SQL2000. There are some columns in the fact table used as measures in an Analysis Services 2000.
In the SQL table, there are several rows that contain null values. In the cube, these appear as zeros.
Is there a way I can tell Analysis services to preserve the null values and not convert them to zeros?