Skip to Content
2

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

Apr 05, 2017 at 04:38 PM

82

avatar image
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 ?

10 |10000 characters needed characters left characters exceeded

Hi Nadia,

Did Julian's answer help?

Can you provide a sample of your data?

Thanks,

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Julian Jimenez
Apr 06, 2017 at 11:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded