Forum Discussion

Keyser_Soze's avatar
Keyser_Soze
Contributor
11 days ago

Attribute Members on Entity Dimension Do Not Translate ?

I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. 

These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate.

The only way I was able to actually convert them is by using Data Buffers and forcing the conversion.

Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ?

Thanks

Consolidation
Cubes
FX Rates
    • Keyser_Soze's avatar
      Keyser_Soze
      Contributor
      6 days ago

      Thanks for you answer. Prior to writing this post, I've watched the whole video you sent as well as read some articles.
      Maybe I'm mistaken, but I cannot see anywhere the explanation for why 'api.data.calculate()' does not include attributes members even when hardcoded in source formulas whereas data buffers do take them into account (if a property is activated).

      For anybody searching for a way to include attributes members in 'Custom Translations', you need to use buffers. Beware of account types & flow properties ! If you use data buffers, you have to isolate all non-translated accounts such 'Flow, Balance & Non-Financial'.