The Oracle OLAP DML supports two types of IF...THEN....ELSE constructs:
As a conditional expression within an OLAP DML statement as described in IF...THEN...ELSE expression.
As a flow-of-control statement within an OLAP DML program as described in IF...THEN...ELSE command.