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's avatar
kakouchtim
New Contributor III
2 years ago

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 ...
Cube View
dashboards
Reports
kakouchtim's avatar
kakouchtim
New Contributor III
2 years ago

I don't think so, unless there's a way to display the source value in UD6 from the cube ? or maybe is it possible to add a calculated column that translates the figures ?

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    The SourcetoTarget table has only local amount since the translation is happening in the Cube. You can create a custom table with FX Rates and join the 2 tables and calculate the respective currency.