Logic Script SELECT function

[albert_prats]

Hi Experts,

I need a variable that includes members of different properties. For example, dimension ACCOUNT has 4 properties: ACC_1, ACC_2, ACC_3, ACC_4.

I want to make a select that includes all members of these properties different than "". I try to make this select:

*SELECT (%ACC%, "[ID]", ACCOUNT, "([ACC_1]<>'' OR [ACC_2]<>'' OR [ACC_3]<>'' OR [ACC_4]<>'' OR [SALESFAMILY_4000_LBE]<>'') AND [CALC]='N'")

*XDIM_MEMBERSET PRODFAMILY=%ACC%

But it doesn't work. When I try to execute this script, it faild with "error on select statment".

Any Ideas?

Thanks!

[former_member186338 · Accepted solution]

Hi Albert,

Please:

At least BPC version info and SP...

Vadim

[former_member186338 · Accepted solution]

But you can always do:

*SELECT (%ACC1%, "[ID]", ACCOUNT, "[ACC_1]<>'' AND [CALC]='N'")

*SELECT (%ACC2%, "[ID]", ACCOUNT, "[ACC_2]<>'' AND [CALC]='N'")

...

*XDIM_MEMBERSET PRODFAMILY=%ACC1%,%ACC2%,...