Xdim_memberset question

[Former Member]

Hello, I am trying to write xdim_memberset statement where abc property of account dimension has to be Yes. I have tried few diff ways such as

ACCOUNT.ABC = Y, [ACCOUNT].[ABC] = Y ETC... but none of them work. any suggestions?

Thanks.

[JohnL · Accepted solution]

Hi Zack,

You cannot do that in an *XDIM_MEMBERSET statement.

What you need to do is use a *SELECT statement in combination with a *XDIM_MEMBERSET statement.

i.e.

*SELECT(%ACCTS_ABC_Y%, "[ID]", "ACCOUNT", "ABC='Y'")

*XDIM_MEMBERSET ACCOUNT=%ACCTS_ABC_Y%

Validate and Save your LGF file and then review the LGX file to see what the variable %ACCTS_ABC_Y% retrieves.

Thanks,

John