Script logic question: filtering out members from hierarchy

[aditya_ponnala]

I am writing below logic to filter out cost element 440999 in hierarchy: PROD. However I am not successful. Is there a better way for me to filter out certain base members of a hierarchy so that my logic can be executed on filtered in members only?

*SELECT(%CE%,ID,COSTELEMENT,ID=PROD and ID<>440999)

*XDIM_MEMBERSET COSTELMNT = BAS(%CE%)

[former_member186338 · Accepted solution]

Sorry, but looking in your code I can see that you are doing something strange. Can you explain, what do you want to achieve?

You can scope all bas (PROD) and then

When COSTELEMENT

IS <>440999

....

[former_member186338 · Accepted solution]

P.S and silence...

[aditya_ponnala · Accepted solution]

Sorry, I do not see any notification until I come back to see if there is an update; hence the delay.

Requirement: Copy the data for all cost elements in the node except for 4 accounts/Cost elements.

I see your logic with when condition. I will try and let you know if it worked.

Thanks!

[aditya_ponnala · Accepted solution]

This filtering worked; thank you!

So, without when condition we cannot filter out the members from scope?

[former_member186338 · Accepted solution]

It's the simplest method for this case.