Skip to Content
Author's profile photo Sri Mallikarjuna Reddy Chemicala

SAP BPC 10.1 Embedded Model – A Snapshot of Consolidation Functionality

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.

ENV.jpg

E2.jpg

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

E3.jpg

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)

E4.jpg

E5.jpg

Modify the Model:

E6.jpg

E7.jpg

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

E8.jpg

E10.jpg

E9.jpg













After Mapping, save and Validate Model:

E11.jpg

E12.jpg

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

E13.jpg

Integration Mode

E14.jpg

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.

E15.jpg

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

E16.jpg

E17.jpg

E18.jpg

E19.jpg

E20.jpg

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

E21.jpg

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

E22.jpg

E23.jpg

E24.jpg

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

E26.jpg

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.

E28.jpg

E29.jpg

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

E33.jpg

E32.jpg

E34.jpg

Assigned Tags

      26 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nicely Documented Mallikarjuna,,,,

      Waiting to see more..

      Thank You.

      P J R

      Author's profile photo Sri Mallikarjuna Reddy Chemicala
      Sri Mallikarjuna Reddy Chemicala
      Blog Post Author

      ,

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

      Regards

      Author's profile photo Former Member
      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

      Author's profile photo Sri Mallikarjuna Reddy Chemicala
      Sri Mallikarjuna Reddy Chemicala
      Blog Post Author

      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.

      Author's profile photo Former Member
      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.

      Author's profile photo Sri Mallikarjuna Reddy Chemicala
      Sri Mallikarjuna Reddy Chemicala
      Blog Post Author

      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

      Author's profile photo Former Member
      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.

      Author's profile photo Former Member
      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

      Author's profile photo Former Member
      Former Member

      Hi Reddy Garu

      Nice one, many more to come.

      Regards

      Ramanath

      Author's profile photo Sri Mallikarjuna Reddy Chemicala
      Sri Mallikarjuna Reddy Chemicala
      Blog Post Author

      Hi Ram.

      Thank you. Sure..

      Regards

      Author's profile photo Emiliyan Tanev
      Emiliyan Tanev

      Please, refer to the source from where you got the screenshots 😆

      Quick Overview of Consolidation for BPC Embedded - YouTube

      Author's profile photo Markus Harasim
      Markus Harasim

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

      Author's profile photo William Yu
      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

      Author's profile photo Former Member
      Former Member

      Hello Chemicala,

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

      Kind Regards,

      Navendu

      Author's profile photo Leila Lappin
      Leila Lappin

      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

      Author's profile photo Kiran Bollapinni
      Kiran Bollapinni

      Hi Leila

      would you be able share the SP09+ consolidation snapshots?

      Author's profile photo Axon Active
      Axon Active

      Navendu,

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

      Author's profile photo Former Member
      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

      Author's profile photo Former Member
      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

      Author's profile photo Former Member
      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


      Author's profile photo Austin Michelle U. Lim
      Austin Michelle U. Lim

      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

      Author's profile photo Austin Michelle U. Lim
      Austin Michelle U. Lim

      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

      Author's profile photo Former Member
      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
       

      Author's profile photo Emilio Cano
      Emilio Cano

      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!

      Author's profile photo Eyal Feiler
      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!

      Author's profile photo Sebastian Montero
      Sebastian Montero

      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?