Forum Discussion

GuyRogers's avatar
GuyRogers
New Contributor II
5 months ago

Auto Translation Currencies and displaying the translation currency In Excel

Hi

We have setup Auto Translation Currencies on a USD Entity (AUD, JPY, GBP)

Using XF Functions how can I display the Currency label i.e. AUD?

XFGetCell returns the the data in AUD how can I display AUD in a cell as XFGetMemberInfo only shows me the currency attribute of the Entity (USD)

Thanks

Guy

Excel Add In
  • db_pdx's avatar
    db_pdx
    Valued Contributor
    5 months ago

    "Using XF Functions how can I display the Currency label i.e. AUD?"

    You can't.

    You could:

    1) Use regular 'ole Excel functionality and put the "AUD" into a cell and then link to it; effectively creating a mock dimension header that indicates what currency is being used in the retrieve.

    2) Build real cube view reports which can display a header that contains your C#Cons selection

    I'd suggest #2.  In my opinion, XFGetCells are a crutch that should replaced as soon as possible.

    -db