Skip to Content
0
Jun 17, 2020 at 01:38 PM

how to transform an attribute into transactional data - SAC

562 Views

Hello,
I'm working on SAP analytics cloud
I have a product dimension (bottles) with few attributes. One of them is "volume" (for example 0.75 ml)

As volume is set as an attribute, the data is set as text.
Volume must be an attribute, because it's a fixed information (a 0.75ml bottle will always be a 0.75ml bottle) for each product (bottle)

My issue is, that I need to convert the quantity of bottles into liters, using this kind of formula (in data action):
Quantity sold*volume=Liters sold

Therefore, my question is how can I transform my attribute into transactional data, on the dimension level?

Thanks for your help!