Skip to Content
author's profile photo Former Member
Former Member

EPMCONTEXTMEMBER "OR" filtering

Hi Experts,

I need to use a filter in function EPMCONTEXTMEMBER that shows the sum (OR) of two conditions.

here is the example:

  • condition 1: PROFIT_CENTER.BU = BU1
  • condition 2: PROFIT_CENTER.BU = BU2, PROFIT_CENTER.PLAN = Y

I would like to receive in the member selector of EPMCONTEXTMEMBER all the Profit Centers that belong to BU1, plus only the Profit centers of BU2 with PLAN equal Y

have you ever faced the same problem?

is creating a new property the only solution to my issue?

thanks for your help

Daniele

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jul 22, 2016 at 08:24 AM

    "I would like to receive in the member selector of EPMCONTEXTMEMBER all the Profit Centers that belong to BU1, plus only the Profit centers of BU2 with PLAN equal Y" - not possible!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2016 at 06:13 AM

    Hi Daniele,

    here is one working example: AND ; condition

    Please note you can use only AND or only OR throughout the condition. Cant use both together. As the document suggested by Andy also shows it....Tested in system.

    Regards,

    JP


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 05:31 PM

    Hi Daniele,

    Is PLAN another property of PROFIT_CENTER dimension??

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2016 at 03:56 AM

    Hi Daniele,

    You can combine those conditions in one line with and (;) or (.) symbols.

    no need for new property.

    Dimension Override based on dynamic selection with multiple properties

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, I already saw that document but it is referring to function EPMDIMENSIONOVERRIDE.

      I am not able to replicate on function EPMCONTEXTMEMBER.

      please see below:

      in the first case the member selector shows the correct dimension members, in the second case as you can see seems that the format of the filter is not valid and it is not applied at all.

      many thanks for your contribution.

      img1.PNG (38.3 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.