Show TOC

Function documentationRate and Ownership Data for Consolidations Setup Locate this document in the navigation structure

 

You use this function to load exchange rates to the rate application, enter ownership data, and calculate ultimate ownership.

Prerequisites

Data manager packages have been added to the consolidation application, a consolidation engine has been created using script logic files, and rules have been set up in the business rule table.

Features

Loading Exchange Rates to the Rate Application

The rate application typically stores the exchange rates for currency conversion. There are several ways to upload the data to the rate application, such as using the data manager package Import, or using dynamic templates to send data from the input schedule. If you use EVDRE, you can set the Rate Account Type dimension and Input Currency dimension in rows, and the Time dimension in columns. You can save the EVDRE as an input schedule to send data to the rate application. You can also save the input schedule as a template in the library for sharing and reuse.

Entering Ownership Data and Calculating Ultimate Ownership

Note Note

If you are using the NetWeaver version, we recommend that you use the information below for updating the ownership cube with ownership details. This is because consolidation scope (such as ownership percentage, group or unit hierarchy) is time dependent, and the dynamic hierarchy editor is not implemented in the current release.

End of the note.

If the business prefers to input ownership using the direct share method:

  • Enter the percentage of direct ownership between investor unit (Entity) and investee unit (IntCo) under a group dimension member (for example, LC) by category and time. Member POWN in the O_Acct dimension stores this information.

  • Enter the consolidation method of each entity under each consolidation group. 90 represents the holding company of a group, 86 represents Purchase (Global), 70 represents Proportional and 30 represents Equity. Member Method in the O_Acct dimension stores this information.

  • Enter the position of each entity in a consolidation group. Value 1 represents in the group; any other value represents not in the group. Member PGROUP in the O_Acct dimension stores this information. You can build the input schedule to enter these ownership details into the cube.

  • Enter the predelivered data manager package Calculate Ultimate Ownership to calculate the ultimate ownership that each consolidation group owns of each entity. As a result of write back following the calculation, the ultimate ownership is stored under the member I_NONE of the IntCo dimension. POWN, PGROUP, and METHOD member have the group-own-entity value described above.

If the business prefers to input ownership using the ultimate share method:

  • You only need to enter the group-own-entity value for POWN, PGROUP, and METHOD under I_NONE in the IntCo dimension.