Choosing between IF/ELSEIF/ELSE and CASE/WHEN expressions for categorizing a dimension — when CASE is more appropriate and its limitation with complex conditions.