Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to use WEBI operator "NO FILTER" in Bex Query Designer?

Dear Gurus,

Could someone please explain how to use "no filter" operator from Webi in BEx Query Designer?

Customer is comparing webi and Bex report and we are not able to find a solution for the difference.

We have a Formula which is working fine when there is account,product, classification and calendar day is in characteristics,

Out of stock formula = Inventory < Treshold

AccountProductClassificationCalendar DayOut of stock (Formula)
801121A01.12.20150
801121A02.12.20151
802122B12.02.20150
804123A25.12.20151

Now they are removing drill-down for account,product and calendar day inĀ  webi

Expected

ClassificationOut of stock (Formula)
A2
B0

BEx Report output

ClassificationOut of stock (Formula)
A0
B0

the formula they are using in WEBi is as below

Sum((if[inventory]<= nofilter([Treshold]) in ([Account];[Product]) Then 1 ForEach([Calendar Day];[Account];[Product]))

Also they have suggested to use context on Account,Product and Calendar Day.

Please help how this can be achieved.

Regards

Karthik Kurpad

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question