Displaying Currency Property Changes In Hierarchy Management In Templates

Currency Property changes made in Hierarchy Management will be reflected in the Planning templates where the dimension member is used. The template must be opened and closed (or processed via Simulation Engine) and the cube must be processed. Doing so recalculates the data according to the updated properties.

In Practice

The template below has an account dimension member (1010). The currency for this member is EUR.

When this account member (1010) is opened in Hierarchy Management (accessed by navigating to Maintenance, Hierarchy, Hierarchy Management), the properties are:

Credit/Debit = Debit
Currency Type = EOM
Normal Data Input Type = YTD

When the Currency Exchange Rate page is accessed and the EUR currency is selected, the EOM currency type exchange is set up to exchange at a 4 to 1 rate as shown in the page below

Let's say you want to change the account member from Debit to Credit, the Currency Type from EOM to Avg , and the Normal Data Input Type from YTD to MTD. And, you want the changes reflected in templates with this account member.

Access the Hierarchy Management screen and select the account member (1010). Change the Debit to Credit as shown below.

Change Currency type to Avg and change Normal Data Input Type from YTD to MTD as shown below

Once the hierarchy is saved, it is submitted for publishing. Once published, open and save the template. This action recalculates the template data based on the modified member properties. You must reprocess the cube in order for changes made to display in templates.

Because the property was changed from debit to credit, a negative balance is now shown.

After Changing Properties

Prior to Changing Properties

Notice the amount for Feb-16 is -2000 versus 4000. This is because the exchange rate for Avg is 2 versus the exchange rate for EOM, which is 4.