Forum Discussion

Jones's avatar
Jones
New Contributor III
2 years ago

Member filter - exclude members from the hierarchy in DM export

Hey all, So we have built a data seedning between cubes for Predictive 1 2 3 and are using DataManagement data exports via Data mgmt export sequence to our input workflow profile. We have a hierarc...
Data Management
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

a#SomeAccount.Descendants.Where(Name DoesNotContain acct1 and Name DoesNotContain acct2 and Name DoesNotContain acct3 and Name DoesNotContain acct4 and Name DoesNotContain acct5)

Personally I would skip this awkwardness and use a LINQ expression in an XFBR.  If you decide to do that, post your code where this list of members is being queried. I can help you with the LINQ part.

WRT the Member Script expression, it would be easier if there were something like
'Where IsNotIn(Acct1,acct,acct3,acct4,acct5)' 
There probably is, and just not documented where I'm looking.