Posted: 1/29/2012
Hi all,
This is my first post here, and I searched the forums pretty thoroughly before, to make sure this wasn't discussed already.
I'm developing an SSAS cube with data from a TeraData DB, using a .NET Provider for TeraData.
Some of the data are dimension members written in Hebrew.
In the Connection Manager of the Data Source the Session Character Set property is set to ASCII.
Now, when i'm exploring table data (e.g. from the DSV), I see all Hebrew members displayed correctly. However, when browsing the processed cube, members are displayed in Gibberish (e.g. äìáùä).
I tried changing the Character Set to UTF8 but it didn't help. Is it a provider issue or perhaps RDBMS definitions which should be configured by the TeraData DBA?
Thanks in advance!