Hi,

I have a boolean field in my table which is represented by a bit data type.
I would like to show 0=No and 1=false. I know that I can solve it in my data
source view. But I would like to translate the result into different
languages, so that is not the best solution.

I need to create an attribute based on the value.

Any ideas?

Thanks

Henrik.

I posted almost the identical question a little while back (though I never
really got a workable suggestion). Here's what I came up with on my own.

1) If your database is SQL Server 2005 and you use the SQL Native client as
the provider, SSAS will automatically display bit fields as True and False.
Note that if you use the managed SqlClient provider, this doesn't work (I've
reported this as a bug). Of course, if you want Yes/No rather than
True/False, then this doesn't help.

2) The approach I ended up taking was to snowflake in a BoolValues table.
The table had columns BoolValue_key and BoolValueName - (0, No), and (1,
Yes). Then I joined the dimension table to the BoolValues table, and defined
an attribute with NameValue set to BoolValueName. Note that I ended up
converting the bit column to an int column (although that might not have
been necessary). Localizing the result just requires translating the
BoolValueNames for the two rows in the BoolValues table.




"Henrik Skak Pedersen" <skak (AT) community (DOT) nospam> wrote

Hi Kevin,

Thank you very much for your reply.

I think that I then have to go for option 2, because I have to run on 2000
too. Do you know how I translate values in a table?

Thanks

Henrik.

"Kevin Dente" <kevind (AT) no (DOT) spam.denteworld.com> wrote

Hello,

Based on my scope, it seems more appropriate to implement this localization
on client side other than server side.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

By "translate" I meant insert rows with the translated form of
Yes/No/True/False/Whatever into the BoolValues table.

"Henrik Skak Pedersen" <skak (AT) community (DOT) nospam> wrote

Peter,
Interesting. Can you clarify? How would translate on the client-side when
using Excel pivot tables, for example?

Kevin

"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote

Hello Kevin,

When you use reporting service or other client control that using ADOMD or
ADOMD.net to fill, you possiblely could use code to show the 1/0 as
True/False with proper language.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
<ubDTHv6QGHA.5908 (AT) TK2MSFTNGP14 (DOT) phx.gbl>
<PUgcBKBRGHA.5524 (AT) TK2MSFTNGXA03 (DOT) phx.gbl>