Ragged Hierarchy ….

I want to hide the level/member(s) if it’s missing i.e. NULL …so the Last non-empty leaf can appear when I browse the Cube with this particular dimension. For that what I have found so far is to use HideMemberIf property of the Hierarchy i.e OnlyChildWithNoName . But that seen not to be working … Am I missing to set any property…..
Example
ID EType1 EType_2 EType3 Number Name
1 1 NULL NULL 111 ABC
2 2 1 4 112 CDT
3 2 1 NULL 121 HUY
4 3 NULL 8 231 YYY
5 NULL 5 NULL 22 777
6 NULL NULL 2 876 rrr
Any Advise
Regards
Raheel