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
Solved
get partner currency in a cube view or FX formula?
hi all, good day; we are using plug accounts and IC matching accounts property, we see the IC matching report but I would like to know if it's possible to get the partner currency in a cube view or t...
hi Chul, yes is dynamic and I created a cube view with the formula retreiving the fx rate by the Amount, in Excel using the cube view connections, the user is able to select the entity, IC and period and can use the data.
another way was creating a UD8 as dyamic member with the same funcion as cube view.
thank you and best Regards.
Mario GV
thank you chul and is showing me the currency (CAD) in this case, but I need the amount, when you review the IC Matching accounts, ou can see 3 amounts in different currencies and would like to know how or where to extract the Partner Currency Amount that is calculating but I don't know where should I get this info.
thank you. Regards
Mario GV
JackLacava
OneStream Employee
OneStream EmployeeIsn't that just a cell, pointing to C#Translated, O#Elimination for the specified pair of entity and IC ...?
hi Jack; that pointing retrieve the same value as Entity amount and same currency.
thank you. Regards