SAP BPC 10.1 (MS) Reporting via BO 4.2

[alexdc12]

Hi

We have a requirement to utilise data from our BPC 10.1 MS installation, in the CMC under OLAP Connections i see the option for a BPC 10 MS connection. I have used SAP Note 2192074 to setup XMLA on the BPC server but i cannot get the OLAP Connector to work. If i try from the IDT i get an error that says

com.businessobjects.mds.olap.protocol.xmla.internal.XMLAException: Description: Authorization failed.

Any help would be greatly appreciated!

Thanks

[denis_konovalov]

I have fixed your primary tag to better match context of your question. Please select more careful next time.

[alexdc12 · Accepted solution]

The problem was the Network Service not having authorisation to the Database.

[alexdc12]

The problem was the Network Service not having authorisation to the Database.

[alexdc12]

here is the SOAP response from the BPC server

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<soap:Fault>
<faultcode>soap:Client</faultcode>
<faultstring>System.Web.Services.Protocols.SoapException: The request contains an error.
at Simba.Xmla.XmlaWebService.Execute(CommandStatement command, Properties properties)</faultstring>
<faultactor>http://bpcdev/xmla/xmlawebservice.asmx</faultactor>
<detail>
<Error ErrorCode="0" Description="Authorization failed." />
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>