Excel，无法连接到XMLA XMLA服务

Question

我尝试在Excel中创建到XMLA Web服务的连接。我正在使用Analysis Services连接助手。我用web服务url和凭证填充第一个掩码。然后我在服务器上收到10个DISCOVER_PROPERTIES和1个DISCOVER_SCHEMA_ROWSETS请求。在最后一次DISCOVER_SCHEMA_ROWSETS之后，我在excel中得到了一个通知(没有错误对话框)，告诉我数据连接助手在给定的数据源中找不到数据库列表。在哪里可以获得有关发生的错误的更多信息？我非常感谢您的帮助！

DISCOVER_SCHEMA_ROWSETS消息：

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="D5C7494A-14DC-47F4-B9A5-AC6A487BCC38"/>
  </soap:Header>
  <soap:Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
      <RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType>
      <Restrictions>
        <RestrictionList/>
      </Restrictions>
      <Properties>
        <PropertyList>
          <LocaleIdentifier>1031</LocaleIdentifier>
        </PropertyList>
      </Properties>
    </Discover>
  </soap:Body>
</soap:Envelope>

和DiscoverResponse：

<?xml version="1.0" encoding="UTF-8" ?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <SOAP-ENV:Body>
    <DiscoverResponse xmlns="urn:schemas-microsoft-com:xml-analysis">
      <return>
        <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset">
          <xsd:schema xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified">
            <xsd:element name="root">
              <xsd:complexType>
                <xsd:sequence minOccurs="0" maxOccurs="unbounded">
                  <xsd:element name="row" type="row"/>
                </xsd:sequence>
              </xsd:complexType>
            </xsd:element>
            <xsd:complexType name="row">
              <xsd:sequence maxOccurs="unbounded" minOccurs="0">
                <xsd:element name="SchemaName" type="xsd:string" minOccurs="0" maxOccurs="1" sql:field="SchemaName"/>
              </xsd:sequence>
            </xsd:complexType>
          </xsd:schema>
          <row>
            <SchemaName>DISCOVER_DATASOURCES</SchemaName>
          </row>
          <row>
            <SchemaName>DISCOVER_PROPERTIES</SchemaName>
          </row>
          <row>
            <SchemaName>DISCOVER_SCHEMA_ROWSETS</SchemaName>
          </row>
          <row>
            <SchemaName>DISCOVER_ENUMERATORS</SchemaName>
          </row>
          <row>
            <SchemaName>DISCOVER_KEYWORDS</SchemaName>
          </row>
          <row>
            <SchemaName>DISCOVER_LITERALS</SchemaName>
          </row>
          <row>
            <SchemaName>DBSCHEMA_CATALOGS</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_CUBES</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_DIMENSIONS</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_MEASURES</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_HIERARCHIES</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_LEVELS</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_MEMBERS</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_PROPERTIES</SchemaName>
          </row>
          <row>
            <SchemaName>DBSCHEMA_COLUMNS</SchemaName>
          </row>
          <row>
            <SchemaName>DBSCHEMA_PROVIDER_TYPES</SchemaName>
          </row>
          <row>
            <SchemaName>DBSCHEMA_TABLES</SchemaName>
          </row>
          <row>
            <SchemaName>DBSCHEMA_TABLES_INFO</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_ACTIONS</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_FUNCTIONS</SchemaName>
          </row>
          <row>
            <SchemaName>MDSCHEMA_SETS</SchemaName>
          </row>
        </root>
      </return>
    </DiscoverResponse>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Answer 1

首先，将webservice的URL放入浏览器中进行测试，看看是否正常工作。

你可以下载Microsoft Office XP Web Services Toolkit，它在VBA界面中提供了一个插件。该插件允许您为webservice指定路径，并为您创建类。您可以使用此类并调用the服务中的函数。