Skip to Content

filtering members out of "EPMContextMember" selection

Hi experts,

I am looking to filter out 2 members from my "EPMContextMember" section when double clicked. I am currently using a filter to show only members which ID ends in "SUB" by using EPMContextMember(,"VERSION","ID LIKE *SUB") and it is working as expected, however, now there is 2 members that need to be restricted from this filter ,XX1_SUB and XX2_SUB, and can't get it to work.

So far I'ver tried;

EPMContextMember(,"VERSION","ID LIKE *SUB,ID<>XX1_SUB,XX2_SUB)" and

EPMContextMember(,"VERSION","ID LIKE *SUB;ID<>XX1_SUB;ID<>XX2_SUB)" but they have not work as expected.

Any thoughts? Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 02 at 05:40 PM

    Not possible, the condition in EPMContextMember is very limited.

    You can create a new property in VERSION dimension and fill it by "Y" for the required members. Then use this property.

    Add comment
    10|10000 characters needed characters exceeded