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.
- 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)
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.
If you've enabled write-back to BPC, users can write data back to BPC from stories:
- In a story, select the (Version Management) icon on the toolbar.
- 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.
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 data is very similar to importing data:
- Specify the connection to be used for export.
- Provide target model information.
- Map source data to the target model structure.
- 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.
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:
- 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
- Select an export job.
-
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. -
Select Save to save your scheduling settings.