Exporting data to SAP BPC

You can update a model in SAP Analytics Cloud, and then export it to a target model in an SAP Business Planning and Consolidation (BPC) system.

Export to these BPC systems is supported:
  • SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver (BPC for NW)
  • SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver (standard configuration only)
  • SAP Business Planning and Consolidation 10.0, version for Microsoft (BPC for MS)
  • SAP Business Planning and Consolidation 10.1, version for Microsoft (BPC for MS)
  • SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA (standard configuration only)
  • SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA (standard configuration only)
This means, for example, that you could import a model from BPC, perform planning activities and updates on the model, and then export the planning data back to the original model in BPC.

When doing this, we recommend you keep the Denote fiscal year setting as By year in which it ends unchanged, as only this setting is supported by BPC's fiscal year during data import and export.

If currency conversion was set to ON when importing BPC data, only local data will be written back to BPC; If currency conversion was set to OFF when importing BPC data, all values in the RPTCURRENCY dimension will be written back to BPC.

To export to BPC, the system must be set up correctly to connect to BPC. For more information, see Connections.

Exporting from a Write-Back Model

If you've enabled write-back to BPC, users can write data back to BPC from stories:

  1. In a story, select the (Version Management) icon on the toolbar.
  2. Click the (Save) icon for the version that you want to write back to BPC.

In an SAP Analytics Cloud write-back model, if the connection is an OAuth connection which you haven't authenticated, or your OAuth authentication has expired, then a dialog will pop up for you to enter your BPC credential and complete the OAuth authentication process. If SSO is enabled, you can directly sign in without entering again your BPC credentials.

After data is written to BPC, a refresh is automatically performed, so that the model in SAP Analytics Cloud shows all the latest data in BPC.
Note

Try not to activate BPC data on the BW DataStore Objects (advanced) or compress BPC data on the BW InfoCubes/InfoProviders at BPC side. Otherwise you might not be able to retrieve delta data from corresponding BPC model.

Users can also retrieve up-to-date data from BPC without first writing data back. For detailed information, refer to the section "Importing into an Existing Model" in Importing SAP BPC Data to a New or Existing Model.

Exporting from a Basic Model

Exporting data is very similar to importing data:

  1. Specify the connection to be used for export.
  2. Provide target model information.
  3. Map source data to the target model structure.
  4. Add filters for the source dimensions to be exported.

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

You must specify the environment and then select the model to be exported. A query is automatically generated with a predefined name. You can rename it freely.

Mapping Data

You map the source model data to the target model data in the mapping dialog.

Note
If the BPC column names aren't the same as the column names in your SAP Analytics Cloud model, you can create an extra property column, with names that match the names in BPC. Then when you export the data, you can map the new property column to the BPC columns.

Define the mapping in the following fields:

  • Target Dimension: In this area, you can select the target BPC dimensions to map to the source dimensions. Matches are automatically suggested by the system, but you can change them.
  • Source Dimension: Lists the dimensions in the source model. If you choose the option Not Mapped, you need to specify a default member for the target dimension to write data to.
  • Filter: You can set a filter for each column to control how much data is exported.

Select the Export blank values check box if you want to include in the export any members where the name given by the property column is blank. If you select this check box, also choose what you want to replace the names of those members with from the Replace with field.

After you complete the data export, if you want to schedule the execution of export jobs, follow these steps:

  1. Before you start to schedule the export jobs, we recommend you first check about the BW lock server settings configured in BPC. Export jobs sometimes can result in a large amount of data written back to BPC in parallel, which might exceed the limit of BW lock server settings. Usually in this case we recommend you go to transaction code RSPLSE and set "Lock attempts" to 3 and "Wait time in seconds" to 5. For detailed steps, refer to the note 928044 Information published on SAP site
  2. Select an export job.
  3. Select (Schedule Settings), and choose between the following options:

    Frequency Description
    None Select this option when you want to export the data manually.
    Once The export is performed only once, at a preselected time.
    Repeating The export is executed according to a recurrence pattern. You can select a start and end date and time as well as a recurrence pattern.
  4. Select Save to save your scheduling settings.