Is it possible to work with different units within ONE dimension on BOC?

[Former Member]

I am working on data extracted from SAP Business ByDesign but I guess this applies to all cases.

In my data, I have a dimension of Quantities sold that has different units (hours, days, years, pieces, boxes...) (Units are in a separate dimension).

So I thought about linking the two dimensions in way that the column containing the units would be the property of the main column containing the different quantities sold.

But when I do so, the dimension quantities is considered of "dimension" type, and not a measure (which is what I actually need).

is it possible to make it a measure type AND have multiple units in it ? Have anyone dealt with a similar situation ?

[JohnL]

Hi Nadia,

Did Julian's answer help?

Can you provide a sample of your data?

Thanks,

[julian_jimenez · Accepted solution]

Hi Nadia,

If I understood correctly your structure, you keep a single column Quantities sold and another column that tells you what those quantities are: hours, Units, etc.

If this is coming from a view you have created, I will recommend to avoid mixing such different measures together in BOC, it can lead to mistakes aggregating completely different type of units.

If you had separated measures, for example, Quantities sold only for pieces, you can go to the column Units & Currency in your model, select Label and type the label name that you want: pieces.

For the other measure that calculate hours sold, you can repeat the same actions and select the Label hours.

If you can't separate the different Quantities Sold before acquiring the data in BOC, you can use your column type of quantity as an input filter so you select only types that make sense: hours, boxes, etc. However, that won't stop another business user to use that same model to mix hours and boxes.

Regards,

Julian