The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
kakouchtim
2 years agoNew Contributor III
vStageSourceAndTargetData Converted Amount
Hi OneStreamers,
I am using the table vStageSourceAndTargetDataWithAttributes in a dashboard to display cost centers (Source Account) and Accounts (Target Accounts) per all other dimensions, for a ...
Henning
OneStream Employee
2 years agoHi, 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
- 1 year ago