SAP BPC 10.1 Embedded Model - A Snapshot of Consolidation Functionality

[chemicala_srimallikarjuna]

This blog will provide a snapshot of the SAP BPC Embedded – Consolidation functionality, as SAP released BPC SP09 for NetWeaver BW 7.4 and NetWeaver BW7.5 SP02.  SAP BPC Embedded is also integral part of SAP Integrated Business Planning (IBP), also known as SAP IBP for S4/HANA, which integrates financial planning, Sales planning, Manufacturing planning, Procurement planning etc.

The following consolidation components and functionality are enabled in 10.1 BPC embedded:

• Consolidation
• Journals
• Ownership management
• Dimension management
• Business rules
• Task Sequence
• Controls
• BPF Integration

The Consolidation functionality in BPC Embedded is same as the consolidation functionality in BPC Standard/Classic version.  The objects need to be created in BW and will be mapped in BPC including related “models” (Consolidation, Ownership and Rates), dimensions and dimension properties.

1. Environment:   The  Embedded Shell  consists of Consolidation and planning models.

2. Administration: The consolidation features which are enabled Rules, Business Process Flows   and Journals, which is similar to  BPC Standard/Classic version.

Modeling: To modify the consolidation model, need to set the references to InfoProviders/ Relatime infoCubes that exist in SAP Business Warehouse (BW) (Rates, Ownership, and Consolidation)

Modify the Model:

Mapping of Dimensions & Member Properties with   InfoObjects & attributes:  The configuration is similar to BPC10.1 Standard/Classic version functionality for Dimension type, Hierarchy, attributes

After Mapping, save and Validate Model:

Advance Settings: Includes Integration Mode, Parameters, Default Trading Partner

Integration Mode

Parameters:  For Example; Mapping of Fiscal Year period in BPC to Fiscal year Variant with compounding member in BW ; K1

Default Trading Partner: Enables, to assign the default trading partner.

Dimensions:  The Configuration to edit the dimension members, Hierarchies & View structure is Similar to 10.1 Standard/Classic version.

Business Rules: The Configuration is Similar to 10.1 Standard/Classic version.

Methods & Method Based Multipliers: : Configuration is Similar to  10.1 Standard/Classic version

Business Rules: Account based calculations, Currency translation, Intercompany bookings, eliminations & Adjustments, Carry forward configuration Same as 10.1 Standard/Classic version, Based on mapping of the members of infoObjects

Task Sequence:   The new feature task sequence is added , which needs to be configured based on configuration rules, on running the Execute button in consolidation monitor which simulate  the consolidation tasks in sequence which are already configured in the business rules.

Consolidation : The Configuration is Similar to 10.1 Standard/Classic version

[Former Member]

Nicely Documented Mallikarjuna,,,,

Waiting to see more..

Thank You.

P J R

[chemicala_srimallikarjuna]

,

Thank you very much P J R,Surely will come up  with relevant blogs soon.

Regards

[Former Member]

Hi Chemicala,

Thank you. I am very new to SAP and the product I will be working in would be SAP BPC. This was an eye-opener. Can you suggest links for a beginner like me to understand the basic workflow? Like exactly the steps involved in a BPC application and what each step does and why is it necessary?

Regards

Kiran

[Former Member]

Could you post some information about the steps of create the consolidation cube, ownership cube and rate cube in BW? since the above blog does not include this part and most of us does not familiar with this part.

Tannks.

[Former Member]

Hi Reddy Garu

Nice one, many more to come.

Regards

Ramanath

[chemicala_srimallikarjuna]

Hi Kiran,

Thanks for comments. Sure, I will send some useful links which will helps to understand SAP BPC in detail.There are quite few documents ( Blogs,wiki) are available in SCN as well.

Regards.

[chemicala_srimallikarjuna]

Hi Jian,

Sure, I will come up with subsequent blogs about the SAP BPC ;   Step by step configuration for Consolidation & planning .This blog will highlights and quickly run through the consolidation functionality , which is a new feature and  available in SAP BPC 10.1 -Embedded ;SP9 on-wards.

Regards

[chemicala_srimallikarjuna]

Hi Ram.

Thank you. Sure..

Regards

[Former Member]

Thanks for your quick response,I am working on a BPC for S/4 HANA project and there is a standard planning cube /ERP/SFIN_R01 from SAP, are there standard cube for consolidation,ownership and rate cubes from SAP as well? I did find them in the business content now, it will be much easy if we can use the standard cube in consolidation.

[Former Member]

Another question I have is that since in S/4 HANA, BPC and ECC will share the master data and transaction data, do you know if the client number for ECC and Embedded BW has to be the same client? in our current project, our basis team installed the ECC and BW  in different client, all the ECC data cannot been access from BW, ca you through some thought on this subject?

Thanks

[former_member192555]

Please, refer to the source from where you got the screenshots :lol:

Quick Overview of Consolidation for BPC Embedded - YouTube

[markus_harasim]

Hi, did anyone get the ConsMonitor to Work? My Refreshing wheel just keeps truning infintively.

[William_Yu]

Hi Reddy,

  I'm sorry that IBP has nothing to do with BPC, IBP is S&OP planning.  The corret product name shall be SAP BusinessObjects Planning and Consolidation optimized for S/4 HANA.

Best regards, William

[Former Member]

Hello Chemicala,

What is the release date of SAP BPC Consolidation Embeded version.

Kind Regards,

Navendu

[former_member192464]

Navendu,

BPC Consolidation Embedded version is already released - you need SP9. Also SP10 has recently been released with some additional functions

[Former Member]

Hi Chemicala,

Thanks very much for the documentation, I am wondering how can we trigger the business rules as we do it by triggering data manager packages in classical model.

Will appreciate the feedback.

Regards

Kadir

[Former Member]

Does Anyone know if there is a demo cloud or SAP CAL that has BW 7.5 SP02 or BW 7.4 SP09. Or do I need to apply patches in the cloud appliance instance - I am running the BW 7.5 SP01 SAP CAL instance...

All advice very much welcome

Thanks guys

Azim

[Former Member]

Hi Chemicala, Thanks for sharing this valuable information. What would be the programming language for the BPC 10.1 embedded with consolidation version?

BPC embedded has FOX (powerfull due HANA)

BPC Standard has scriipt logic (performance not realy good and limited)

So I'm wondering which coding will be the future for BPC 10.1 Embedded with consolidation.

Thanks!

BR-Hassan

[blu_taz18]

Hi,

I would like to clarify if this Consolidation is already available under the SAP BPC 10.1 Embedded stand-alone premise and/or SAP BPC 10.1 Embedded on the S4 HANA and is it officially released?

Because as per SAP Roadmap last May 2016 , Consolidation in SAP BPC 10.1 inside S4 HANA is only at the plan stage (not yet available).Kindly enlighten me.

And does the Environment Shell in BPC 10.1 Embedded included Consolidation Models?How can I download that?

Thank you in advance.

Regards,

Mitch

[blu_taz18]

Hi,

Its ok now , please see link for other details on SP09

https://websmp130.sap-ag.de/sap/support/notes/convert2pdf/0002204013?sap-language=EN

Regards,

Mitch

[damovand]

Hi,

You can already use Consolidation functions in SP09+, but you have to create the required models from the BW side.  I did this recently and created all the attributes and dimensions like Account, Group and three cubes Consolidation and Ownership and Rate using RSD1.  After that I used BPC web client Administration functions and populate the dimensions.

Regards,

Leila

[Former Member]

Hello Reddy,

I need a small clarification regarding dimensions, earlier in classic version we get all the dimensions pre installed or ready-made. Do we have the Business Contents available in BI 7.5 for all consolidation objects.

Regards,
Navendu
 

[Former Member]

Hello Reddy,

Thank you very much for your contribution with this document.:-)

We are going to start a new project in BPC 10.1 consolidation in S / 4 HANA, but we have doubts about how to start modeling (infocubos, infoobjetos, ...) in the part of BW for the consolidation project, you could provide a little help on how to parameterize the modeling in the BW part?

Thank you very much!

[Eyal_Feiler]

Thanks for the helpful summary.  You noted that Controls and the controls monitor are available in the Embedded model, but as of SP11 it I don't see that it's available.  Also the screenshot under #2 does not show Controls so I assume not.

2) My understanding is that integrated consolidation is not yet available in S/4 Finance.  Do you have any updated information?

Thanks again!

[former_member398162]

Hi Leila

would you be able share the SP09+ consolidation snapshots?

[former_member182305]

Hello,

Very Nice document, I have a question tho. I am trying to create Dimensions in BPC but it won't appear with the ID as it did before (/CPMB/....) instead it has numbers. How do I create a Dimension in the Embbeded model?