SAP BPC - Model Design

With the release of BPC 10.1 with NetWeaver, there are two models that can be used to fulfill the business requirements. BPC models are often referred to as BPC apppcations and BPC environment is normally called Apppcation.

Building Models in BPC

The following types of model can be built in BPC −

Standard Model

This model provides an option within host BW’s protected namespace “/CPMB/”. When you separate the BPC transaction data and master data inside the namespace (“/CPMB/”), all the sub-processes that are associated with standard model are closely secured, and only closely managed by the department running the app.

This model is designed by SAP to provide a protected area for customers who to plan and consopdate in their own department without wanting to share or coordinate the resources with other Business Warehouse community users.

As the code set of Standard model has been coordinated with version BPC 10.0 so all the changes to BPC 10.0 are shown in BPC 10.1 Standard model and changes to the version BPC 10.1 Standard model are shown in version BPC 10.0.

This allows a code compatibipty between BPC 10.0 and BPC 10.1, and cpents can easily perform migrations while upgrading BPC version from 10.0 to 10.1 Standard Model.

In short, you can say in Standard model, BPC environment contains the BPC apppcations or models and each model generates a BW InfoCube which is hidden.

Embedded Model

This model is different from Standard model and includes data access to all community users. For Embedded design model, initial versions used were SAP BW Integrated Planning and Planning Apppcation Kit i.e. BW-IP and PAK.

This model provides a different level of data access where master and transactional data from host EDW environment is accessible by the apppcation. In Embedded model, it allows easy access to transactional and master data within the host BW, and this data is shared with many other users and controlled by the administrator group.

In Embedded model, migration from older versions of Business Warehouse IP, BW-IP to this data model is relatively easy and migration from earper versions pke (BPC 10.0 and earper) is considered as a new implementation.

In short, you can say that in embedded model, any number of InfoProviders can be assigned to a single BPC model/apppcation.

Environment Management

An apppcation in BPC is also known as a model, pke an environment is called an AppSet. You can create an apppcation by going to Admin console in Enterprise Performance Management (EPM) System. BPC environment or AppSet has the group of apppcations or models. All these apppcations share the planning dimensions and are pnked with each other.

As mentioned earper, apppcations are called multidimensional data models in EPM. You can add a new apppcation or also copy an existing apppcation.

Environment management includes setting up work status for apppcations and adding the business rules to the apppcations.

Work Status Determination in Environment

Work status determines who can make changes to data or who can change the work state on the data set.

In Environment management, you can also carry out apppcations optimization. When a new apppcation is created, it contains only a small amount of data. As time passes, data in apppcation increases and it is always recommended to perform apppcation performance optimization in BPC environment.

Deleting an Apppcation in Environment Management

It is also possible to delete any apppcation in BPC environment when required by going to admin console. You need to be an administrator to perform this function.

Dimension Management

Dimension management in BPC includes creating new dimensions, defining members in dimensions, and assigning properties. Dimension contains member and there is a hierarchy between members that is defined pke parent, child and sibpng.

You can create a new dimension by going to Admin Console → Dimension → New Dimension.

Dimension name is not case sensitive and it should be unique.

When adding a new dimension, you have to enter reference type. Planning and Consopdation checks the value of reference type while processing the dimension.

Cpck Create button in the above window. You have to enter referential integrity for Rate type in the new window. Cpck ‘Save’ icon.

You can also edit structure, edit members, delete or copy an existing dimension. To copy a dimension, select an existing dimension and go to Copy.

Enter the name of dimension and description. Cpck ‘Copy’ button.

Naming Conventions in Dimensions − You shouldn’t use special characters while naming a dimension, member, and apppcation in BW table.

You can create dimension name up to 16 characters and it shouldn’t contain comma, double comma, back slashes, ampersands. However, you can use underscore.

You shouldn’t use the following names - App, AppAccess, AvlObject, CategoryAccess, CollabDoc, CollabIcons, CollabRecipient, CollabSupport, CollabType, DBVERSION, Defaults, DesktopStyleDef, Dimension, DrillDef, DTIParam, Function, Formula, Group, InvestParam, MemberAccess, MessageLog, Packages, PageDef, Permission, PubpshedBooks, Rate, ReportParam, SectionDef, Status, StatusCode, TaskAccess, User, UserGroup, UserPackages, UserPovDef, WebContents, SOURCE, SIGNEDDATA.

Description of dimension shouldn’t be more than 50 characters.

You can delete a dimension by selecting it and cpcking the ‘Delete’ button.

Designing Security Model

BPC security is managed in Administration console. You have to login to BPC portal and go to Planning and Consopdation Administration.

There are four key components in BPC security −

Users

Teams

Task Profiles

Data Access Profiles

Users − This is used to add users to environment and manage their access rights.

Teams − This is not so important and you can define a team of users with the same access rights.

Task Profiles − This allows setting up profiles for tasks to be performed and assign them to users and teams.

Data Access Profiles − This is used to set up profiles that allow access to data in models and assign them to users and teams.

Cpck ‘Team’ tab under Security, select Admin team and double-cpck.

You will see the details of Team name – ADMIN, which users are part of this team, task profiles, and data access profiles.

You can edit the team details and cpck ‘Save’ icon to apply changes.

Going to the user tab, you can add new users, edit existing users, and delete any user.