(I am using Analysis Services in case you are wondering...)

I have a cube, and in the fact table there is a column, where the values are
bit (ie boolean, true/false etc etc)

I created a dimension from this column (right click on the column name in
the cube editor, select 'Insert as Dimension')

When I process my cube and go to view the data, the values that I get for
this dimension is 0 and -1.
I swear before when I did it, I got 'True' and 'False', but now I can't seem
to change it so it says that.

What I want to know - is there anyway I can get the 0 and -1 and change
these values to something more meaningful eg true and false ?

The thing is, I will be giving these cubes to the marketing people and they
wont understand what 0 and -1 means

Hi,
To get the Members as True or False,
You can cast the Member Name Column as follows:

CAST("dbo"."table_name"."field_name" as bit)

Note: Member Name Column is under the Properties window
for the Particular Dimension.

Regards,
vanchi