How Useful SAP BPC Related Terminology?
Useful SAP BPC Related Terminology
Below are some common terms used in BPC along with explanations and context in reference to what each term means or how it applies.
♦ Environment Shell: Environment Shell was formally known as Apshell in SAP BPC 7.5 NW. This is the baseline environment that SAP has provided as a default when a new environment is set up. The Environment Shell has standard dimensions as well as standard dimension members to get a user started with using SAP BPC.
Diagram of Home page of Admin consol for standard SAP delivered Environment Shell
♦ Models: Formally known as Applications in SAP BPC 7.5 NW this is just another word for version of SAP BPC. For example you can have a Model for SAP BPC 10.0 on Microsoft platform and one on NetWeaver platform.
Models provided in Environment shell Diagram
♦ Environments: Formally known as Appsets in SAP BPC 7.5 NW, an Environment is basically a system that you log into. For example you may have an Environment set up for Planning and Forecasting and a separate one for Consolidations. Most of the time we see different Environments set up for different uses as well as different regulatory needs (a separate Environment for US Regulatory filings and one for EU regulatory filings).
♦ Dimensions – Dimensions are considered part of the master data that is necessary in BPC. You can think of dimensions as different categories of tags associated with certain values (dimension members). Dimensions are only the category of tags that are necessary, the dimension members would be the exact tag to be placed along with the balance. Just as how tags are put in place for a blog post or a product for sale, dimension members are tags to be associated with certain financial balances that exist within the BPC system. Each dimension needs to have at least 1 dimension member (each category of tags , you need to specify at least 1 tag value).
There are standard dimension that come out of the box and you can also create customized dimensions depending on your business needs (most of the time creating a dimension will be necessary to distinguish certain balances from others when you need to report or analyze financial balances).
Diagram of Standard list of dimensions in Environment shell
The standard out of the box (Environment Shell) dimensions are the following
♦ Account: The account dimension is where you list out all of the accounts necessary for the Environment you are maintaining/ building. Typical account dimension will have the following account categories
- Disclosure/ Supplemental Information
♦ AuditTrial: Formally known as DataSource in BPC NW 7.5, this dimension is where you specify different cuts/ classifications of data. Remember that information can come from different places. The AuditTrial dimension is where you can segregate different types of information from one another to have transparency on how your total financials are made up.
Let’s say you have source information from 2 different systems, System A and System B. You want to have transparency on how much of the total came from System A and how much came from System B. In the AuditTrial dimension you can designate the different systems by establishing 2 different dimension members.
- INPUTA: This can be used as the balances from System A
- INPUTB: This can be used as the balances from System B
Again think of these as the actual tags for balances. So if you have $ 100 coming from System A and $ 50 from system B. The total will be $ 150 but $ 100 will be tagged with INPUTA and $ 50 will be tagged with INPUTB. In this sense a user has the transparency of where the balances came from and can analyze that data.
♦ Category: Category dimension is usually used to distinguish what the data should be used for. Normally Category dimension members are defined as
Although the category dimension is normally used to distinguish what the data is used for, this dimension can be up for interpretation. This dimension is just another category of tags, so you can define whatever dimension members or tags as you wish . You can define numbers or dates as the tags to determine the version or you can put in anything else to segregate your data.
♦ Entity: This dimension is used to define the different companies associated with the Environment that is maintained /built. The dimension members in this dimension should represent the associated companies (or entities) that are needed for the process you are building, whether it is consolidations or anything else.
Note: An entity does not specifically have to be a real life company. Many times the entity dimension can be made up of entities that do not exist legally. This is because as long as you have a trial balance associated with an entity BPC does not care that it does not exist legally. This is done sometimes when the subsidiaries are too small and more than 1 is combined together to form a “entity” which just means that someone combined multiple trial balances into 1 to make things easier.
♦ Flow: This dimension is used to define the different types of activity one should expect in a financial cycle. Flow is also known as movement type. The flow is really only pertaining to any balance sheet accounts such as assets, liabilities, and equity. The flow is meant to track all of the movements for each account. The reason why we need it is due to reporting requirements where either regulators or internal management need to track movements of certain accounts (i.e. cash movements in a given period).
♦ Interco: This dimension is used to define all the trading partners that need to be taken into consideration. In simpler terms, this dimension is where you list out all of your business partners and give them a dimension member (tag) to associate them with. This dimension is important when you perform legal financial consolidations. It is so you understand which companies are internal companies and which companies are outside business partners.
Note: All existing entity members should have an associated Interco member. This is because any internal company is also a business partner. Configuration is also a business partner. Configuration for consolidation rules can be setup where BPC will recognize that any transactions between entity members are taken out when reporting the consolidated financials.
♦ Product: This dimension is normally used to define different product line. This dimension’s use is very similar to that of the dimension Category, where products can be up for interpretation. You can use this dimension to tag your balances on what product line it is associated with or product number etc. The product line can be a specific product or even a more general category of a product. The amount of detail should be determined by what reporting needs are required.
♦ InputCurrency: This dimension is where you need to specify the exact list of local currencies needed to perform currency translation process. The list of input currencies normally is associated with the different entities that are present. If you have 3 entities in 3 different countries which all different currencies you need to establish the following in the InputCurrency dimension
- China: Input currency RMB
- France: Input currency EUR
- US: Input currency USD
The input currencies will correlate to the different exchange rates that you need to completed as reference data so BPC can perform the currency conversion process.
Note: This dimension is not really used as a tag for the balances but more used as a tag for the entities in the entity dimension as well as a reference to what exchange rates needs to be input. It provides what currencies can be used to tag each entity and will determine what exchange rate the entity must use when performing currency translation.
♦ RptCurrency: This dimension is used to define which currency or currencies are used as the reporting currency. Normally this dimension has the following dimension members
- LC (Local Currency): This is used to identify balances that are associated with balances coming in from the source before any currency translation has been performed.
- XXX (Reporting Currency): XXX designated any currency you may have listed in the dimension InutCurrency. The reporting currency can be any currency you desire. It is normally associated with what currency is needed to present for your reporting needs (internal or external). For example; if you need reporting for the regulatory body is in the US, the reporting currency should be USD. This tag will be the tagged for all balances that have been converted into the reporting currency from local currency after the currency translation process has been run.
Note: Sometimes the local currency and reporting currency are the same. However, the tag for them are still going to be LC and XXX. Example: If the reporting currency is USD but a company that is reported on is located in the US, balances that is associated with the trail balance for the company is still tagged with LC. It is after the currency translation process has been performed that it the new balances will be tagged as USD. Even though the balances in LC and balances tagged in USD is the same.
♦ O_Account: This dimension is used to define the different attributes needed for the ownership structures. This dimension much like the inputCurrency dimension and is not used to tag balances but more to provide as a reference to how ownership is setup in the BPC system.
♦ R_Account: This dimension is used to define the different types of exchange rates to be referenced when performing currency translation routine. This dimension is also not used as a tag for balances but more of a reference like O_Account dimension above. Though this dimension is a little different than of that input Currency, where this dimension is menat to specify what types of exchange rates should be used. So InputCurrency dimension defines which exchange rates are needed between what 2 currencies and R_Account specifies what types of rates are needed for those exchange rates.
Normally 2 types of exchange rates are necessary – End Rate and average Rate.
- End Rate is the spot exchange rate that usually taken at the end of a period and is usually applied to balance sheet items during currency conversion process
- Average Rate is usually the average rate of a given period (monthly, quarterly) and is usually applied to income statement items and balance sheet movements during currency conversion process.
♦ R_Entity: This dimension is very similar to the category dimension. However, it is used for the exchange rates only. It can used to tag exchange rates in multiple rates in multiple ways. Usually this dimension should only be used when there are complex currency translation requirements when looking at different scenarios, planning or forecasting with different exchange rates.
♦ Scope: Previously known as “Groups” in BPC7.5 NW, this dimension is used to define consolidation units. A consolidation unit is a group of entities that needs to be combined and produce consolidated financial statements. The scope is where you define what groups of entities should be considered a consolidation unit. A company can have a simple entity structure and have just 1 consolidation unit defined or it can have a very complex structure where multiple consolidation units needs to be defined.
♦ Time: This dimension is used to define the different time periods that are needed. Time dimension are normally set up as either monthly or quarterly. However, the time dimension can also have certain flexibility. You do not necessary have to have 12 months per year or 4 quarters per year. If you have a need you can setup the time dimension to have as many periods as you need.
♦ BW: BW stands for Business Warehouse and sometimes interchangeable with BI or Business Intelligence. BW is the processing layer of BPC. Think about it like this, BPC is the store front but BW is the warehouse. BPC is where the customer would perform the transactions but BW is where those transactions are processed and completed.
Diagram of List of BW objects found for Environment shell
♦ Properties: Properties are additional tags for dimensionmembers. So where dimension and dimension members are like tags to a certain balance, properties are like tags to a dimension member. Properties are used to group and categorize dimension members into a more useful way to be used in configuration or reporting.
♦ Performer: Previously known as “owner” in SAP BPC 7.5 NW, the performer is just a user who is assigned either a security role and / or to specific tasks. The performer is setup in the security section of the BPC.
♦ Web Reports/Input Forms: Previously known as “Live Reports” these are web interfaced reports and/ or input forms a user can access to perform reporting, inputting data, or analyzing their current data.
♦ Ownership Manager: The ownership manager is a new feature in SAP BPC 10.0 where a business user can adjust how entities are rolled up and how each company should be consolidated with what percentage of ownership.
Ownership Manager in administration Diagram
♦ Context: Previously known as “Current View” in BPC 7.5 NW, the context gives you the applicable selection criteria you are currently on. It will provide the user with what the currently on. It will provide the user with what the currently dimension members are selected and provide the user the ability to change any of the selection criteria for their reporting analysis. The context can be found in the ribbon in MS Office applications where the SAP EPM Microsoft Office Add-In has been installed.
♦ Controls Monitor: The controls monitor refers to a dashboard in the administration menu that provide a central view of all of the close process. The controls monitor will provide the status of each individual consolidation and if there are errors or failed controls.
Controls monitor dashboard diagram
♦ Logic Script: Logic Script is referring to a specific way of sequencing and programming calculations in SAP BPC 10.0. LogicScripts are used when someone is building a process that should be executed in SAP BPC. The LogicScript works off of MDX language.
♦Microsoft Office Add-In: This refers to the general add in functionality for Microsoft suit. Functionality can be found in MS Excel, MS PowerPoint, as well as Ms Word. The Excel add-ins can be found in the ribbons under EPM and Data Manager
Diagram of EPM Ribbon for BPC Excel Add-In
Diagram of Data Manager Ribbon for BPC Excel Add-In
♦ EPM Report Editor: EPM Report Editor is a reporting function that can be found in the Microsoft Office Add-In. the report editor is used to setup report and to perform analysis on the balances in the BPC system.
Diagram of EPM Report Editor selection Screen
All the above topics will be covered under SAP BPC Training by MindMajix