Web Service response from XMLA (using BW SAP) returns french Accent characters as question marks '?' RRS feed

  • Question

  • I am using .Net Framework 4 C# web service project. 
    I am connecting with XMLA service (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

    The output i am receiving is as follows 

       <MainService>Entreposage ?? long terme</MainService> 
     <MainServiceStatus>Service Termin??</MainServiceStatus> 
     <TransactionID>1000006216_10_Cde client standard</TransactionID> 

    Friday, May 2, 2014 1:44 PM


All replies