Only Saturn

Only Saturn

  • NA
  • 1
  • 1.6k

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

Apr 2 2014 11:01 AM
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