BPC Live Connection is a important feature that allows SAC user to directly access BPC data from SAC UI. Now only BPC Embedded Model supports Live Connection. BPC Standard model can integrate with SAC with Import/Export or real time write-back.
SAC client is connecting to SAC and BPC server both through INA service. The request is distributed by the proxy server and handles correspondingly.
This setup allows the hybrid usage of BPC and SAC for a customer who has different types of end user environments. For example end users who doesn’t have Analysis Office client, they can access BPC from SAC client.
Target BPC Release
BPC Embedded Model on all NW and BW/4 releases.
A new type of live connection is introduced to support BPC:
Below is the dialog of how to create BPC Live Connection. The Path below is the alias you have defined for your BW in the reverse proxy.
Below is the Model creation dialog, when you choose SAP BPC and the connection, SAC will retrieve all available environment/model list from the BPC server for you choose.
After Import, you can review the dimension and measures in the Modeler. The dimensions are the InfoObject being used in Row/Column/Free of the query. The Measures are the keyfigures or formulas used or defined in the query.
The dimension and measures information are being read from the BPC server when you open the model in Modeler. So if there is any change in your remote query, you can open your query here and save it again. Then the changes will be synced in SAC.
*A tip here is to name your model really carefully. Because once it’s created, you’ll no longer be able to rename it. Another good habit is to maintain the BPC/Connection/Query information in the description. When you create multiple models in SAC, sometimes it’s difficult to locate the one you want to work with because there is no BPC related filter information in the model list page.
You can actually change the underlying query by changing the data source. However this might be a bad idea if you already have created a serious of stories on top of the model. This might break all your stories which means you’ll have to rebuild them one by one. So in spite of the flexibility, I would say you should really careful about it.
Today the major BPC features are already supported by SAC. For example Basic manual planning, dis-aggregation, all types of key figures/formuas. You can even use SAC formulas for convenience.
BPC features supported:
- Data slice
- BW locking
- Calculated keyfigures
- Inverse formula
- Restricted keyfigures
- Query prompt
SAC features supported:
- Tables/Charts and all available controls on the BPC Live Connection Model
- Cell locking
- SAC input formulas
- Calculated Measures
- Revert/Discard data change
There are still few missing features by far. For example Spread in SAC and triggering planning functions in BPC are not supported yet. But it won’t take long to have them in SAC.
Last but not least
This is an important move on the SAC side to support the hybrid planning scenario for BPC customers. We look forward to feedback and recommendations from you. Please feel free to leave your comments.