Skip to Content

Remove zero value from Query analyzer out put.

Dear experts,

I have vendor ageing query in this i have 6 keyfigures

Total,   overdue,   1-30,    31-60,     61-90,       >90

0            0              0          -100       100             0

25           5             0              0          5              0

if you see my first record the total and overdue is zero. records with Total keyfigure  zero should be eliminated.

Kindly guide me on this.

Regards,

Naveen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 19, 2015 at 08:01 AM

    hi Naveen,

    put 1-30,    31-60,     61-90,       >90 in a Calculated keyfigure:

    add the condition:

    ((Total AND Overdue > 0 ) * 1-30 )

    then if you supress 0 values, it won't be displayed.

    rgrds,

    Mathijs

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 09:12 AM

    Dear Experts,

    For your reference Below I am giving screen shot of my query out put. the Red marked records I don't want to show to Users. Those records should be eliminated.

    Regards,

    Naveen


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 08:08 AM

    Hi,

    in cube level elimination recrods will work for only inventory cube

    but report level it is not possible elimination the vlaues.

    any way report is giving 0 values.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 09:49 AM

    Hello Naveen,

    way1 : Go to query properties:--Value display-  --> Zero value display-- --> then select Zero as space.

    way 2 : write a VB macro code at query outlevel level (BEx Analyzer).

    Regards,

    Hitesh

    Add comment
    10|10000 characters needed characters exceeded