DESCRIPTION
Users testing connectivity from Strategy against MDX data sources like Essbase Microsoft SQL Server Analysis Service or IBM Cognos TM1 can use a tool provided within the Strategy installation called XMLA Test tool. For additional information regarding this tool, users can refer to the article shown below:
https://community.Strategy.com/s/article/ka1440000009IjAAAU/KB14715-How-to-use-the-XMLA-Connectivity-Test-Tool-available-in
By default the Strategy XMLA Test tool will try to connect using 'Integrated' authentication in its first attempt so, if it is not configured / selected, users can potentially receive the response "HTTP/1.1 401 Unauthorized" in the first step.
However, after this attempt, the tool will automatically issue a second call to try to connect to the data source using the specified type of authentication. The second response ("HTTP/1.1 200
OK") indicates that the connectivity has been successfully established.
ACTION
The appearance of the first error is expected and no action is required. Shown below is a full example of the expected messages from the XMLA test tool including the "HTTP/1.1 401 Unauthorized" response.
Welcome to XMLATest. Please type the target URL, starting with http: http://server.domain.com:8080/StrategyXmla/StrategyXmla.asmx Do you wish to use Kerberos authentication (y/n) ? n Please type the UID to login to that URL. If no UID needed, just press <ENTER> key: user1 Please type the password to login to that URL. : pass1 Please type the name of the DataSource on XMLA source. If unknown, just press <ENTER> key: tm1 Please type the name of the Catalog on XMLA source. If unknown, just press <ENTER> key: tutorial_sample
* About to connect() to server.domain.com port 8080 (#0) * Trying 10.10.11.12... * connected * Connected to server.domain.com (10.10.11.12) port 8080 (#0) > POST /StrategyXmla/StrategyXmla.asmx HTTP/1.1 Host: server.domain.com:8080 Accept: */* Content-Type: text/xml soapaction: "urn:schemas-microsoft-com:xml-analysis:Discover" Content-Length: 559 < HTTP/1.1 401 Unauthorized < Content-Length: 1656 < Content-Type: text/html < Server: Microsoft-IIS/6.0 < WWW-Authenticate: Basic realm="server.domain.com" < X-Powered-By: ASP.NET < Date: Thu, 15 Nov 2012 18:02:52 GMT < * Ignoring the response-body * Connection #0 to host server.domain.com left intact * Issue another request to this URL: 'http://server.domain.com:8080/StrategyXmla/StrategyXmla.asmx' * Re-using existing connection! (#0) with host server.domain.com * Connected to server.domain.com (10.10.11.12) port 8080 (#0) * Server auth using Basic with user 'user1' > POST /StrategyXmla/StrategyXmla.asmx HTTP/1.1 Authorization: Basic YWRtaW46YXBwbGU= Host: server.domain.com:8080 Accept: */* Content-Type: text/xml soapaction: "urn:schemas-microsoft-com:xml-analysis:Discover" Content-Length: 559 < HTTP/1.1 200 OK < Date: Thu, 15 Nov 2012 18:02:54 GMT < Server: Microsoft-IIS/6.0 < X-Powered-By: ASP.NET < X-AspNet-Version: 2.0.50727 < Cache-Control: private, max-age=0 < Content-Type: text/xml; charset=utf-8 < Content-Length: 4524 < * Connection #0 to host server.domain.com left intact * Closing connection #0 Get SOAP reply: ================================ <row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>Strategy Tutori al</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sampl e</CATALOG_NAME><CUBE_NAME>}CellSecurity_Strategy Tutorial</CUBE_NAME><CUBE _TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CU BE_NAME>}ClientGroups</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_ NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}ClientProperties</CUBE_NAME><CUBE _TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CU BE_NAME>}ClientSettings</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALO G_NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}CubeProperties</CUBE_NAME><CUBE _TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CU BE_NAME>}DimensionProperties</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><C ATALOG_NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}ElementAttributes_Customer </CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample< /CATALOG_NAME><CUBE_NAME>}ElementAttributes_Date</CUBE_NAME><CUBE_TYPE>CUBE</CUB E_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}Elemen tAttributes_Geography</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_ NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}ElementAttributes_Product</CUBE_N AME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG _NAME><CUBE_NAME>}ElementAttributes_}Clients</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TY PE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}ElementAtt ributes_}Groups</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>t utorial_sample</CATALOG_NAME><CUBE_NAME>}HierarchyProperties</CUBE_NAME><CUBE_TY PE>CUBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CUBE_ NAME>}StatsByClient</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_NA ME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}StatsByCube</CUBE_NAME><CUBE_TYPE>C UBE</CUBE_TYPE></row><row><CATALOG_NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME >}StatsByCubeByClient</CUBE_NAME><CUBE_TYPE>CUBE</CUBE_TYPE></row><row><CATALOG_ NAME>tutorial_sample</CATALOG_NAME><CUBE_NAME>}StatsForServer</CUBE_NAME><CUBE_T YPE>CUBE</CUBE_TYPE></row></root></return></DiscoverResponse></soap:Body></soap: Envelope> ================================ End of XMLATest run. Press <ENTER> to quit.
