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!