Let us know how we can make Jedox even better!
In SQL we have a lot of nice functions to handle null.
A very nice example is ISNULL() gives you the possibility to return and altenate value when the value is null, and if not null then it returns the value you are evaluating.
Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.
Note that ISNULL() already and we plan to add a CASE statement in rules in the future.