Skip to Content
0
Former Member
Apr 07, 2015 at 04:48 PM

Epmdimensionoverride (Filter)- Multiple user selection

454 Views

Hi Friends,

My question relates to epmdimensionoverride filter.

I have 2 dimensions (Project & Cost Bank). One project can have single or multiple Cost Banks. User selection is single/Multiple Projects.

So in rows I would like to see both Project and its Cost Banks. In Cost Bank master data maintained a property PROJECT for projects and costbanks mapping.

If one project have multiple Cost Banks, I am able to get it in inputform, =epmdimensionoverride("000","Cost Bank","PROJECT=PRJ1"). Here in epmfunction 3rd parameter(filter) I passed as excel cell reference.

If user selects 2 projects, PRJ1 has 3 CostBanks(CB1,CB2,CB3) and PRJ2 has 1 CostBank (CB1). I am getting output like this.


Project CostBank

PRJ1 CB1
PRJ1 CB2
PRJ1 CB3
PRJ1 CB4
PRJ2 CB1
PRJ2 CB2
PRJ2 CB3
PRJ2 CB4

But I need output like this.

PRJ1 CB1
PRJ1 CB2
PRJ1 CB3
PRJ2 CB4

Please share thoughts.


Thanks,
Kumar