Skip to Content
avatar image
Former Member

dynamic member property selection with EPMDimensionoverride

Hi Folks,

I have a specific question concerning the EPMDimensionoverride. I would like to use one Hierarchy for my Report. Let me say the ACCOUNT Hierarchy is PARENTH1.

The member in this hierarchy has the property A1.

I know how it works by using the Report-Editor but how can I write the EPMDimensionoverride to filter the hierarchy Members two values within A1. So A1 OR A2 - would be my desired solution but see below my examples:

If I write it like

  1. EPMDimensionOverride("000","ACCOUNT","LDEP(3,PARENTH1);A1=1;A1=2") --> there is clearly no result as I used ; and this means AND. A1 can't be 1 and 2 at the same time
  2. EPMDimensionOverride("000","ACCOUNT","LDEP(3,PARENTH1);A1=1,A1=2") --> this means I will see all members of PARENTH1 having an A1=1. And below this I will see all members having a property value of 2 BUT of all ACCOUNTs and not only of PARENTH1.

    So how do I get my desired selection of PARENTH1 with all ACCOUNT members having A1=1 OR A1=2 ?????
  3. EPMDimensionOverride("000","ACCOUNT","LDEP(3,PARENTH1);(A1=1,A1=2)") --> doesn't work. IN the Report Editor it is pretty simple I just select TWO properties by using ONE filter.

    So how to do with EPMDimensionOverride?

I am grateful for any help - thanks in advance!

Max

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 26, 2016 at 02:39 PM

    May be:

    EPMDimensionOverride("000","ACCOUNT","LDEP(3,PARENTH1);A1=1,LDEP(3,PARENTH1);A1=2")

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ryan,

      that is exactly how I did it here for the customer because they have only N and A or E (empty).

      EPMDimensionOverride("000","ACCOUNT","LDEP(3,PARENTH1);A1<>E") solves the issue for me.

      You could also think about using different values for this property such as an process prefix and work with LIKE. So it could be A1=E, PA, PK. then you could do something like A1 LIKE P*


      Thanks for all your Support!
      Max