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

MarioGV's avatar
MarioGV
New Contributor III
7 months ago
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 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

dashboards
Excel Add In
Reports
  • MarioGV's avatar
    MarioGV
    7 months ago

    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

6 Replies

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee
    7 months ago

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

    • MarioGV's avatar
      MarioGV
      New Contributor III
      7 months ago

      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
        7 months ago

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