About Importing SAP BPC Data
You can import data from SAP Business Planning and Consolidation (BPC) to create new models, or to add data to existing models. Also, you can use SAP Analytics Cloud as a BPC client extension.
- SAP Business Planning and Consolidation, version for Microsoft Platform (BPC for Microsoft)
- Standard configuration of SAP Business Planning and Consolidation, version for SAP NetWeaver (BPC for NW)
- Standard configuration of SAP Business Planning and Consolidation, version for SAP BW/4HANA
To import from a BPC system, the on-premise BPC system must be specifically set up to connect with SAP Analytics Cloud. Refer to Import Data Connection to an SAP BPC System for more information.
For SAP BPC 11.0, version for BW/4HANA and SAP BPC10.1, version for SAP NetWeaver, if the BPC environment is not with HANA Accelerator on (this can be checked via environment level IMG parameter ACCELERATOR_ON in BPC system), make sure you refer to the consulting note 1858257 to enable member set functions in BPC first.
If you import data from BPC 10.1, version for SAP NW on BW 740, make sure you apply the note 2550738 in BPC system.
Before you can proceed with the import from BPC, you must have set up a connection to the BPC system in SAP Analytics Cloud Connections.
- Specify the connection to be used for import.
- If creating a new SAP Analytics Cloud model, provide target model information.
- Specify source BPC model information and build a query.
- Map source data to the new or existing model.
Specifying the Connection
You first need to select the connection to the BPC system. This can be an existing connection or one that you create on the fly during the export. For more information on creating connections, see Connections.
Providing Target Model Information
If creating a new model, you need to provide a name for the target model and optionally a description. The model name cannot start with a numeral or any other non-alphabetical symbol, such as a space.
When importing from BPC, models are by default planning enabled.
Specify Source Model Information
Next you must specify the environment, which is a set of BPC models, and the specific model to be imported.
SAC reads only periodic data from BPC as it doesn't have a YTD measure by default, regardless of whether the BPC model is periodic or YTD. There's one exception: because the AST and LEQ account types in SAC aggregate the latest data in the Date dimension, these two account types will store and display YTD values correctly in SAC.
If the BPC model is YTD storage type, like a consolidation type model, then only importing into a SAC Basic Mode model is supported.
Choose each dimension in the Source Dimensions part, you can create mappings between the source dimension and the target model dimension:
- Dimension Type (when creating a new model): The type
for each dimension. The system automatically suggests a type for some
dimensions, but you can change or set the type by choosing one of the
following options from the list:
- Account: This dimension represents the accounts structure of your organization. You can have only one dimension of this type per model.
- Organization: This dimension represents the business units that drive your business. Depending on your organization, these could be operating units, geographic entities, cost centers, and so on. You can have only one dimension of this type per model.
- Date: Specifies the smallest time period to be applied to the model. You can use year, quarter, month, or day. It is created automatically when you create a model.
- Version: This is for the Category dimension.
- Generic: Any kind of business dimension that is not an organizational one. This can include products, channels, or sales representatives. You can add multiple dimensions of this type to a model.
Once the mapping is complete, you can start the import.
Using SAP Analytics Cloud as a BPC Client Extension
In a write-back model, SAP Analytics Cloud can be used as a client extension for BPC models. You can perform planning and analysis, write your planning data back to the BPC model, and bring the newest data in from the BPC model at any time.
You can edit planning data in a public version of SAP Analytics Cloud, and when you save and publish the data, they are automatically written back to the BPC model.
Noted that a public version in edit mode cannot be updated from the BPC model.
Two options are available:
Pre-converted currency values in BPC are imported
Disable currency conversion in SAP Analytics Cloud. If the BPC data contains pre-converted currency data, they are imported into the model together with local currency value. In stories, you'll need to add the RPTCURRENCY dimension to the drill state in order to see data for all the different currencies.
Pre-converted currency values in BPC are not imported
Enable currency conversion in SAP Analytics Cloud, and choose a rate table. If the BPC data contains pre-converted currency data, they are not imported into the model. Only the local currency data are imported.