Auto Translation Currencies and displaying the translation currency In Excel

GuyRogers
New Contributor II

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 1

db_pdx
Contributor III

"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