MENU
    Displaying Currency Property Changes In Hierarchy Management In Templates
    • 1 Minute to read
    • Dark
    • PDF

    Displaying Currency Property Changes In Hierarchy Management In Templates

    • Dark
    • PDF

    Article summary

    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.

    image6021.png

    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

    image6121.png

    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

    image6051.png

    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.

    image6081.png

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

    image6091.png

    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

    image6101.png

    Prior to Changing Properties

    image6131.png

    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.

    image6111.png


    Was this article helpful?