Transaction Data Load - SAP BPC Implementation Guide

Business Scenario
In a real time business scenario, it’s common for the business users to load data into
BPC applications. In addition to using the input schedules, users can also bulk load
the data from flat files using BPC Data Manager.


BPC data manager offers a simple user interface easy for the business users to
understand. Both transaction and master data can be imported using Data Manager.
Data Manager can support many different scenarios including data manipulation
using default logic and integration with Process Chains. However, default logic and
Process Chain integration can be one time setup after which business users can run
or schedule the data load without being concerned about the technical details
behind it.

Document Objective
This guide will provide all the steps necessary to load transaction data into a BPC
application. It covers 5 different scenarios in which the data loads can happen.
There are other scenarios not covered by this guide. They can be explored once the
Fundamentals given in this guide are understood.



Click here to view the detailed document


Thanks to Jothi for his guidance and help!


Note: Instructions given in this guide need to be tested out thoroughly before being implemented.

BPC NW 7.5 Application Architecture - Highlevel Overview

• Application Set: It's a logical folder which groups all building blocks of BPC
• Dimensions: Master data tables. They are created at application set level and can be shared across applications. There are multiple dimension types and dimensions have properties and members
• Applications: They are equivalent to an Info Cube for storing transaction data; BPC Info Cubes support only one KPI (Key Performance Indicator)
• Different dimensions can be assigned to an application
• Work status can be defined at the app level
• Journals, Business Rules and Script Logic are created at the app level as well
• Reports/Input Schedules are at app level
• Work Status: They are defined at two levels (App Set and App). Useful in restricting access to the data region depending upon the status
• Security: Four major components available: Users, Teams, Task Profiles(controls the activities that can be performed) and Member Access Profiles (controls the data region access)
• Business Process Flow: This is a feature introduced in NW 7.5. Useful in process coordination
• Data Manager: For managing data import and export
• Live Reports: Useful in creating reports in a web pages with drag and drop features
• Contents Library: For posting documents, reports etc.

Disclaimer: Author takes no responsibility for the accuracy of the contents

BPC NW 7.5 Technical Architecture

Note that the diagram does not include ABAP layer.

Disclaimer: Author takes no responsibility for the accuracy of the contents.