cancel
Showing results for 
Search instead for 
Did you mean: 

EPM report question

Former Member
0 Kudos

Hi,

I need to write this report:

The first part is no problem, the selections are

  • list of accounts based on a property value
  • entity from context
  • all intco members which have a value in the entity property

The second part on itself would be no problem either

  • list of accounts based on a property value
  • intco based on entity in context
  • entity property valule for all intco members with a value in entity property

But how can I bring the two together so that the entity in the second part is that of the intco in the first part?

Thanks,

Arnold

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi Arnold,

With static matrix you can do the job:

First report will have fixed number of columns equal to number of intco

Second report will have same number of columns, but entity will be delivered from first intco row.

=EPMOlapMemberO(C1,...)

Vadim

Former Member
0 Kudos

Hi Vadim,

but what happens when a new entity/intco is added? Is there a way to have the report show that automatically? I.e. is it possible to have the intco selection in the first report dynamic (all base level of total) and have the second report expand correspondingly?

Thanks,
Arnold

former_member186338
Active Contributor
0 Kudos

Something like:

ENTITY member formula in the second report

=EPMOlapMemberO(EPMMemberProperty(,EPMMemberID(B3),"ENTITY"),"[ENTITY].[PARENTH1].[XXX]","XXX","","001")

Where B3 - INTCO member cell in the first report.

Vadim

former_member186338
Active Contributor
0 Kudos

You can try to use EPMDimensionOverride on the second report - constructing the member list for Entity using Local member in the first report with INTCO ENTITY property (concatenation of cells).

Vadim

former_member186338
Active Contributor
0 Kudos

Result:

1. Create a local member for the first report:

Assuming that TITLES=INTCO, BLANBE=ENTITY:

=EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(INTCO), "ENTITY")&IF(C$9<>"",","&C$9,"")

The report will be:

Vadim

former_member186338
Active Contributor
0 Kudos

P.S. For sure you have to also override INTCO dimension for second report:

=EPMDimensionOverride("001","INTCO","ENTITY="&$B$8)

Where $B$8 - Entity member selected in context.

Vadim

Former Member
0 Kudos

Thanks Vadim, that works very nicely.

Answers (0)