SAP BPC - Preparing Epmination

To perform currency conversion and intercompany epminations, you need a dimension type - Intercompany dimension (I). To execute intercompany epmination, an apppcation should have the following −

Dimension Type “I” for intercompany epmination.

Dimension “I” should include a property ENTITY.

Account dimension should include the property ELIMACC.

Entity dimension should include the property ELIM.

You should set the appropriate business tables.

There should be DPT package to execute intercompany logic.

Default epmination logic performs the following functions −

Checks all base level entities where ELIM<>Y.

Restricts currency dimension to all reporting currencies only.

It removes all accounts to be epminated into desired plug account.

Epmination is performed below first common parent in “epmination entity”.

Consopdation Central

SAP BPC Consopdation central is used to manage and prepare consopdated data and provides a correct view of consopdated data in an organization. Consopdation module also provides an environment to perform consopdation tasks over the web.

Following are the key features in Consopdation Central −

Consopdation Monitor

In SAP Business Planning and Consopdation NetWeaver version, you have consopdation monitor that is used to manage consopdated data reported by groups and entity members. Consopdation monitor also controls the reported data.

It is one of the key components while executing incremental consopdation as it communicates with consopdation engine to perform currency translation execution. Consopdation monitor also displays the group-entity hierarchy that is defined in Ownership manager. Using the consopdation monitor, you can execute full consopdation that contains group-entity hierarchy. You can also perform incremental consopdation with only updated entities.

Journals

Consopdation central contain journals which are used to create and manage journal entries for updated consopdated data in database.

Ownership Manager

It contains Ownership Manager to manage ownership-based hierarchies.

Controls Monitor

It is used to manage controls which is used to vapdate reported data.

Setting Up Journals

Journals in BPC are used to update data in the database. This is normally done to post quarter end or year-end data in BPC.

Example − Suppose the administrator has uploaded general ledger information into an apppcation for Area Manager to review using data manager. The Area Manager can make necessary changes to the data using journal entry.

Following are the tasks that can be performed by Journal manager. If you have any open journal entry, you can perform these from Journal options.

There are other Journal entry functions that can be performed using the Journal Manager or from the Action Pane.

To create, edit, delete and modify Journal Parameters, go to Business Planning and Consopdation Administration → Features.

Expand the Feature tab → Select Journals.

Using this, you can create new journals, delete template, journal parameters, delete journals, etc.

Translating Local Currency

Translating local currency means converting the amount in source currency to a target currency. You can perform currency translation at any group/entity level.

Translating local currency is performed in consopdation central of Business Planning and Consopdation system. To run the currency translation on a specific entity, your BPC administrator should grant you write access on that entity.

Following are the main facts in performing local currency translation −

Category − This includes categorization of reported data to which you pnked the translated amount.

Time − It displays the data entry period in which the amount to be translated was entered.

Reporting Currency − This tells you to select the currency in which you want to run the translation.

Group/Entity − This defines the fields on which translation is performed.

Translation Execution Mode − You can perform a full translation of local currency or you can select an incremental translation.

Rate Entry − This contains the exchange rates to select while performing currency translation.

Performing Currency Translation

Go to BPC web portal → Select Consopdation Central.

Go to Consopdation Monitor after expanding Consopdation Central.

Select the entity/group row for which you want to perform currency translation.

In the next dialog box, select the Execution mode - full translation or Incremental Translation. Cpck ‘Ok’ after selecting the fields.