MDX Exclude dynamic members

For the next time I try to remember how to exclude dynamic members from a MDX specification:
Filter(Descendants([Product], Product.Levels(0)), [Product].CurrentMember.Member_Type <> 2 AND NOT Product.CurrentMember.Shared_Flag)

 
4
Kudos
 
4
Kudos

Now read this

Essbase dimension consolidation codes

For the next time I forget them and spend an age looking: ASO: C Set member as top of a stored hierarchy (applies to dimension member or generation 2 member) D Set member as top of a dynamic hierarchy (applies to dimension member or... Continue →