How to filter a few members in EPMContextMember formula

[Former Member]

Hi All,

I just wanna apply filter a few of members in EPMContextMember formula for a dimension (called as "MT") which has "ID" & "Description" columns.

Suppose that dimension is as in the table below. And there is not any extra property in that dimension.

So could you please tell me how i can make a filter to see only B & D members whenever double-click the EPMContextMember cell?

I've tried as   =EPMContextMember(;"MT";"ID=A, B") or =EPMContextMember(;"MT";"ID=A","ID=B") but can't...

ID	Description
A	Asdf
B	Bsdf
C	Csdf
D	Dsdf
E	Esdf

Thanks in Advance my friends

[Former Member · Accepted solution]

Sadi,

You need to use a user-defined property for the filter part of the EPM function.

Try this format:

=EPMContextMember(,"MT","UserDefinedID=A;UserDefinedID=B")

This should work for you.

Please, let me know if I correctly answered your question.

Jeff

[Former Member · Accepted solution]

Jeff,

Well, I've tried and got this error  "The Property UserDefinedID does not exist!"

=EPMContextMember(;"MUSTERI_TIPI";"UserDefinedID=MT01;UserDefinedID=MT02")

Actually i've tried it as not only "UserDefinedID" but also "ID".

[Former Member · Accepted solution]

Sadi,

Sorry, but I was not clear.  "UserDefinedID" needs to be replaced by a user-defined property in the dimension you would like to filter (MT, in this case).  You will need to modify your dimension in order to do this, unless you already have a user-defined property on the MT dimension that will support your requirement.

Jeff

[Former Member · Accepted solution]

Jeff,

Now, i see what you mean. Actually, what you said is an exact solution but i wonder if there is any other solution without creating a property.

btw/ Thanks a lot

[Former Member · Accepted solution]

Sure thing, Sadi.

I am not aware of another way to do this without creating a property.

For the benefit of others using SCN, please mark correct answers as correct so they know a solution has been provided in case they are having the same issue.

Jeff