Skip to Content
avatar image
Former Member

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

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 06, 2017 at 11:45 PM

    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.



    Add comment
    10|10000 characters needed characters exceeded