[SOLVED] Metadata filter in Essbase not working

Metadata filter in Essbase not working

I have a BSO cube and it's Org hierarchy is set like below:

Org:

totalUS    
          US  
             US retail  
             Us non retail  
  A1  
  B1  
  C1  
  D1  
    D_001

the user group should only see data for @IDescendants(US non retail) and Idescendants(D1).The user wants totalus hidden too. My Maxl script is:

grant read on database 'Test'.'Test' to group 'Test'; create or replace filter 'Test'.'Test'.'MetaTest' meta_read on '@IDESCENDANTS ("US non retail"),@IDESCENDANTS("D1")' ; grant filter 'Test'.'Test'.'MetaTest' to group 'Test';

Still my Smart view pull shows data and member name for totalus,totalus is sibling of A1,B1,C1,D1. Please help me!

Solution

You need to change your filter to disallow access to the @IDESCENDANTS("TotalUS") and then have the metaread. Just because the metaread focuses on a different hierarchy doesn't mean that you've addressed the other elements in the hierarchy, which is what you need to do. The Essbase admin guide talks about some of the fundamentals of filters, including this.