Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
5 days ago

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 though a fx formula in Excel?

I konw that this is a derivated data, but would like to know if its available on any dimension or fx formula

Thanks in advance and kind Regards.

Mario Guerrero

3 Replies

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee

    You can use the XFGetMemberInfo in spreadsheet or Excel to return the entity currency.

    • MarioGV's avatar
      MarioGV
      New Contributor III

      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's avatar
        JackLacava
        Icon for OneStream Employee rankOneStream Employee

        Isn't that just a cell, pointing to C#Translated, O#Elimination for the specified pair of entity and IC ...?