How to control caption for the bit attribute?

Hi Gurus,

Have anybody idea how to control the caption of bit attribute?

The default is True/False.

1. How to force the AS to show Y/N or Yes/Now еtс.
2. How to force the AS to show localized bool string (Wahr/Falsch, Истина/Ложь).

I can create table like

ID Caption

0 Yes
1 No

Or calculated fields in UDM

but all it awkward.

I have about 50 bit attributes in all my dimensions. It would be too expensive to devote so much attension to every bit attributes.

If you have a table as described, with a bit column (ID in your example) and a character column with the value you want displayed (Caption in your example), then you can create the attribute in your dimension so that it uses ID as the KeyColumn for the attribute and Caption as the NameColumn for the attribute. When you do this, AS manages the attribute internally using the values of the ID column, but it will display to the end user the values of the Caption column.

For localized versions, extend your table design to include additional localized captions. Then, in the dimension design, go to the Translations tab and set up a translation for the dimension. This would include defining the Windows locale that the translation applies to and identifying the column that contains the localized captions for the attribute in question.

HTH,

Dave Fackler

|||

but all it awkward.

I have about 50 bit attributes in all my dimensions. It would be too expensive to devote so much attension to every bit attributes.

For every bit attribute I have to JOIN a "caption" table, then I have to set separate Name column. It's to expansive.

It would be made no pleasure :-(

|||

It would be too expensive to devote so much attension to every bit attributes

Can you devote this attention just to one such attribue, and make all other dimensions role playing with this one ?

|||

Hi, Mosha

If it was a dimension then there was no problem. But I speak about attributes of one dimension. I seems to be inpossible to have "role plaing" attribute. I have made one DSV virtual table and have made correspondents virtual foreign keys to it in order to "translate" more then one bit attribute of my dimension, but AS doesn't make it right :-(

sql