C# Response from XMLA (using BW SAP) french characters as ??

Question

Hi, 

 

I am using .Net Framework 4 C# web service project. 

I am connecting with XMLA server (using as web reference) in my C# project. The issue seems to be able to handle the French characters once i am getting response back from the XMLA execute method. 

At this moment the data is coming back as '??' whenever it contains french special characters.

I am pasting the code below and would appreciate help at earliest. 

 

sapqasbwi.MsXmlAnalysis _sMxlA = new sapqasbwi.MsXmlAnalysis();   // Create XMLA reference object. 

System.Net.NetworkCredential _nc = new System.Net.NetworkCredential();  // Creating Network credentials object

_nc.UserName = userid;

_nc.Password = _password;

_sMxlA.Credentials = _nc.GetCredential(new System.Uri(url), "Basic");

_sMxlA.Url = url;

sapqasbwi.ExecuteCommand cmd = new sapqasbwi.ExecuteCommand();

cmd.Statement = stText;    // sText contains the query 

_bwPropertyList.DataSourceInfo = "default";

_bwPropertyList.Format = "Tabular";

_bwPropertyList.AxisFormat = "ClusterFormat"; 

_bwPropertyList.Content = "SchemaData"; 

_bwParameters.PropertyList = _bwPropertyList;

_sMxlA.RequestEncoding = System.Text.Encoding.GetEncoding("ISO-8859-1");  // already tried utf 8 

//Execute BW Query

System.Xml.XmlElement returnXML;

returnXML = _sMxlA.Execute(cmd, _bwParameters); // Execute method only returns an XML element object. 

 

This particular object is containing the '??' whenever a french character is found.

 

 Please help at earliest. 

 

 

Regards

 

Saturn