Consolidation scenario in BPC 10 NW

[Former Member]

BPC Experts,

I am currently working on POC to demo consolidation scenario using BPC 10 NW version. I have taken scenario from my currect customer mainly master data, financial data and some consolidation tasks which are already performing in BCS system.

Currently I would like to do following tasks.

1) Load master data from R/3 to BW

2) Load financial data from R/3 to BW

3) Transform the data according to BPC requirement

4) Load master data consolidation model dimensions

5) Load the updated exchange rates from BW to RATE model

6) Perform the Balance carry forward task (Applies in first period of every year)

7) Perform currency translation task

😎 Perform inter-company elimination task

9) Perofrm Validation tasks

10) Check the final reports and approve the results

In BPC admin can set all Business rules for consolidation model but when I open the any of rule have set some parameteres which is not clear to me. I have two things to be discussed here.

1) Do I need to write a script logic for every validation rule and use the Logic script name in respective data manager packaged

2) How are the parameteres, conditions set in Business rules are linked to data manager package.

Can some one help me with these queries and can suggest me some valuable point for my POC.

Regards,

Bhaskar

[Former Member]

Hi Bhaskar

You can add the Journal templates task to showcase how Manual Adjustments Can be made in BPC.

Regards

Jigar

[Former Member]

Hi Jigar,

Thanks for suggesting.Now I included Journal step which is part of Adjustments.

Regards,

Bhaskar

[Former Member]

Hi Bhaskar,

You have listed almost all the steps, however, the sequence can be a bit different.

You dont need any script logic for the validation rules. The business rule already have a program in the back end. You just need to make the entries in the business rule table. This applies to all the business rules.

There are some process chains linked to each of the business rules. Your DM package should invoke the process chain for the appropriate business rule.

You will get more information from the below link from help.sap:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/66/ac5f7e0e174c848b0ecffe5a1d7730/content.htm

Hope this helps.

[Former Member]

Hi Nilanjan,

Thanks for sending details. I reorganize the tasks which looks valid to perform consolidation tasks.

1. Carry forward (Starting of the year)

2. Validation rules

3. Currency translation

4. Adjustments (Using Journals)

5. Intercompany elimination

Correct me if I am wrong with this process.

Regards,

Bhaskar