Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
31 days 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
    26 days 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

MarioGV's avatar
MarioGV
New Contributor III
26 days 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

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