Tim Schmelter
Tim Schmelter

Reputation: 460340

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

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.

Upvotes: 4

Views: 3765

Answers (1)

Neil Knight
Neil Knight

Reputation: 48597

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

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

Upvotes: 7

Related Questions