How to use XDIM_MEMBERSET to select all BAS members (except one)?

[TedemanCPA]

Hey Experts,

Well, this is a good question. I need to select all child/BAS members of a particular parent account being used for an allocation, but also need to exclude one or more specific members.

Does anyone have an idea how to use XDIM_MEMBERSET, XDIM_FILTER, or SELECT (or anything else) to do this? I've tried all sorts of combinations of those commands, but no luck so far.

For example, you can't do

**XDIM_MEMBERSET ACCOUNT=BAS(XYZ) AND <  > ACCOUNT123*

and the are limitations with the other commands.

Thanks in advance for any ideas.

Garrett

[Former Member · Accepted solution]

Hi Garret,

Could you create a property in your dimension to flag the members you want to select and then restrict your filter based on ACCOUNT.PROPERTY?

[TedemanCPA · Accepted solution]

Hi Sabine,

Yes, basically that's what I've resorted to doing. However, the reality is that there's a maintenance burden involved with managing a property that's used to select them. Is that really the only option?

thanks,

NOTE: I was trying to get the code to say <.> ACCOUNT123 above, but somehow I can't edit the original question right now.

[Former Member · Accepted solution]

Hi Garrett,

How about an alternative hierarchy?

[Former Member · Accepted solution]

Could you split your requirement out like this:

*XDIM_MEMBERSET ACCOUNT=BAS(XYZ)

*WHEN ACCOUNT <> ACCOUNT123

....

[TedemanCPA · Accepted solution]

Hi Sabine,

Actually an alternate hierarchy effectively has similar maintenance issues. (But, I have used that approach in the past)

thanks,

[TedemanCPA · Accepted solution]

Sabine,

You know, I've been trying to get the system to do the *RUNALLOCATION block inside of the WHEN/ENDWHEN, and it seems like the allocation block just ignores the fact that it's inside a WHEN.

That is to say, the *RUNALLOCATION is affected by the XDIM scoping, but not affected by being inside a WHEN/ENDWHEN.

That's been a real surprise to see how it behaves that way, but it doesn't really make sense

Thanks,

[Former Member · Accepted solution]

Hi Garrett,

Sorry I didn't realize you did an allocation.

In this case you should be able to stick it inside your WHAT WHERE USING statement?

ie

*DIM ACCOUNT WHAT=[PROPERTY] <.> '123'

If you can identify your exceptions via property then that should work.

[Former Member]

Hi Garrett,

Do you see if the following is suitable: After the initial scope selection using XDIM as BAS(XXXX)

in When condition you could do something like below:

*WHEN ACCOUNT 
*IS <> CA10500, FA10500 // try even using a selection variable here
*REC(........
*ENDWHEN

But if you know the accounts that you want to execute the script, please use the property option

Thanks,

Sreeni