vStageSourceAndTargetData Converted Amount

[kakouchtim]

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 selected entity and period. It's working fine but the amount from the table is always in the local currency of the entity, and I'd like to see all amounts in EUR.

Is there an easy way to convert the figures in the table ? I saw there was a column named "Converted Amount", maybe it can be used somehow to show translated figures ?

Appreciate your insights on this.

Adam

[RobbSalzmann]

Show the consol column in your screenshot.  Is it set to ‘local’ instead of EUR?

[kakouchtim]

Nop. I just selected the Time, Entity, Account and Partner.

I tried selecting Cn = 'EUR' but the table doesn't return any value. Only 'Local' seems to work

[RobbSalzmann]

Yeah, it’s a staging table for drilling to transformed data. The data has to make it into the cube to be translated by the consolidation process.  

would it work for you to pull from the cube instead?

[kakouchtim]

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]

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.

[Henning]

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.