cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

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

(inventory< threshold ) * 1 + 0

Former Member
0 Kudos

Hi Jyothi,

Thanks for response.

We have used IF ELSE there.

(Inventory < Threshold) * 1 + 0.

It is fine when all four characteristics are there , Problem is when other characteristics are removed and classification is retained.


Webi is not considering "Out Of Stock" for filter, We need to know how we can achieve this through Bex.


Regards

Karthik Kurpad

Former Member
0 Kudos

Sorry Karthik, I am confused, where do you have this issue? in webi? or in bex?

Loed
Active Contributor
0 Kudos

Hi,

Apply EXCEPTION AGGREGATION to your OUT OF STOCK FORMULA, choose SUMMATION, in reference characteristic choose CALDAY..

Regards,

Loed

Former Member
0 Kudos

Hello Loed,

This did not work,

instead Out of Stock is showing Zero.


Before Exception Aggregartion

AccountProductClassificationCalendar DayOut of stock (Formula)InventoryThreshold
801121A01.12.20150107
801121A02.12.2015167
802122B12.02.201501510
804123A25.12.2015167

After Exception aggregation

AccountProductClassificationCalendar DayOut of stock (Formula)InventoryThreshold
801121A01.12.20150107
801121A02.12.2015067
802122B12.02.201501510
804123A25.12.2015067
Former Member
0 Kudos

Hi Jyothi,

Issue is in BEx.

It is fine in Webi because they are using no-filter