Using XDIM_Filter for multiple member values

[Former Member]

Hi All,

Iam facing an issue when using XDIM_FILTER for filtering ACCOUNT members using the Property ACCTYPE ,Below is the code iam using ..

*XDIM_FILTER ACCOUNT = [ACCOUNT].PROPERTIES("ACCTYPE")="INC,EXP"

I want to get the Accounts data whose Account type is INC and EXP excluding other accounts..

the above code is not filtering the data and the script is being executed on all the accounts ..

I tried using *XDIM_FILTER ACCOUNT = [ACCOUNT].PROPERTIES("ACCTYPE")="EXP" and it works fine on Accounts type EXp

How do i select the multiple property values in the Filter ...

I need your help in fixing this issue ...

Thanks in Advance

Regards,

Ravi

[former_member186338 · Accepted solution]

Hi Ravi,

"How do i select the multiple property values in the Filter ..." - impossible, only single property value!

If you are creating DM package (not default.lgf) then:

*SELECT(%A%,[ID],ACCOUNT,[ACCTYPE]=INC,EXP)

*XDIM_MEMBERSET ACCOUNT=%A%

Vadim

P.S. Always provide info:

[Former Member · Accepted solution]

Thanks Vadim ...