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 t...
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

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 ...?

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

        hi Jack; that pointing retrieve the same value as Entity amount and same currency.

        thank you. Regards

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

      In your screenshot, the data stored on Entity LU01 is dynamically translated to the partner's (CO01) currency as indicated by the red tick marks. In order for you to return those numbers in Excel, you'd need to do one of the following:

      1. Dynamically derive the data via member formula or business rule as you'll need the proper FX rate and rule type for translation.
      2. Translate the Entity (LU01) to the partner's currency so it is stored in the database for retrieval. 
      • MarioGV's avatar
        MarioGV
        New Contributor III
        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