Skip to Content
Former Member
Mar 01, 2011 at 11:47 PM

Exlcude Member from Expansion


Hi All,

I'm very new to BPC, and I'm having trouble desinging a report. I would like to run a report with all Base member in the ACCOUNT Dimension EXCEPT those that belong to the member A.TOT_OFFENDING_ACCTS. I've been playing around with the expansion range of the EVDRE, but I can't see how this is possible. I see how to exclude accounts based on a property with the Build Filter feature. Unfortunately there is no property common to only these accounts, and I don't have control over the properties. I also see how to include only certain members through a list, but if I use this option I may miss members that are added later.

I haven't found any other means of filtering, and suppression seems to only relate to items with null measurements. Is it possible to exlcude certain members? This seems like such a basic request. I feel like I'm missing a big piece of information.