Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
23 days ago

Alternate Currency for Display

Can someone please explain to me how the "Alternate Currency for Display" UD property works in Onestream? I am looking options to translate balances to a Cost Center (UD) currency (which is differen...
Application Properties
Consolidation
Cubes
vmanojrc30's avatar
vmanojrc30
Contributor
19 days ago

Thank you, Teressa!

To translate using the UD8 member and display in CV, do I need to enable Alternate Currency for Display property?Just setting up the Column with U8#CAD should display the translated numbers, right?

I was not getting the use case or the functionality of this property from the description given in the design and reference guide.

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    19 days ago

    I would say you do not have to set the Enable Alternate Currency for Display as "True", but if you have any cube views where you have set the CV to "Show Currency" in the cell:

     

    Then it will be confusing to the end user if the U8# is CAD but when the currency flag is shown in a CV it says "EUR" or "USD" or something else.

    So I would lean towards setting the U8 as True for Display alternate currency if you are going to write the formula to do an alternate currency.