Skip to Content
avatar image
Former Member

Function to use

DIMENSION : TYPE_ACTIVITE ID DESCRIPTION ACTIVITYGROUP (PARENTH2) 10 CAB G1 11 TOP G1 12 MOB G1 13 MPT G1 14 TAP G2 15 SIT G3

In the Dimension ENTITE I have this

ID DESCRIPTION ACTIVITYGROUP 01-01-100 DRG 10 01-01-121 DRH 10 01-02-120 DAF 11 01-02-135 DIC 12 01-03-130 STH 12 01-04-100 DSE 14

In the cell F37 I have this formula =EPMContextMember(;"TYPE_ACTIVITE";"PARENTH2=G1"). When I double click in the cell F37 I have this 10; 11; 12 and 13.

What functions to use in the Dimension ENTITE in cell F29, to have this

When I select 10 in the cell F37, I must have only 01-01-100 and 01-01-121 in cell F29

When I select 11 in the cell F37, I muts have only 01-02-120 in cell F29

When I select 12 in the cell F37, I must have only 01-02-135 and 01-03-130 in cell F29



file.xml

file.xml (6.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 06, 2016 at 11:20 AM

    You have to ask the question in the readable form!

    Please attach screenshots required to understand your issues.

    "When I chose 10 in the cell F37, I want to have 01-01-100 and 01-01-121." - where do you "want to have"?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 02:11 PM

    First of all, don't attach xml files - absolutely inconvenient.

    png screenshot:

    =EPMContextMember(;"TYPE_ACTIVITE";"PARENTH2=G1")

    For example you have selected 10 CAB

    What do you mean by having 01-01-100 and 01-01-121 in cell F29:

    01-01-100,01-01-121

    or

    01-01-100;01-01-121

    or

    01-01-100 01-01-121

    or?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2016 at 02:50 PM

    With the function EPMContextMember(;"TYPE_ACTIVITE";"PARENTH2=G1"), I have this in cell F37 .file-1.png

    The function I use in the F29 is this =EPMContextMember(;"ENTITE";K27) with K27= =If(F37="TYPE_ACTIVITE:10";("TYPE_ACTIVITE=10");If(F37="TYPE_ACTIVITE:11";("TYPE_ACTIVITE=11");If(F37="TYPE_ACTIVITE:12";("TYPE_ACTIVITE=12"))))

    but it does not function correctly

    @Your question What do you mean by having 01-01-100 and 01-01-121 in cell F29: I mean 01-01-100;01-01-121

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 03:16 PM

    In F29:

    =EPMContextMember will never return 01-01-100;01-01-121 - only single member.

    if will provide user selection with some filter:

    =EPMContextMember(;"ENTITE";"TYPE_ACTIVITE="&F37)

    Add comment
    10|10000 characters needed characters exceeded