Skip to Content
Author's profile photo Daniel Jacinto

SAP BPC Embedded Consolidation

The day is 09.11.2015 and for all intents and purposes, it seems to be a fairly routine and run of the mill day. But on this inconspicuous day, was the release of SAP Netweaver 7.40 SPS 13. This SPS stack release comprises many new features to the BW platform and is considered a feature release. There has been posts detailing some of the new features and product road map updates, but I find it interesting that not that many people have picked up on or commented on the new feature, Embedded Consolidation.

Previously, it was fairly straight forward. If you wanted to do planning or use the embedded model. You were always limited to only planning, the consolidation model was only available on the BPC standard / Classic which guided your implementation approach, but the reason for my interest and blog post is to draw some attention to this new feature and capability with SAP BW SPS 13, SAP BPC Embedded Consolidation is now possible..

SPS13.png

Reference Links – https://scn.sap.com/docs/DOC-58721

Having been involved with an implementation of SAP BPC Embedded Model at a large Financial Institution. I have come to appreciate the performance, flexibility and power of the BPC Embedded model. (Please refer to the reference section below to get links to the various posts outlining and detailing the difference between the two model types) . Having the ability of having both a planning and consolidation application that leverage off of the power and performance of PAK, I can say that I am pretty excited about the fact that organizations can now start to harmonize there planning and consolidation environments and leverage off the power of PAK.

I do however believe that customers will have to carefully consider and understand the drivers for deciding which models to use in their implementation. It will require careful consideration especially in light of the technical requirements and skills required for the implementation of the SAP BPC Embedded models.

I do believe that having both embedded models in the same namespace as SAP BW along with the flexibility that the it provides you, is pretty powerful motivation to consider the embedded consolidation model in itself. There is a multitude of scenarios in which having the planning and consolidations cubes in the same multi / composite provider will facilitate reporting and reduce much of the problems of moving data between models. I can remember scenario’s in which having to write tedious script logic to move data between the different models and conversely how incredibly easy it was to see and move data across different models in the embedded model using FOX and as a result of using Multi / Composite providers in the data model design.

In addition, the ability to call SQL in FOX or SQL Exit CR are pretty compelling reasons in itself for choosing the embedded models in solving a lot of the limitations of the classic BPC models. I look forward to seeing more features and functionality being added to the embedded model, along with hearing some of the customer success stories of the new implementations of using the embedded consolidation model.

SAP Support Product Availability Matrix

PAM.png

Reference Links

SAP Notes –

2240919 – Release Note for Netweaver 7.40 SPS13

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/spat/index.htm?sp1=SAPKW74013

http://scn.sap.com/docs/DOC-58899

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Durgaprasad Goka
      Durgaprasad Goka

      Thank you for the info Daniel Jacinto

      Author's profile photo Venkat Singanamala
      Venkat Singanamala

      Hi Daniel

      Thank You very much for your information and I am very happy for the importance of Consolidation in Embedded version.

      < Planning and Consolidation  Functions/Features  are heart of the BPC irrespective of Versions  and Now Embedded is "All in One Solution">


      I am glad that SAP has been recognized Consolidation and brought  into Embedded version

      Author's profile photo Former Member
      Former Member

      Hello Daniel,

      Nice information shared. Thanks.

      Author's profile photo Former Member
      Former Member

      Hi Daniel,

      Thank you for the information.

      Regards

      Author's profile photo Former Member
      Former Member

      Great Info Dan.

      Cheers

      Nikhil

      Author's profile photo Geeta Sharma
      Geeta Sharma

      Thank you so much for valuable information.  Sorry if it is basic question , how about Equity pickup and Ownership calculation. Are these features part of other SP levels or i am missing something.

      Author's profile photo Former Member
      Former Member

      Geeta,

      Currently in current version of Embedded Consolidation Equity pickup is not supported but I am sure it would come up later sometime.

      Regards

      Nikhil

      Author's profile photo Former Member
      Former Member

      Hi Daniel,

      It seems I have to upgrade to Embedded version of BPC.

      Very good post.

      Thanks

      Narsi

      Author's profile photo Former Member
      Former Member

      Nice one Dan.

      Author's profile photo Former Member
      Former Member

      Hi Daniel,

      Just a note, I see this is only due for release 2016 Q2

      Cheers,
      Andries

      Author's profile photo Former Member
      Former Member

      Hi Daniel,

      thank you for the valuable info. Is someone in the community aware of an official document or website where the consolidation funcionalities of both, embedded and stadard are compared or litsted? Would really appreciate that.

      Kind regads,

      Boris

      Author's profile photo Former Member
      Former Member

      Hi Daniel:

      Thanks for the Blog and was very helpful.

      Have question related to Embedded vs Real-time Consolidation.

      1. Can we follow the Note_2243472 to create Embedded Cons model and later will be able to migrate to S/4 Real-time consolidation?.And where can I find the list Infoobject & other object used for S/4 Real-time consolidation.

      2.What is the use of Source Infoprovider in the optional section of creating Consolidation model in Embedded?

      Regards
      Venkatesh

      Author's profile photo Graham Johanson
      Graham Johanson

      Hi Daniel,

      Do you have an idea of how many customers are using embedded consolidations in comparison to other tools (classic/standard/group reporting/etc.)?  Would you recommend that a customer stay with BPC classic/standard consolidations, or move to BPC embedded consolidations if they did not want to go to group reporting?  It looks like the information around BPC embedded consolidations is scant which is concerning about the level of support and enhancement SAP might offer this product going forward.

      Thanks