Filtering Hierarchy Members

Hi
I am sort ofstuck with this issue ...I want to be able to Filter Hierarchy toexclude member that are null... Basically what I got is what we calledleveled table ....that maintain alternative hierarchies..... Dimensioncalled accounts ..it has three hierarchies .... the underlying tablehas following columns
Account, Account Desc,
HierchyAAALevel1,HierchyAAALevel2,HierchyAAALevel3,
HierchyBBBLevel1 , HierchyBBBLevel2,HierchyBBBLevel3


That data look like this

123, Building07/08, Building07/08, Building , Cap07 , NULL, NULL, NULL

122 Land07/08 , Land07/08 , Land07 Cap07 ,Land07/08 , Land08 , Cap08
144 Water08, Null , Null , Null, Water08, Water, Cap08


So when I make Hierarchy named "HierarchyAAA" using column HierchyAAALevel3,HierchyAAALevel2,HierchyAAALevel1 ( Top to bottom) . dimension processes fine , when I browse I have CAP07 and NULL at level 3
Iwant the hierarchy to only show Non Null members whenever thishierarchy is used , with any measure. I am not even sure if its do able

any help would be much appreciated

Raheel

I had hierarchy levels setup incorrectly , so I changed that and Than changed the HidememberIf property to " NoName " ... and that eliminated all Null data