soap - icCube XMLA request documentation -


is there documentation on how formulate request xmla?

the iccube xmla endpoint me is: http://localhost:8282/iccube/xmla

i want make demo call endpoint using postman or similar, not sure parameters pass in soap request.

i have tried:

<x:envelope xmlns:x="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:schemas-microsoft-com:xml-analysis">     <x:header>         <urn:session sessionid="?" mustunderstand="?"/>         <urn:beginsession mustunderstand="?"/>         <urn:endsession sessionid="?" mustunderstand="?"/>     </x:header>     <x:body>         <urn:execute>             <command>                 <statement>                      select                           {[customers].[geography].[all regions].[north america].[canada].[ottawa]} on columns,                          {[measures].[count]} on rows                      [sales]                 </statement>             </command>             <properties/>         </urn:execute>     </x:body> </x:envelope> 

and empty response:

<soap:envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">     <soap:header>         <session sessionid="1hb96vaa7acol14bj97tyokd4f" xmlns="urn:schemas-microsoft-com:xml-analysis"/>     </soap:header>     <soap:body>         <executeresponse xmlns="urn:schemas-microsoft-com:xml-analysis">             <return>                 <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"/>             </return>         </executeresponse>     </soap:body> </soap:envelope> 

does know can find more information on how make request? iccube documentation @ http://www.iccube.com/support/documentation/user_guide/running_iccube/xmla.php non-existent.

thank in advance help.

i had add correct properties information soap call:

<?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>   <execute xmlns="urn:schemas-microsoft-com:xml-analysis" soap-env:encodingstyle="http://schemas.xmlsoap.org/soap/encoding/">     <command>         <statement>            select                 {[customers].[geography].[all regions].[north america].[canada].[ottawa]} on columns,                {[measures].[count]} on rows            [sales]         </statement>     </command>     <properties>         <propertylist>             <catalog>sales</catalog>         </propertylist>     </properties>   </execute>  </soap-env:body> </soap-env:envelope> 

the best documentation have been able find xmla xml analysis specification.


Comments