BPC Embedded (BPC 11.0)

Business Scenario

An organization is using SAP BW/4HANA as an Enterprise Data Warehousing (EDW) platform. The EDW contains a number of models for data analytics based on actual sales, procurement and production datasets. There is a need to empower business users with sales planning capabilities leveraging the model for actuals.  

Proposed Solution  

Use SAP BPC Embedded on SAP BW/4HANA for complex planning scenarios. Disaggregate Plan values in proportion to sales actuals. Set up and customize input entry forms by user group and activity for Revenue, Expenses, Production business planning processes.  

The POC solution for sales planning in BPC embedded is based on the following architecture: ADSOs for actuals, Direct Update ADSOs for Plan data, Composite Provider, Aggregation Levels. On top of Aggregation Levels we have BW Queries that are consumed in BO Analysis for Office and BO Design Studio front-end tools for planning scenarios and business analytics. 

The following Composite Provider combines actual sales data from existing BW analytical models together with plan data in Direct Update ADSOs :

Here is a Plan input entry form example for a Top Down sales planning scenario by Product Category, Region utilizing value disaggregation in SAP HANA engine: 

To find out more on the Proof of Concept Services please Contact Us


Powered by Wild Apricot Membership Software