Metric conditional on attribute element

[bmcwest]

I am trying to create an olap metric (template level) that returns a hard-coded value based on the intersecting attribute element of an attribute. i.e. Attribute Gender: if attribute element in row is "M" then metric will display 1, if "F" then display 2. Nothing fancy just need to conditionally return a metric value based on an attribute value. I know how to solve with an applysimple but we want to use the i-server rather than pass-through. I have tried using a case but it will not validate (refuses to allow an attribute).

Any suggestions would be greatly appreciated.

 

[nlim]

more text on the case function from the manuals.

CASE (A=2, T, B>5, U, V)
When A=2, return T; when B>5, return U; otherwise return V.
Note
You must drag and drop all arguments onto the editor. If you type any arguments the function will not validate.