What is Reporting Currency and Why is it Important

Reporting currency members help generate reports in a common currency (CC) for accounts required to be converted to CC at a special rate. For example, converting all accounts at the ‘Prior year Rate.’ The advantages include:

• No additional scenarios for rate analysis as you can use a single scenario for all analysis.

• No need for multiple exchange rates management.

• No need to refresh preloaded budgets.

• No need for explicit cube processing.

• Requires the ‘Consolidation Process’ to be executed once. This process runs in the cloud. Upon completion you will receive a notification.

This type of reporting requires the following:

• Creation of required exchange rate type members (currency types), which is a one-time activity. For example, if comparative reports are required to do a what-if analysis in case of three different rates, then AVG rate, AVG-Case1 and AVG-Case2 exchange rate type members need to be created and used.

• Population of the exchange rate table for currency types.

• Creation of new reporting currency members, which is a one-time activity.

• Mapping accounts with the rate to be used. For instance, the “Case-1” reporting member will need all income statement accounts mapped with “AVG-Case1” and balance sheet accounts with “EOM-Case1”. This is a one-time activity.

• Run the Consolidation Process. User access must be granted access to run the Consolidation Process.

• Update existing reports to the preloaded rate set scenarios to use the reporting currency members.

In Practice: Define Currency Types:

Create the Currency Types for PY Rate and LBE Rate.

1. Navigate to Maintenance > Currency > Currency Setup.

2. Click the Currency Type tab.

3. Click Add.

4. Add a currency type named PY Rate.

5. Click Save.

6. Click Add.

7. Add a currency type named LBE Rate. Click Save.

   Set Up the Reporting Currency Member:

8. Create a Reporting Currency member and map a currency type. Access the Hierarchy Management screen by Navigating to Maintenance > Hierarchy > Hierarchy Management.

   1. Select the Finance Hierarchies type and the Reporting Dimension and Hierarchy. Click Show to display the Reporting hierarchy.

   2. Add a rollup member. In the example below the Example Rep Currency rollup is added to the Reporting Main hierarchy.

      

   3. Add a leaf member to the Example Rep Currency rollup and name it Reporting Currency for PY Rate. Click the newly added Reporting Currency for PY Rate member to define segment properties. Select the PY Rate currency type.

      

   4. Click OK and click Save once all definition properties are complete.

In Practice: Define Currency Exceptions

1. You can define currency exceptions if you want different rates by legal entity and account. If this is the case, navigate to Maintenance > Currency > Currency Exceptions. If currency exceptions are not needed, proceed to the next step. .

   1. Select the reporting currency, which is Example Rep Currency.

      

   2. Select the company in which you want to apply the PY and LBE Rates. Click Copy To to map accounts where the exception will be applied. For column C ( Currency Exception), select the currency type (PY Rate or LBE Rate) by which you want the account converted. For example, balance accounts may need to be converted at the ‘PYEOM’ rate as opposed to the PYRate.

   3. Continue to setup the currency exception for all companies and accounts where needed. In the image below, an account for Corporate Operations will be converted at the PY Rate.

      

   4. Click Save.

In Practice: Load Exchange Rates:

1. Load the LBE and PY exchange rates for the scenario in which the conversion will take place. Navigate to Maintenance > Currency > Exchange Rates.

2. Select the Scenario, Year, and the Currency in which you want the rate converted. Load exchange rates for the currency types. In the example below, LBE will convert at a rate of two to one and PY Rate will convert at a one to one rate.

   

3. Run the Consolidation Process for the scenario.

   1. To do so, access the Consolidation Control Panel, select the scenario, select the Consolidation Process, and click the Process action.