Skip to Content
avatar image
Former Member

BEx Web Report - Key Figure Values Appears as '*' (Asterisk)

Hi SAP BW Gurus,

I like to know if there is a way to convert key figure values that appears as "*" (Asterisk) into its actual values. This appears when I run a report with different UoM and on a BW Web Report I can't convert the values into numbers. I can do so in BEx Analyzer (Excel).

Appreciate any advice.

Regards,

Eric

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 25, 2010 at 09:47 AM

    Hi there,

    Just use the NODIM() formula,

    like this:

    NODIM(key_figure).

    This will work as you expect.

    Diogo.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 25, 2010 at 09:52 AM

    This is because BEx can not decide the UOM of the value which comes after addition of two different UOMs.

    Use NODIM() in a formula or calculated key figure. Then it will display you the value, but it will not display any unit.

    If you wants to display unit also, then you have to use some alternative unit of measure, so that all the units will convert to one single unit.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2010 at 02:30 AM

    Thanks Diogo and Pravender. Problem solved.

    Regards,

    Eric

    Add comment
    10|10000 characters needed characters exceeded