Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes.
How can I create a calculated member in Analyzer using MDX for the following logic?
WHEN 'F' THEN 'FEMALE' WHEN 'Female' THEN 'FEMALE' WHEN 'M' THEN 'MALE' WHEN 'Male' THEN 'MALE' WHEN 'U' THEN UNDIFFERENTIATED' WHEN 'UN' THEN UNDIFFERENTIATED' WHEN 'Undifferentiated' THEN UNDIFFERENTIATED' ELSE 'OTHER' END