Skip to Content
0

Function to use

Dec 06, 2016 at 11:07 AM

69

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Dec 06, 2016 at 11:20 AM
0

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"?

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 06, 2016 at 02:11 PM
0

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?


act.png (25.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. What is the function of cell F29?

0
Serge Bambara Dec 06, 2016 at 02:50 PM
0

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


file-1.png (5.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 06, 2016 at 03:16 PM
0

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)

Share
10 |10000 characters needed characters left characters exceeded