The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

How do I override the FX rate?

Originally posted by Jeff Wood

10/21/2019

I have a point of view in local currency that looks like the following:

Cb#OSTP:E#VCOC_CTX:P#Legal_CTX:C#Local:S#TXActualRTP:T#2017M12:V#YTD:A#TXPTIBA001:F#RTPProvisionVar:O#BeforeAdj:I#Top:U1#CA:U2#Gross_Input:U3#USGAAP_Total:U4#National:U5#None:U6#None:U7#None:U8#None

When I pull the USD point of view for this same calculation, I get the following:

Cb#OSTP:E#VCOC_CTX:P#Legal_CTX:C#USD:S#TXActualRTP:T#2017M12:V#YTD:A#TXPTIBA001:F#RTPProvisionVar:O#BeforeAdj:I#Top:U1#CA:U2#Gross_Input:U3#USGAAP_Total:U4#National:U5#None:U6#None:U7#None:U8#None

My client does not want T#2017M12 for the FX rate but wants to use a 2018 FX rate. How do I override the FX rate? Any help is greatly appreciated. Thanks.

FX Rates
Time

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    6 years ago
    Originally posted by Chul Smith

    you can set up a UD8 to dynamically calc it using whatever rate you want (assuming there will be a parameter for the user to select at run-time). The down side is that it'll just translate the entire local balance rather than PVA method. Not exactly sure if that's sufficient for your requirements.