BPC Report - Single Line with multiple members

[Former Member]

Product: SAP BPC 10 NW

Hi,

I need setup a report as detailed below:

I appreciate i should be able to create a static report to cover the top headers as they are base members (http://scn.sap.com/community/epm/planning-and-consolidation-for-netweaver/blog/2013/03/01/static-rep...)

However, how can i setup the left headers as it is a combination of multiple entities added up? There is no hierarchy which adds up the combination i need.

		Full Year	Full Year	Current Month	Current Month	Year To Date	Year To Date
		ACTUAL	PLAN	ACTUAL	PLAN	ACTUAL	PLAN
Account	Entity
1	A & B
2	C
3	D & E

Thanks,

[former_member186338 · Accepted solution]

Hi Leo,

It's impossible to combine members in row axis (like Entity A & B) - only page axis allows this. You have to create hierarchy parent for A and B in Entity dimension and then use it in report.

You can use same static approach for row axis.

B.R. Vadim

P.S. And for sure you can get data for A and B in separate lines, calculate sum using Excel formulas and hide original A & B lines....

P.P.S. And you can create a local members for each sum...

[Former Member · Accepted solution]

Hi - in this approach is there any advantage in using local members to do the sum rather than excel formuals as it is a static report?

[former_member186338 · Accepted solution]

Not a big advantage because in both cases you will have to hide original rows for A and B and show only the row with sum. The report will be static in both cases.

Vadim