Skip to Content
avatar image
Former Member

Remove Blank records from BEx Query

Jun 27, 2017 at 06:45 AM | 98 Views

Dear All,

Please have a look at below attached screen shot , where i want to remove the rows entries where the no. of rows count is blank. I dont want to show those dates in the Query result where the count is blank.

I have tried with Query property -> Rows/Cols -> Supression with Zero , but it is not working.

Please do the needful as soon as possible.

Regards,
Sanjay Gajera

+91 89050 74894

sap-remove-blank-records-from-bex.jpg (38.6 kB)
BW Business Explorer (SAP BEx)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Bhavin Vyas
    Jun 27, 2017 at 09:40 AM
    -1

    Try this,

    Click on the Key-figures structure

    Go to the display tab

    uncheck "Structure as group. Only apply Suppression when all elements are zero"

    Thanks,

    Bhavin Vyas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Koen Hesters
    Jun 28, 2017 at 07:51 AM

    Hi,

    you can set also a condition on the number of records as a solution.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Loed Despuig
    Jul 03, 2017 at 05:15 AM

    Hi,

    Bhavin's suggestion is correct.

    Just click the name of your structure and uncheck the "Structure as group. Only apply Suppression when all elements are zero" under the DISPLAY tab.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded