Skip to Content

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

To report this post you need to login first.

25 Comments

You must be Logged on to comment or reply to a post.

      1. Kiran Sarma

        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

        (0) 
        1. Chemicala Srimallikarjuna Reddy 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.

          (0) 
  1. Jian Bai

    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.

    (0) 
    1. Chemicala Srimallikarjuna Reddy 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

      (0) 
      1. Jian Bai

        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.

        (0) 
      2. Jian Bai

        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

        (0) 
  2. 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

    (0) 
    1. 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

      (1) 
  3. Axon Active

    Navendu,

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

    (0) 
  4. Kadir Sen

    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

    (0) 
  5. Azim Khan

    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

    (0) 
  6. H. Laktit

    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


    (0) 
  7. Mitch 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

    (0) 
  8. NAVENDU TRIPATHI

    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
     

    (0) 
  9. 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!

    (1) 
  10. 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!

    (0) 

Leave a Reply