08-14-2024 12:33 PM
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
08-14-2024 01:46 PM - edited 08-14-2024 01:54 PM
"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