BPC 10.1 : How to create Statutory Report using BPC Reports in EPM

[Former Member]

Hi Expert

How to create Statutory Reports using BPC reports in EPM?

Following is sample/example format:

Regard

ISKhan

[former_member186338]

You have to create static report - look on my blog:

https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/

With static report you can change years...

For accounts:

Create extra hierarchy to represent lines of statutory report.

This is the correct answer!

[Former Member]

vadim.kalinin

Create extra hierarchy to represent lines of statutory report.

How??

[former_member186338]

imran.shafiq

Lines of the statutory report are some nodes for your existing base members.

Create a new hierarchy, add nodes and assign base members.

[former_member682599]

Activate member recognition and using excel reference to build your report.

[former_member682599]

I would first manually input the accounts and other dimensions which are necessary in certain report. Then I will activate member recognition and refer to the ID cell(just to have the EPMOlapMemberO being fulfilled automatically). In your case, there're some comparation between current year and last two years? so you can let the user select current year in context member, and use EPMMemberOffset to get the last two years. Finally, hide the "redundant" columns and rows. More details need to be paid attention to during your real practice.

[Former Member]

Hi Chao

Thanks for reply. We have 3k+ accounts so you mean we need to manually input all of them. Second when we change the year from context then all the comparative years referencing are vanished.