BEx Query Designer - Automatically Hide a specific Unit of Measure

[Former Member]

Good Day Experts!

We currently have a report that is displaying Sales Quantities by Products.

But there is one specific product which doesn't have the same Unit of Measure as the other products.

Is there a configuration in BEx Query where in we can automatically hide a Value that doesn't have the required Unit of Measure?

For example, our Target unit is Cases, but one product is only available in Pounds, is there a way to automatically hide values that are not in Cases?

Thank you in advance.

[Former Member]

Hello

Either you show the Product or Sales Unit of Measure in the Characteristic. so that * will be more clear and meaningful. instead of hiding the values..

Thanks

[Former Member]

Hello Juan,

Don't know why you would like to do this 🙂 But anyway, you can create a restricted kf Sales quantity with unit CS (0BASE_UOM). So all the other units will not be shown.

Regards,

Päivi

[former_member186053]

Hi Juan,

I think we can not hide a particular value in BEx, instead if you do not want to display units(applies to all values in KF) next to values you can use NODIM function by creating a new formula on top of your key figure.

One more thing if client wants to see all the values in same unit, you can do unit conversion either in BEx level or at infoprovider level in transformations. Why you want to hide only that value, what exactly is the requirement.

Thanks,

Vengal.