SAC - Units for Account Dimension

[fabianrunge1]

Hi!

Is it possible to load data that has different units into the same SAC key figure? In our example we have data residing in a BW system using the InfoObjects 0AMOUNT and 0UNIT.

The data would look like this:

12 ST
15 DS
....

How would this be modelled in SAC? A key figure can only be a currency or have exactly ONE unit. But we multiple units in our case for the same key figure.

[former_member234401 · Accepted solution]

Hi

Maybe you could pull the 0UNIT into a dimension - and on that dimension maintain the conversion by an attribute of that dimension

And use the TONUMBER formula in the accounts/measures (exception aggregation on lowest level)

[QTY]/TONUMBER([d/Base Unit-DISPLAY_KEY].[p/KG] )

If you need the unit in a context of eg material - you can make the unit as a property of material or use the

in the modelling phase

if you would like to have it more automated - you could bring in the table that stores the conversion and use the combine functionality (on multiple dimensions in 2019.06) and then calculate across the two combined data sources

br

René