Skip to Content
0

Remove Blank records from BEx Query

Jun 27, 2017 at 06:45 AM

97

avatar image
Former Member

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)
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sort by:
avatar image
Bhavin Vyas Answered 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

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
Koen Hesters Answered Jun 28, 2017 at 07:51 AM
0

Hi,

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

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
Loed Despuig Answered Jul 03, 2017 at 05:15 AM
0

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


delete.jpg (44.6 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Former Member
Jul 03, 2017 at 09:21 AM

Thanks Both for the solution.

1
Loed Despuig
Former Member
Sep 11, 2017 at 12:43 AM

Hi Sanjay,

You are very welcome. You may now close this thread.

Regards,

Loed

0
Comment