Forum Discussion

otmaneoirda's avatar
otmaneoirda
New Contributor
4 days ago

Member expansion on the "Remove" Function Alternative

Hello Community, I'm writing a rule to copy data from one scenario to another using api.data.calculate. However, I would like to exclude some accounts from being copied. Something like the follow...
Finance
sameburn's avatar
sameburn
Contributor III
4 days ago

Hi otmaneoirda 

You can pass your expansion e.g. A#Root.Base into this api e.g. api.Members.GetMembersUsingFilter(dimPk, memberFilter, dimDisplayOptions) to return a list of members, based on your filter.

You can then create a comma separated list of these members and pass them into your ADC e.g. A#Root.Base.Remove(A1,A2,A3, etc), similar to MarcusH  suggestion

Hope this helps

Sam