Difficulty filtering out null fields

[mfty]

This is Analysis Services 2000. I do a crossjoin on two fields in one table to create my columns (mdx statement below) and sometimes one or both of these fields is null. My mdx returns results that count them, though, and I can't figure out why. here's the applicable piece of the select statement (with the filter statements i've been using to try and remove the nulls);

"SELECT NON EMPTY
{ CROSSJOIN(FILTER([Field1].MEMBERS,[Field1].CurrentMEMBER.Value <> Null),FILTER([Field2].MEMBERS,[Field2].CurrentMember.Value <> Null))
} ON COLUMNS

Any ideas?

Thanks so much

 

[MDXer]

try a NonEmptyCrossJoin

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck