cancel
Showing results for 
Search instead for 
Did you mean: 

Handling NULLs in BEx Query Designer

0 Kudos

Hello Experts,

I am designing a query using BEx Query Designer. Here I have to display all the rows in which the value of a particular cell is either 0 or NULL.

I am able to display the rows with Value 0, but not able to select the rows with NULL.

Can anyone help me please in this regard.

Thanks,

Jashua

Accepted Solutions (0)

Answers (2)

Answers (2)

balajee_sivakumar
Contributor
0 Kudos

Hi,

Can you please share your exact scenario regarding whether you wanted to display '0' and null values of a keyfigure or characteristic ?

Because if it a characteristic you can filter that for your particular values and it will work.

Regards,

Balajee

0 Kudos

Hi,

It is Key Figure only not characteristics.

Jashua

former_member186445
Active Contributor
0 Kudos

create a new calculated key figure CKF1.

this new key figure =

CKF1 = KF + 0. (where kf is your original key figure)

usinf this approach also the NULL values will become 0 values

now you can use the condition on this new calculated key figure :

CFK = 0.

this will work.

0 Kudos

Hi,

on this CKF1 conditions are not working properly. Only > 0 is working fine. But <=0 or = 0 are not fetching the rows with 0 values.

Can you suggest any other way.

Thanks,

Jashua

former_member186445
Active Contributor
0 Kudos

then you have done something wrong. i have the same on my system and it works like a charm.

other option:

add a kf to the cube. put a routne in place. if null or 0, you put a 1 in this new kf if the value is null or 0.

now you can use this new kf in your query. display the lines where it's 1

M.

Former Member
0 Kudos

how about putting the condition as not to show rows where value greater than 0

0 Kudos

I already tried. It didn't work.

Former Member
0 Kudos

Create a calculated key figure... using boolean condition.... so if the values are 0 or NULL, then result 1... for others result 0

then do a the condition on the result