SSAS: change boolean to 'yes' or 'no'

Question

Hello, i'm new to Analysis Services. I have created a dimension on a boolean column. Now users want to have 'yes' and 'no' instead of 'true' and 'false' as result. Thanks.

Answer 1

Create a calculated column in your DSV which provides the label you want.

case when column = 0 then 'No' else 'Yes' end