Skip to Content
author's profile photo
Former Member

Error display in query output

Hello all,

I have Product Quantity in Columns as Key figures.

While running the query

In output i see * value instead of "0"

So if there is no value , then atleast it should show 0 or nothing.

Which properties or selection i should do

I want to remove this * message.

Any suggestions as to how to do this ?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 12:26 AM

    In transaction RSCUSTV4 you can change the display of the BEx errors. I.e. you can change '*' to something more meaniful like 'MIXEDUOM'.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:16 PM

    This is a KF with dimension (Amount or Qty).

    The KF value you see is a summarised value which has more than one unit (eg values with USD and EUR are added) and so the total is meaningless and has been replaced in the display by *.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2007 at 09:15 PM

    Hi,

    You see * because you have different units for the same line. You need to add the unit info object or filter some unit to see the values.

    Hope this helps.

    Regards,

    Diego

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:21 PM

    Restrict ur Currency to USD or to the reqd n try.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In the query properties, choose the Display - Zero Value Display - Show Zeroes as and then enter a blank.

      You can also choose the zero supression if you want to hide the rows or columns that are zero.

      Cheers

      Chami