OneStream Community

JonKunert

I am wondering if anyone has changed the precision of the FxRate? It shouldn't be to hard. What I am wondering is if changing it would cause other issues ?

JonKunert · 10-02-2023

Kinda of a silly question I was building a cubeview and was trying to adjust the expansion on the layout. It was set to default view, which got me to wondering where are these default selections set. I first looked through the documentation, then rem...

JonKunert

Hi Everyone, I wanted to update everyone. I heard back from support and Yes you can change the number of decimals. But they discouraged the method I was going to take. Below is their response in case anyone else needs this info in the future, *******...

JonKunert

I have that part figured out, What I dont know is if the change would would cause other issues

JonKunert

Actually changing the number of decimals is super easy. Using Business rules. Create a new table with the changes. Copy data from old to new table, rename tables, rename primary Keys. And done.

JonKunert

Ok, we get our rates from Bloomberg. They only have six decimals. So for KRWUSD, the value would be .000745, which isn't very precise and less for other currencies. So we use the inverse of USDKRW 1339.44 which is 0.000746580661. Workday creates the ...

JonKunert

we are trying to match what is in our gl. We want to change the translation otherwise there would be no reason to change it. I know it’s not a huge difference but it is what the business wants.

OneStream Community

User Statistics

User Activity

Change the precision of the FxRate

CubeView Defaults

Re: Change the precision of the FxRate

Re: Change the precision of the FxRate

Re: Change the precision of the FxRate

Re: Change the precision of the FxRate

Re: Change the precision of the FxRate