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 t...
Dashboards
Excel Add In
Reports
chul's avatar
chul
Icon for OneStream Employee rankOneStream Employee
22 hours ago

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

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

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

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee
    55 minutes 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.