Forum Discussion
Hi, my guess is that the converted amount column displays the amount after it went through the conversion specified in the data source, specifically factor value and rounding.
As Krishna said, you can create a custom table to merge the existing table with a translated amount, or translate the amount in the rule to store it in the merged table.
However, not knowing more about your solution, I would personally prefer a (SQL) View using a data adapter. This is dynamic, translates your data on-the-fly and does not store the data. Please note that - assuming you just check the account type and translated based on this using the average rate or the closing rate - your translated data may not always be equal to the EUR amount in the cube, depending on custom translations being applied there and other possible influencing factors.
Related Content
- 10 months ago
- 2 years ago