Skip to Content
0
Former Member
May 13, 2013 at 10:45 AM

BPC10 rows in report as an aggregate of multiple accounts

25 Views

All,

I apologize if this question sounds dummy but I'm pretty new to BPC10(Nw).

I have to do a static report with TIME in the column and ACCOUNT and FLOW in the rows. The problem is that some rows are the result of a calculation.

For example, for simplicity we keep the time fixed in the column as 2011.12 and so it's just that colum.

ROW1=> FLOW 001 ACCOUNT 100

ROW2=> FLOW 001 ACCOUNT 200

ROW3=> FLOW 001 ACCOUNT (account range from-to) 201-516

ROW4=> FLOW 009 ACCOUNT (account range from-to) 201-516

As you can see the accounts in ROW 3 and 4 are the same and only the flow is changing. So the result is the total from 201-516 in the cell.

Do you know if using the EPMOlapMemeber or any other trick I can achieve this result ? I cannot use other properties and as you can see I cannot use a hierarchy because the account from 201 to 516 are in the same range.

Maybe it's really a simple solution but I got lost !

Any help really welcome

Regards