EPMALLMEMBERS and EPMSELECTMEMBERS when to use which

[Former Member]

I have been trying to find information on these two commands in order to understand how each of them work and when to use which command.

We do a lot of reporting where will show a list of entities and then the parent.  We have been using EPMALLMEMBERS in order to preform a checksum but I am wondering if there is a better way.

(SUM(EPMALLMEMBERS)/2)-Parent = 0  if it is other than zero there is an entity missing. 

[alexander_b_white]

Hi Ann,

These two keywords will behave identically when applied to a report with only a single dimension in the related axis.  The difference between them becomes apparent when applied to reports with multiple dimensions in an axis.  In short, EPMALLMEMBERS will always sum up all the rows, whereas EPMSELECTEDMEMBERS will only sum up the members within a partiuclar dimension.

For example, let's say we have a report with ENTITY and ACCOUNT nested in the row axis.  Adding a local member with the formula =SUM(EPMALLMEMBERS) will simply add up all the rows:

Entity	Account	2015.Q1	2015.Q2	2015.Q3	2015.Q4
E_1000	A_400000	100	100	100	100
	A_410000	100	100	100	100
E_2000	A_400000	100	100	100	100
	A_410000	100	100	100	100
	Total	400	400	400	400

Conversely, if we add a =SUM(EPMSELECTEDMEMBERS(ACCOUNT)) formula instead, each set of Accounts will be subtotaled.  Note that the positioning of this local member would be "Insert After" the Account dimension.

Entity	Account	2015.Q1	2015.Q2	2015.Q3	2015.Q4
E_1000	A_400000	100	100	100	100
	A_410000	100	100	100	100
	Subtotal	200	200	200	200
E_2000	A_400000	100	100	100	100
	A_410000	100	100	100	100
	Subtotal	200	200	200	200

It is also worth noting that the EPMALLMEMBERS formula is smart enough to ignore any local members, so you could use both keywords (each in its own local member) if you wanted to insert subtotals and a grand total at the bottom.

I hope this helps!

[Former Member]

Hi Ann

This document should get you started:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0f87cb7-9bde-3110-e99f-fc504e359...

The document is for BPC NW but the same should apply for BPC MS.

Stefan