Re: How to handle boolean field

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

"Henrik Skak Pedersen" <skak@xxxxxxxxxxxxxxxx> wrote in message
news:ubDTHv6QGHA.5908@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%237kOYf6QGHA.5500@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> wrote in message
news:OclPBV6QGHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
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.







.

Relevant Pages

  • Re: How to handle boolean field
    ... Do you know how I translate values in a table? ... The approach I ended up taking was to snowflake in a BoolValues table. ... ended up converting the bit column to an int column (although that might ... in my data source view. ...
    (microsoft.public.sqlserver.olap)
  • Re: How to handle boolean field
    ... Do you know how I translate values in a table? ... If your database is SQL Server 2005 and you use the SQL Native client ... The approach I ended up taking was to snowflake in a BoolValues ... in my data source view. ...
    (microsoft.public.sqlserver.olap)
  • Re: How to handle boolean field
    ... The approach I ended up taking was to snowflake in a BoolValues table. ... converting the bit column to an int column (although that might not have ... Localizing the result just requires translating the ... my data source view. ...
    (microsoft.public.sqlserver.olap)
  • Re: Bind Checkbox to a data source ?
    ... The Binding class has two events - Format and Parse. ... translate values during the binding process. ... > How do I bind a checkbox to a data source? ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: vs2005 & Crystal Questions for the Gurus
    ... company I am printing invoices for. ... you have to use a DataSet as the data source and fill it from your code. ... [How to Upload or Change an image in the Crystal Report at runtime] ... but it's very little code and I think you can figure out yourself how to translate it to VB. ...
    (microsoft.public.vb.crystal)