Skip to Content
0
Former Member
Jul 01, 2015 at 04:56 PM

Using XDIM_Filter for multiple member values

651 Views

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