ZZ in IT

It is a common task to list the records in infoCube with the restriction that one or more fields are not empty.

Q1, what is the meaning of empty?

We had # – not assigned, null, and the field is nothing but a blank. We usually treat “#” as a value, which telling us the value is not ready yet. In this example, we would like to take the blank field as the definition of “empty”.

Q2, how the records will be show?

Do we need to show the most detailed records? If we did that, we will get lots of blanks for we can not ensure the fields we are going to restrict had the smallest granularity. So, please remember to check the option: use DB aggregation.

Q3, how to restrict the fields to be”not empty”?

Thanks to SAP friendly GUI, it is not an easy work to find the right way to give this selection. Please see the sample provide here. You need to double click at the field’s name to choose the not equal option and leave the blank there. Other ways are not correct.

[CH] 撒泼的MMI一向鬼斧神工，如何在这样的界面下输入End User的值是非空呢？
不是猛击那个箭头标志然后输入not assigned. 而是要猛击没有任何标识的End User, 蹦出的框里选不等于。然后就完了。记得要选Use DB aggregation哦。

example:

this is not correct:

remember to check this option:

input the restriction:

By ZZ