Hi
I have a fact table that is using unicode data types.
When I process my olap db, it isn't accepting my Unicode
characters (they're coming out as ? characters).
I found an article that states that the OLAP Data type
should be either:
BSTR
WChar
or
VarWChar
in order to hold Unicode data types.

How do I change the data types within the OLAP database so
that I can see my Unicode characters?
Thanks
H

SSAS is natively Unicode there is nothing special you need to do to use it.
Either the problem is the source database supplying the data; or the
front-end tool you are using to view it (not all tools support Unicode).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"H" <anonymous (AT) discussions (DOT) microsoft.com> wrote

The database is correctly showing the characters but as
soon I browse say the dimension in the OLAP database, it
comes up with the ? characters. I found where to change
the OLAP datatype to WChar (as opposed to nChar in the
database) and Analysis Services was correctly using WChar
anyway.
Can you perhaps think of any other way I can get to see
the special unicode character in A/s?
Thanks
H

To clarify:
There is nothing wrong with the source data (I can see all
special unicode charaters correctly)
Also, the tool I am using to view the data is Analysis
Service's "browse data"
Thanks
H

Hi,

You need to install the required multi-byte font in your system where you
are viewing the dimension. If it doesn't work, try opening the dimension
through MS EXCEL or anyother Reporting tool

Regards

Seetha

"H" wrote:

Hi Seetha
Thanks so much for your reply. You've given me new hope!
How do I get this "mutli-byte font" installed on my
system? Is it a product that I must buy?
Many thanks
H

Which language you are working on (linguistic). Pick up the common font from
any of the sites or ask the user to send you the font they are using on their
pc. The easiest way is to Install the default Windows fonts available in the
Windows Cd

Regards
Seetha

"H" wrote: