SAP BPC Classic/Standard model differs significantly from the Embedded model. One of the key difference is that Embedded planning uses key figure based model while BPC classic uses a account based model.
In classic BPC, Account dimension contains 4 different possible values for the Account Type (ACCTYPE) property: AST, LEQ, INC and EXP. This determines how the data is displayed and stored in solution.
- For Account Types LEQ and INC: BPC will send data into database and retrieve data via an input schedules/reports with reversing the signed data value (+/-)
- For Account Types AST and EXP: BPC will send data into database and retrieve data via an input schedules/reports without a change in the signed data value (+/-)
Configuring signage for account dimension in BPC Embedded has few configurations, the following steps will guide you on how to configure this in BPC 10.1 Embedded. This leverages the generic BW / IP (integrated planning) functionalities with Analysis for Office.
Enable signage for info object
As the first step ensure that you enable hierarchies in your info object and create the necessary hierarchy. It is important to enabled the “reverse sign for the node” option.
Now while maintaining your hierarchy in BW or in BPC Admin interface you will be allowed for maintaining signage or reversal related information. In the example below we have reversed the signage of income account (base node) and profit (parent node)
Create a new key formula
As the next step, should create a new formula under your key figure in the BEx query
Create formula variable
Edit the formula created in the previous step and create a new variable. This variable will be assigned the signage and used for changing the sign of the hierarchy nodes.
Use the following configurations. Create a variable with the following settings.
- General > Description = SIGNAGE
- Type of Variable = Formula
- Processing By = Replacement Path
- Reference Characteristic = Account
- Replacement Path > Replace with = Hierarchy Attribute
- Replacement Path > Attribute = Sign Change
Create the following formula in the newly created variable. Now enter the formula. We are trying to change the signage of ‘Amount’ key figure in the case below.
Create Input Read Formula
Make the formula input ready in the planning tab. This will create a new inverse formula property under the newly create formula.
Create inverse formula
Enter the following formula in the inverse formula section of the new formula.
The query can be published via the Analysis for office query and the same can be set as planning layout. Open the query in Analysis for office or EPM add-in and enter the following data. You will observe that Income and expense are being entered without any signage but system automatically treats them as opposite signage and aggregates correctly.
Based on the inverse formula the following data is stored in the BW cube. You should be aware of this while building more BEX queries out of this cube.
BPC Embedded provides similar functionality as the BPC classic when it comes to this aspect of SAP BPC (Business planning and consolidation). Please contact us for your implementation requirements, support or consulting requirements .