Skip to Content
avatar image
Former Member

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

Account Product Classification Calendar Day Out of stock (Formula) 801 121 A 01.12.2015 0 801 121 A 02.12.2015 1 802 122 B 12.02.2015 0 804 123 A 25.12.2015 1

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

Expected

Classification Out of stock (Formula) A 2 B 0

BEx Report output

Classification Out of stock (Formula) A 0 B 0

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 04, 2016 at 12:57 PM

    Hi,

    how did you achieve zero in bex? did you use if else statement?

    (inventory< threshold ) * 1 + 0

    Add comment
    10|10000 characters needed characters exceeded