CODEWITHSUNDEEP
c#ssasolap-cube
user265732
user265732

Reputation: 585

Microsoft Analysis - how to set dimension to show bit as True/False instead of 1/0

I'm writing a program to process a cube using Microsoft Analysis, and I want bit values to be shown as True/False whenever I browse the cube (lets say in Excel).

I've managed to show null values as some string using 'Unknown', but I can't figure how to do the same with the actual values.

P.S. I do not want to convert it by using a CASE query in the DSV table creation. I want it to be only at the Dimension level.

Thanks.

Upvotes: 0

Views: 217

Answers (1)

Mike Honey
Mike Honey

Reputation: 15037

You might "not want" to rely on a CASE statement in the DSV, but SSAS doesn't give you any other options to achieve what you want. So hold your nose and start coding...

FWIW - I prefer a SQL View (rather than calculations in a DSV) for more re-use and easier testing.

Upvotes: 1

Related Questions