Skip to main content
G
GuyRogers
August 14, 2024

Auto Translation Currencies and displaying the translation currency In Excel

  • August 14, 2024
  • 1 reply
  • 0 views

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

1 reply

D
db_pdx
August 14, 2024

"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

Terms & ConditionsAccessibility statement