Can any MDX Guru let me know suitable MDX query to achive the below :-
I don't want to select Null value present in the Occupation.
Any help will be highly appreciated.
"Date" "Occupation" "Number of home"
FY 2001-Q1 Null 3
FY 2001-Q2 Teacher 4
FY 2001-Q3 Banker 5