Forum Discussion

bsalamone's avatar
bsalamone
New Contributor II
8 months ago

Alternate Currency Translation POV in Quick Views Reporting

Hello,

We have a client who has requested the ability to use the alternate translation currency property on specific parent entities but then also to be able to pull that alternate currency in reports without changing the currency in the POV. For instance, the parent entity's currency is USD and it will be setup with EUR as an alternate translation currency in the equity pickup property section. The children of that parent entity are all EUR currency entities. In their reporting they would like to be able to show parent entity and children at the EUR without changing the Cons POV. The reporting could have multiple instances of this setup with different entities and currencies so setting the Cons to EUR wouldn't be an optimal solution. Ideally, they would like to set the consolidation to local for the whole report. We have alternate hierarchies setup but they would like to only worry about one member name for the parent and one hierarchy. Does anyone have any suggestions on how to achieve something like this? A quick thought of mine was to use a text field on the entity and create a dynamic calc member in UD8 that would pull it at the alternate currency but I'm not sure how feasible that is yet without testing.

Thanks in advance for any thoughts or suggestions!

  • bsalamone  - You are on right track.

    UD8 - UD8 Reporting members is the way to go because it reduces the consolidation time, basically you are going to translate the UD8 None (Loaded data) with FX rates.

    Auto Translate - If you enable the Auto Translate feature then you have to consolidate to get the results, but you have to have the respective Cons Member Ex EUR, GBP...

    Alternate Hierarchy - This is also another option but there is going to be lot of maintenance and still require consolidation. 

  • Krishna's avatar
    Krishna
    Valued Contributor

    bsalamone  - You are on right track.

    UD8 - UD8 Reporting members is the way to go because it reduces the consolidation time, basically you are going to translate the UD8 None (Loaded data) with FX rates.

    Auto Translate - If you enable the Auto Translate feature then you have to consolidate to get the results, but you have to have the respective Cons Member Ex EUR, GBP...

    Alternate Hierarchy - This is also another option but there is going to be lot of maintenance and still require consolidation.