Skip to Content
author's profile photo Former Member
Former Member

BEx Query Designer - Automatically Hide a specific Unit of Measure

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Mar 05, 2015 at 10:44 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2015 at 12:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2015 at 01:28 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.