Skip to Content

In this blog, I will introduce BPC and SAC integration solution. BPC is the strategic planning solution in on-premise area and SAC is the strategic planning in Cloud area. Hence hybrid solution of SAC and BPC is combination of two best worlds.

BPC Standard Model

Integration Types


The BPC to SAC import/export was developed to have a smooth way to replicate Financial planning models or parts of them to SAC. BPC plays the role of corporate planning and SAC plays the role of line-of-business (LOB) planning. These financial planning models are typically not that huge in BPC.

Typical workflow is like:

  1. To prepare import/export workflow, IT should setup the connection in SAC.
  2. LOB acquires Corporate planning target data. The data acquired is usually part of corporate planning data via filtering in import process. You can setup a schedule to do the import from BPC model to SAC model on a regular basis.
  3. LOB does planning process internally. LOB can add more master data for local planning purpose. SAC advanced planning capabilities(spreading, allocation, powerful table, version management…) could be fully leveraged.
  4. LOB submits its final planning data back to corporate. The planning functionalities in BPC can be leveraged, such as script logic.


A writeback model is introduced for semi-live integration between BPC and SAC. In order to have semi-live integration, the master data should be consistent between SAC and BPC.

Refer to blog:

What are not replicated

  1. Data access profile can’t be replicated automatically from BPC to SAC.The data access profile is designed differently in BPC and SAC, hence it’s not feasible to replicate data access profile. BPC DAP can be set via hierarchy formula, member filter and attribute filter. SAC DAP currently can be set via member filter. Apart from it, it’s technical challenge to get the SAC users from BPC users to assign data access profile to users.
  2. Member formula can’t be replicated automatically from BPC to SAC. Member formula has different syntax in BPC and SAC. It’s not feasible to convert the member formula from BPC to SAC.
  3. Calculations defined in EPM plugin in AO can’t be replicated to SAC.
  4. Script Logic can’t be replicated. The Script Logic in BPC and Advanced Formula in SAC can be used separately in the planning process.

What are recommended

  1. BPC and SAC integration is targeted to replicate planning model, whose data volume is usually not huge.
  2. Detailed data could be aggregated in BPC and replicated to SAC to avoid mass data in import/export to gain a better performance.
  3. Replicating data on-demand instead full data from BPC to SAC via filtering in import process to gain a better performance.

What are not recommended

These scenarios are not recommended in BPC/SAC integration:

  1. Import BPC data to SAC on regular basis for BI purpose.
  2. Import BPC YTD model to SAC (period model) . Converting from YTD to Periodic is quite time-consuming. And BPC YTD model is usually used as Consolidation model, which is not planning scenario.

Long-term strategy

The long-term strategy is to migrate BPC standard model to SAC model. Once SAC is feature wise comparable with BPC (such as business workflow, advanced formula, data locks…), BPC customers are highly recommended to migrated BPC model to SAC.

To report this post you need to login first.


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

  1. Vadim Kalinin

    To my mind the process is not as simple as described in the article. In the real life LOB use a lot of additional calculations in Excel files to generate forecast figures. And additional calculations can’t be reproduced in SAC.


    1. Patrick Favre

      For your information, I recommend you to have a look at the latest and greatest features of SAC in the last 2-3 waves…especially around Excel-like calculations that could be dynamically part of a table… as well as usage of Analysis for Office 2.7 on top of SAC planning models… This would be very useful in your context.

      1. Vadim Kalinin

        I am talking about practical approach: you have some complex business process with many steps and conditions and you want to somehow plan the finance result. Currently you create a process model in Excel, using all Excel features to provide flexible calculations. LOB users will receive Excel template with number of cells marked to enter model parameters. After entering data finance figures are calculated using Excel formulas and LOB user can see resulting figures immediately. Then the user can push the button in Excel with EPM/AO to save results in BPC standard model.


  2. Lucas Costa

    Hi Shen,

    Can you clarify the point “not recommended”:

    1. Import BPC data to SAC on regular basis for BI purpose.

    One of the biggest business case in using SAC as a BPC client is actually, to leverage the analytics capabilities of SAC.


Leave a Reply