Signage for Account in SAP BPC Embedded (Blog #1)

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.

Maintain signage

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.

Create Variables

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 Formula

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.

Create Query

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.

Storage

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.

Conclusion

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 .

Recent Posts

Leave a Comment