EPMSelectMmeber Formula

[arun_varghese]

Hi All,

I am on BPC 10 with EPM Add-In on SP15

I have a property "JV_RECOVERY" maintained against H_COST_CENTRE dimension.

I need to select Cost Centres for which JV_RECOVERY property value is not blank. The result set is 4 members.

I tried to use the below EPMSelectMembers to filter out the 4 members, however I am not getting the result.

[rishi4892]

Hi Arun,

Use below syntax in filter.

"JV_RECOVERY<>' '"

Thanks,

Rishi

[former_member193143]

Hello Rishi,

Do you test the above syntax, I tested in my system its not working for me

find the tested syntax here below.

     =EPMSelectMember(,1,"RATETYPE<>' '","TEST")

Regards,

Saida Reddy Gogireddy

[rishi4892]

Hello Saida,

I have tested above syntax in my system for ACCTYPE and it seems to be working.

But then i have tested for RATETYPE, you are right it's not working for BLANK or EMPTY.

Regards,

Rishi

[former_member193143]

Hello Arun,

That property value JV_RECOVERY<> " ",  thing works only either in row or column or page axis only, it will not work on EPMSelectMember() function.

As far as I know, The not equal filtering will work on ID property only. not any other properties in the DIM.

Regards,

Saida Reddy Gogireddy