This document provides an overview of the SAC and BPC features supported in the live connection of SAC to the BPC Embedded model(planned to be delivered in wave 2018.18, subject to change). The BPC live connection supports the analytics functions as the BW live connection. In addition, the BPC live connection supports planning functionalities in SAC and BPC.

The BPC live connection combines the beauty of SAC and BPC embedded model.

SAC analytics tables/charts can be leveraged as a client creating a highly flexible, LOB-tailored user experience.

The powerful planning engine in BPC embedded can be used to realize an advanced and complex enterprise-wide planning.

This document describes the supported and unsupported planning functionalities in the BPC live connection. For details for BI functionalities, which are not in the scope of this document, please refer to the document BW live connection. The integration supports BPC, version for NetWeaver 10.1 and BPC, version for BW/4HANA 11. BPC, add-on for S/4HANA, is not supported at this time.

Supported Planning Functionalities (white-list)

BPC embedded model / BW

Session management. The concept of the planning session is used. In one planning session a user can transfer data into the backend buffer, revert the value in buffer, or submit buffer value to database. BPC user locking is used in SAC. If one user is using the data in change mode then no other user can change the data.

Multiple Key figures. A query with multiple key figures is created as a measure model in SAC. Planning is supported in multiple key figures.

Inverse formulas defined in BW queries can be used.

Disaggregation methods in BW queries (no disaggregation, disaggregation of entered values, disaggregation of difference to entered value) can be applied when data is transferred to backend.

BW Query with currency translation. Currency translation is triggered on-the-fly when data is transferred to backend.

Work status / Data slice. BPC Work status/data slices are used. Data protected by a work status/data slice in SAC will also be protected in SAC

Data Access Profile (DAP). DAPs defined in BPC can be applied when a query is executed.. Data cells with read access only are read only in the SAC story./ Data cells with write access are input enabled in the SAC story./ Query data is not visible in the SAC story if a data cells without read/write access.

BW authorizations/environment authorizations are used.

Planning sequence when saving. A planning sequence defined in “Planning sequence when saving” is executed automatically when data is submitted to the backend.

Planning is supported in the following BW key figure types:

CURR – Currency Field in BCD Format

INT4

INT8

DEC – Packed Number in BCD Format

QUAN – Quantity Field in BCD Format

SAC

Planning on booked values / unbooked values. Data entry on booked value and unbooked value in SAC story triggers a data transfer to BPC backend buffer, and user can submit data to backend.

Save/Revert All. Data changes in the BPC buffer can be saved/reverted in the SAC story. Revert is only ‘all or nothing’, no undo of steps.

Cell lock. A cell lock can be triggered in the SAC story to allow users to prevent individual cells of the table from being updated.

Restricted measures added in SAC story are plannable. The restricted measures are converted to transient restricted key figures in the BW query.

SAC calculations measure can be created. They are not input enabled. BI functionalities can refer to BW live connection

Chart and other widgets can be created. BI functionalities can refer to BW live connection

Known unsupported Planning Functionalities (black-list)

Apart from the supported functions list, the list below is known unsupported planning functionalities. Please note the functions, which don’t appear in supported list nor unsupported list, are treated as unsupported functions.

BPC embedded model / BW

BPC BPF integration. SAC story can be added as a generic hyperlink step in BPF, however context/parameter can’t be passed from BPF to SAC hyperlink.

Execute BW planning function/sequence

BW Short Comment/Data point comments

Text-based key figures

BW local query

BW Master data query

Planning is not support in master data query.

Set Work status

Cell-based / multi-dimensional privileges

New line

Physical Deletion in the Query (particular on master data)

YTD is not supported in planning

SAC

Member on the fly

Advanced Planning (Spreading, Distribute, Assign)

Structured Allocation

Data action (incl. Advanced formula)

Data lock

Copy/Paste inside grid

Smart Copy

Version Management

Undo/Redo of steps; Undo/Redo history

Mass Data Entry

Input task

Data Point Comment

VDT

Predictive

Forecast/Rolling forecast

It is worth noting that this live connection only uses the UI of SAC, while the engine of SAC is bypassed while the BPC engine is used. All SAC features using the SAC planning engine are not and will never be supported in this scenario. To leverage these capabilities, the data needs to be replicated to SAC, using the import / export capabilities of SAC.

Assigned tags

Related Blogs

Related Questions

Thank you for your illustration, so if I choose to go for importing data from BW to SAC, I will be able to manage all the unsupported functionalities in the live connection including the VDT, just to confirm is that correct?

Hi Haitham, the unsupported functionalities talked in this blog are applied to live connection to BPC. If you go for data import instead of live connection, you are able to use SAC functionalities as data sits in SAC model.