I have a column in the fact table: Sex: M or F. And I want to add a
calculated member (in the Cube Editor) to tell the count of M. I added the
following express in the calculated member express text box:

iif([Sex].[Sex]="M", 1, 0)

However, it always has syntax error. How to write the right one? Thanks. (I
know I can created a view do the convert, however, I want to try on Cube
level.)