3.1.4.58 BixDrill

  • Article

Applies a drill operation to the PivotTable and displays PivotCache hierarchy members at the defined level. This will result in a query.

The following is the WSDL port type specification of the BixDrill WSDL operation.

 <wsdl:operation name="BixDrill" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/BixDrill" message="tns:ExcelServiceSoap_BixDrill_InputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:output wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/BixDrillResponse" message="tns:ExcelServiceSoap_BixDrill_OutputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:fault wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/BixDrillExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_BixDrill_ExcelServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
 </wsdl:operation>

The protocol client sends an ExcelServiceSoap_BixDrill_InputMessage request message, and the protocol server responds with an ExcelServiceSoap_BixDrill_OutputMessage response message, as follows:

  1. The protocol client sends information identifying the PivotTable/PivotChart in the pivotOperationOptions element, and PivotTable field information (including how it is changing) in the pivotFieldApplyData element.

  2. The protocol server applies the PivotTable field information to the PivotTable/PivotChart.

This operation is a state changing operation on the protocol server.

In the event of an application error on the protocol server during this operation, a SOAP fault is returned, as specified in section 2.2.2. The Id element of the ExcelServerMessage SHOULD<75> be one of the values specified in section 2.2.2.1 or any of the following values:

  • DclNotTrusted

  • ErrorAccessingSsoFromEcs

  • ErrorConnectingToDataSource

  • ErrorConnectingToDataSourceReadOrViewOnly

  • ExternalDataNotAllowedOnTL

  • ExternalDataRefreshFailed

  • ExternalDataRefreshFailed_Details

  • ExternalDataRefreshFailedReadOrViewOnly

  • ExternalDataRefreshFailedReal

  • IncorrectAuthUsed

  • InvalidUriorLocalConnectionPath

  • InvalidUserNameOrPassword

  • InvalidUserNameOrPasswordReadOrViewOnly

  • NoAccessToOdcReadOrViewOnly

  • OdcFileDoesNotExist

  • UnattendedAccountNotConfigured

  • RetryOutOfSync

  • UnexpectedPivotError