Hi am rather instenively using the xamPivot-controls just now in order to migrate my applications, so I am afraid I will be rather active on this forum for a while.
I have a xamPivotDataSelector and a xamPivotGrid connected with the XmlaDataSource to MS analysis server 2008 databases. This all works fine exept that where data or dimension names contain our nordic characters it is presented like "Alle overføringer" which should read "Alle overføringer".
I first wondered if this was because of some xmlaDatsource settings missing on the IIS server, but when I use the same connection from Excel, everything is correct.
How do i get past this problem? i am afraid suggesting our customers to rename their employees and customers will be rather badly received :-)
Hi,
please could you take a look at this forum post http://community.infragistics.com/forums/t/51428.aspx where was discussed just a situation. Is it your case the same?
Thanks,
Dimitrina
Hi again,I really hope someone are still trying to find a solution to this. I think I have managed now to find ways to solve everything else in my current project, but this is preventing me from being able to present it to my customers (which I am supposed to do in a week from now).
I would not be surprised if the solution is a quite simple method or setting that I am missing, but after having spent two full days on it I still have not been able to figure it out.
Hello Jorvart,
Could you please send me a snapshot of situation in order to have a visual of where this text is displayed wrong.
Regards.
No problem at all.
Here you have a section of my customer dimension (country-customer) as displayed in the xamPivotGrid.
The two first entries should have read 'Færøyene' and 'Grønland'. Also the first of the customers should have been '(1004) Askim Frukt- og Bærpresseri'
Regards Jorvart
Hello again,
I think it's possible to be issue with the encoding because the WebClient in WPF uses the Encoding.Default to encode/decode the bytes when it downloads/uploads the messages. Could you try to change your system locale to points to Norwegian. If that works for you we can provide a fix that will extract the right encoding from LCID passed to the connection properties.
Regards.Plamen.
Hi, and thank you for your efforts.
Well I thought about this, and did what you suggested a couple of days back. My computer now has the language settings for Norwegian, but this does not seem to affect my application at all.
To validate my settings I put following settings into the MainWindows() method:
string cult=CultureInfo.CurrentCulture.Name;Encoding enc=System.Text.Encoding.Default;
CultureInfo.CurrentCulture.Name returns "nb-NO" (as it should), and you will find the values in the enc object in the screenshot below.
I might add that to test if this was a problem in my whole solution, I populated a xamDataGrid with data from the SQL-server containing all of our 'problematic' characters, and this was presented just as it should.
Regards
Jorvart
Btw. i use AdomdDataSource
Hi
I have the same problem with culture = 'cz-CZ'.
In Excel everityhing ok, but in the Pivot grid is data wrong.
I have instaled last service release (20103.2116)
Hi, I see now that your latest service release has solved this issue.
Thank you Plamen,
I will look forward to the service release, and am happy with the fokus and commitment you and and your company have on solving your customers problems.
Hello,
I think that we definitely can consider it as a bug in WPF version. What documentation says about encodings used by XMLA row-sets is as follow:
“… XML for Analysis (XMLA) supports encoding as defined by Microsoft SQL Server.”
Also it seems that UTF-8 encoding is the one used by XMLA. In next few days you can expect the next service release where we’re going to fix this issue. We’ll set UTF-8 to be default encoding used when the XMLA message is encoded/decoded and also there will be an option to the user to change it if it’s needed. I’ve made couple of tests with UTF-8 and I was able to display correctly these ‘problematic’ symbols and some Cyrillic symbols as well.
Best regards.
Plamen.